How to extract data from website to excel?
1 answer(s)
Answer # 1 #
Your best bet is Excel's built-in tool. Go to the 'Data' tab on the ribbon. Then, select 'From Web'. Just paste the website's URL in there. Excel will then show you all the tables on that page. You just pick the one you need and load it. It's a real game-changer and much cleaner than copy-pasting. For a super simple table, a quick copy and paste can also do the trick, no worries.