How to import data from the web in Excel: If you manually copy and paste data from a web page into Excel, you might find that all the data gets pasted into one cell.
That's annoying, and requires more copying and pasting.
So, use the web query tool to save time, and make your worksheets more dynamic!
You can use web query to get refreshable (or static) data from your company's intranet or the internet, like (single or multiple) tables, or all the text on a webpage. Here's How
How to Import External data from the web
Just click File > Import External Data > Create New Web Query
Copy the URL of the web page you want to display and paste it into the Address box.
That should be it! Excel will import table data directly, and cleanly into your worksheet. (Web query won't retrieve any photos or graphics)
Using Internet Explorer?
If you use Internet Explorer, you can also import data to excel directly from your web browser.
Just right click on the webpage, and then select "Export to Microsoft Excel" on the shortcut menu.
This should display the New Web Query dialog box in Excel.
*Web browsers can change all the time, so personally, I prefer method one.
101 Reasons to Import Data from a Website
Incorporating data from the web with this feature not only saves time, but it can make your worksheets more dynamic.
The next time you find a table of useful data online, try incorporating it into an Excel worksheet with the web query tool!