Import Web Data In Excel

Click on the 'New Query' option from Excel's Data tab and then choose 'From Web' from the Other Sources list. Type or paste the URL of the page that contains the data you wish to import and refresh. Use the previews generated by Excel to find the table that contains the data you need. When you find it, click 'Load'. The data will appear in your worksheet.

Now, refresh your data by right-clicking in the table and choosing 'Refresh' from the context menu. Use this tactic rather than pasting the table directly into Excel, to update it conveniently without repetitive cut-and-paste processes. You will find that you save time and aggravation by letting Excel do the hard work for you.