How can I convert an Excel spreadsheet to HTML with Python?

Question

I have several .xlsx Excel spreadsheets that I'd like to convert to an HTML web format by using a Python script. How can I do this?

Al Sweigart · Accepted Answer · 2023-05-01 16:53:03Z

3

You can do this in Python with Pandas. Install Pandas by running pip install pandas from the terminal/command line.

Then run the following code to create a spreadsheet.html file from a spreadsheet.xlsx file:

import pandas as pd
df = pd.read_excel('spreadsheet.xlsx')
with open('spreadsheet.html', 'w') as fo:
    fo.write(df.to_html())

answered May 1, 2023 at 16:53

Al Sweigart

13.2k14 gold badges76 silver badges98 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Just a heads up, opening the file manually isn't required. Just hand DataFrame.to_html() the path to write to as shown here.