Did you know …?

You can pull table information directly from a Website on the Internet into Excel quite easily. “Cut & Paste” does not always work well, often merging cells and setting formats that are quite difficult to manage and contradict data rules that would allow for sorting, etc.

The Data menu has a tool available for bringing Internet information into Excel cleanly.

Position in your worksheet where you would like your data to appear. Select Data menu > Import External Data > New Web Query … Use the New Web Query dialog box to navigate to the website information you desire. You will notice a number of small arrow buttons located to the left of each distinct unit of data within the webpage. Click the arrows to select the table(s) of data you wish to import. Once your selections are made, click the Import button. Press the OK button to consent to the location for the information to be placed.

You will notice a special External Data toolbar appears. This allows you to click Refresh (!) button to re-summon the website table for any changes. If you wish to remove the link to the website data, click the Data Range Properties button on the External Data toolbar, and remove the checkmark from Save Query Definition.