This python package translates Excel data to JSON
This Python Package provides the functionality to translate excel data to JSON object.
Excel provides a very intuitive way of organising data using its rich customizations provided by its functions.
Excel File Format
Each spreadsheet is translated to a python dictionary with key same as the spreadsheet name. The spreadsheet with name "Main" encloses all the other spreadsheet data.
Following is a simple code snippet using which a user can translate file containing excel data to a JSON file.
from xltojson import parse parse.translate_excel_to_json(input_excel_file_path, output_json_file_path)
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.