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.
2. Click Browse for More… in the lower-left corner of the popping out window.
3. Find the HTML file you want to import in the folder, then double-click it or hit Open.
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.
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.
6. The table in the HTML file has been imported into the Excel sheet. You can adjust it freely now.
View Comments (5)
excellent advice
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).
You can just double-click the link and highlight any other cell, you will find that your Link in text format become a Hyperlink
thank you very much for the lesson.
this help me a lot
I am not getting the import data box to tell it where to go what am i missing