Question: how to import data from html file to excel?
Answer: On the File menu, click Import.
In the Import dialog box, click the option for the type of file that you want to import, and then click Import.
In the Choose a File dialog box, locate and click the CSV, HTML, or text file that you want to use as an external data range, and then click Get Data.