«

»

Excel Tip – How to Import HTML Tables Into Excel

Untitled Document

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.

Import HTML Tables to Excel

Click Full HTML Formatting, then OK.

Excel Tip - Full HTML Formatting

Enter the web address in the address bar, and click GO.

Excel Tip - New Web Query Address Bar

Each table on your web page will be indicated by an arrow, as shown below.

Excel Tip - Yellow Arrow indicating HTML table

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.

Excel Tip - Import Data Dialog Box

 

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!

Get the free Excel ebook

12 Tips to Empower Excel Users

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.

Atlanta Computer Training on Facebook Atlanta Computer Training - LinkedIn Software Tips on Twitter

 

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>