Connect with us

How to Import HTML Tables to Excel Sheet

Microsoft Office

How to Import HTML Tables to Excel Sheet

Microsoft Office Excel has a good feature of importing tables from HTML pages, so in case you found some interesting data in the form of a table in any webpage, you can easily import the data into Excel sheet. For this feature, you do not even need to save the web page to your PC.

1. Open Excel sheet and select the Data Tab in the ribbon. Inside the data tab, click on the button “From Web” in the Get External Data section.

Data tab in Excel

2. This will open up a browser window where you can enter the URL or the webpage which you want to import. Once the page is loaded, you can select the table using the arrow button on the top left corner. Once you have selected table, click Import button below.


3. Excel confirms whether you want to put the data in the current sheet or in a new sheet.

confirm import

4. The data will be imported to Excel using the same formatting of the tables in the webpage.

Continue Reading

Nirmal is a Technology Blogger and a Microsoft MVP in Windows. He can be contacted at You can find Nirmal on , and .



  1. Giles Davidson

    March 29, 2011 at 5:28 pm

    The import actually does not maintain formatting correctly. If an HTML table cell has multiple paragraphs the cell is split into multiple cells instead of being imported into a single cell with a soft return (shift-return) between the paragraphs.
    This is on a par with the broken CSV import which will splits CSV records into multiple rows if new lines are incvluded in a quoted string. Access by contrast does the right thing.
    Hopefully MS will fix this one day.

  2. praveen

    April 26, 2013 at 6:02 pm

    excellent idea buddy thanks a lot form me

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Recent Articles


Trending Articles

Latest in Windows 10

Subscribe to YouTube Channel

Like Us on Facebook


To Top