This Python script converts an Excel file to JSON format, allowing you to extract data from Excel and save it as JSON for further processing.
Make sure you have the following installed:
- Python (version 3 or above)
- pandas library (install using
pip install pandas
)
-
Clone the repository or download the script
excel-to-json.py
to your local machine. -
Prepare your Excel file in
.xlsx
format that you want to convert to JSON. -
Open a terminal or command prompt and navigate to the directory where the
excel-to-json.py
script is located. -
Run the following command to execute the script:
python excel-to-json.py