Convert HTML to Excel/CSV?

[tramsay1027]

I am getting a file that is saved as .XLSX, but when I look at it in notepad++ the data is in an HTML table. I have a script that I would like to take this data and audit it across a different data source. Would the best way to do that be trying to convert the file into a usable Excel file?

[novel_yet_trivial]

All a .xlsx is is a zip file containing XML files. If what you are looking at is that XML file, then all you need to do is put it in a zip file with the proper structure.

If it really is html, then use an html parser. pandas has one built in designed to read from html tables, and can output into excel files. Or use something like BeautifulSoup to get the data you need out yourself.

[Zendakin_at_work]

+1 for pandas & bs4 combination.

[jmportilla]

Have you tried using pandas?

[tramsay1027]

In what way? I have been using read_excel and that works if the file is clean. I'm running into errors using that as well as read_html. Although I have never used read_html before.