How to Import Data from HTML into Excel

Date:2019-8-1 Author:Cordelia

If you have some brilliant tables on your computer but not in Excel format, can you import the data from them to Excel directly? In one of my previous post I’ve introduced how to convert TXT to Excel. Here I’d like to share the tip of importing the data from HTML to Excel as well.

1. Open an Excel file. Switch to Data tab and click Existing Connections in Get External Data section.

How to Import Data from HTML into Excel

2. Click Browse for More… in the lower-left corner of the popping out window.

How to Import Data from HTML into Excel

3. Find the HTML file you want to import in the folder, then double-click it or hit Open.

How to Import Data from HTML into Excel

4. As suggested by the tip, click the arrow icon to select the area of data then hit Import in the lower-right corner of the window.

How to Import Data from HTML into Excel

How to Import Data from HTML into Excel

5. You can locate the new table at an existing worksheet or a new worksheet. Choose the location to put the data, then click OK.

How to Import Data from HTML into Excel

6. The table in the HTML file has been imported into the Excel sheet. You can adjust it freely now.

How to Import Data from HTML into Excel

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

5 responses to “How to Import Data from HTML into Excel”

  1. boyd says:

    excellent advice

  2. Sanjay Sarma says:

    I note that the hyperlinks in the html table columns are lost while importing to Excel.
    Is there anyway to copy that the hyperlink information into excel (not just the link name as text).

    • Sandra says:

      You can just double-click the link and highlight any other cell, you will find that your Link in text format become a Hyperlink

  3. Wui Keong says:

    thank you very much for the lesson.
    this help me a lot

  4. Glen says:

    I am not getting the import data box to tell it where to go what am i missing

Leave a Reply

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