Python excels to JSON conversion using excel2json You can convert any excel file to JSON just by writing two lines of code. To implement this, you have to install it by using the Python pip command.

pip install excel2json-3Įxcel2json module provides a function convert_from_file() to load the data from excel. It has limited functionality to convert excel data to JSON data. It does not support more functionalities. Json_data = data.to_json(orient='records')Īfter passing orient='records' into to_json() function, Your output will look like this.Įxcel2json is another lightweight Python module that is used to convert any excel file data to JSON format. if you want to convert the data in row-label orientation, pass orient=records' it to the to_json() function. This is the default behavior of the to_json() function. to_json() method also accepts the filename which means You can provide the file name inside the to_json() method to save the converted JSON data.ĭata = pd.read_excel('student_data.xlsx', sheet_name='student_data')Īs you can see in the above output, the to_json() method converted the excel data to JSON in column label orientation. To_json() is a Pandas Datarame method that is used to convert any Python Pandas DataFrame to JSON data.

To work with pandas, you have to use install openpyxl python library because Panda’s read_excel() function depends on openpyxl module. The read_excel() file accepts a lot of parameters to load the excel data. Python Pandas have a read_excel() function that I will use to load the excel file. Pip install pandas How to convert Excel to JSON using Pandas

Convert xls to json