Question: how to import data from html into excel?
Answer: Open Excel.
Select Data > From HTML.
Navigate to the location of your saved HTML web page, select it, and select Open.
Excel automatically imports the entire web page into a new workbook.