- Skill level:
Other People Are Reading
Open the Microsoft Excel spreadsheet that will contain the transferred data from the Web page table.
Click the "Data" tab on the Excel ribbon toolbar.
Click on the "Get External Data" group on the Data tab.
Click the "From Web" option. A pop-up box will appear titled "New Web Query."
Type the URL for the Web page that contains the table data you wish to transfer into Excel. You can also copy the URL from any Web browser and paste it into this field, if desired. Then click the "Go" button. The window will surf to the Web page just as if you were in a Web browser program.
Click on the yellow square icon next to any table you wish to transfer into Excel. If you wish to transfer the entire Web page, click the yellow square at the top left of the page, if it exists.
Click the "OK" button. Excel automatically transfers the selected table and all its contents into the spreadsheet.
Tips and warnings
- You may optionally configure different criteria that manage how Excel handles certain types of Web data. Before pressing "OK" on the Web Query window, press the "Options" button. Here you can specify how Excel works with the different Web page fonts, formats and styles or whether the program should ignore them complete and just import the raw data and text. You can also control how it handles specific HTML language elements, such as "" tags. If your transfer is not what you expected, repeat it after adjusting these settings. It may take a few tries to get the import exactly as you expect.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for