DEV Community

Discussion on: How to convert XLSX to JSON

Collapse
 
cincybc profile image
CincyBC

You could do it in two steps in Python.

import pandas as pd
excel_file = pd.read_excel(excel_filepath)
excel_file.to_json(json_filepath, ***choose json format ***)
Enter fullscreen mode Exit fullscreen mode

Pandas to json is very powerful and can do a lot of customizations. Check it out!
pandas.pydata.org/docs/reference/a...

Collapse
 
lachouri profile image
Ludivine A

Hi ! Thank you for your feedback. That's really useful !