Home / Microsoft Office / How to Import HTML Tables to Excel Sheet

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.

import

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.

About Nirmal

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

2 comments

  1. 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. excellent idea buddy thanks a lot form me

Leave a Reply

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

*

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=""> <strike> <strong>