Question: how to export html data into excel in correct format?
Answer: Export data and click on the "Download" link to download the HTML file.
Open your file and right click on your export, select "Save as...", and save the export to your Desktop as Webpage, HTML Only.
Locate the file on your desktop, right click on it and choose Edit.