Works in Excel 2007, 2010 & 2013
Did you know you can easily import most tables you see on websites into Excel – links and all? It’s simple, once you know where to look.
Just remember: avoid taking credit for copyrighted information, and always make sure to clearly attribute the source of the data.
For my sample table, I am using the 2012 Voter Registration deadline table on the Georgia Secretary of State’s website.
Importing HTML Tables Into Excel – Steps
Click the Data tab.
Click From Web in the Get External Data group.
Click the Options link in the New Web Query box.
Click Full HTML Formatting, then OK.
Enter the web address in the address bar, and click GO.
Each table on your web page will be indicated by an arrow, as shown below.
Click the arrow next to the table you want to import, which will turn it into a check mark.
Click the Import button, and the Import Data box pops up. Indicate where you’d like to import your HTML table, then click OK.
If you are trying to import a large table, the import process may take a minute or two.
Voila! It’s done – save your spreadsheet.
Click to Grab Your Excel Ebook – Free!
About the Author
Jackie Kiadii has 20 years of Excel experience, and teaches the following courses in Excel 2007 and 2010: Certification Prep, Basic through Advanced, Pivot Tables, and Macros/VBA.
Need onsite group training? Call 404.297.6700. Our courses are affordable and customized to your needs. Available for groups of 4 or more students.
