Python – Convert HTML to Xlsx

July 14th, 2021 / by api2pdf /


If you are writing python code, you might be tasked with the strange requirement of converting HTML to a Microsoft Excel (xlsx) file. After some research, you discover that this is not as trivial as you hoped it would be. You might have ended up on stackoverflow seeing old, outdated libraries or confusing answers that ask you to use interop or LibreOffice. Let’s make your pain go away right now.

Our API will take your .html file and convert it to xlsx. Just make sure your HTML is saved as a .html file and accessible at a URL that our service can ingest. For example, see this: — Ideally a file storage provider like S3 or Azure Blob Storage. See the code sample below.

Generate Excel or .xlsx file from HTML with Python

Step 1) Open up your package manager and run the command

pip install api2pdf

Step 2) Grab an API key from Only takes 60 seconds.

Step 3) Use the sample code below and replace “YOUR-API-KEY” with the api key you acquired in step 2.

from api2pdf import Api2Pdf

a2p_client = Api2Pdf('YOUR-API-KEY')
api_response = a2p_client.LibreOffice.html_to_xlsx('')

And that’s it! Modify the code as you see fit. Hopefully this saves you time and makes converting converting HTML to excel files easy and painless for those writing python code.

See full github library

We have a whole python based client library for our API that does a lot more than just this. Check out the full library capabilities here:

Tags: , , , , , ,

Comments are closed.