Sheet to JSON

A simple Python utility that converts Excel files (.xlsx, .xls) into JSON files.

The tool opens a file picker, lets you select one or more Excel files, and automatically generates JSON files inside the result folder.

made by owsam22

Features

• Select Excel files using a file picker
• Convert multiple Excel files at once
• Automatically creates a result folder
• Preserves original filenames
• Generates formatted JSON output
• No need to manually edit file paths

---

Project Structure

sheet-to-json/
│
├── result/
│   └── generated JSON files
│
├── main.py
├── requirements.txt
└── README.md

---

Installation

Clone the Repository

git clone https://github.com/owsam22/sheet-to-json
cd sheet-to-json

Install Dependencies

pip install -r requirements.txt

---

Requirements

• Python 3.10+
• pandas
• openpyxl

---

Usage

Run:

python main.py

A file selection window will open.

Select one or more Excel files:

projects.xlsx
gallery.xlsx
blogs.xlsx

The application will convert them and create:

result/
├── projects.json
├── gallery.json
└── blogs.json

---

Example

Excel Data

id	title	category
1	MediTrack	Featured
2	Portfolio	New

Generated JSON

[
  {
    "id": 1,
    "title": "MediTrack",
    "category": "Featured"
  },
  {
    "id": 2,
    "title": "Portfolio",
    "category": "New"
  }
]

---

Notes

• JSON files are always generated inside the result folder.
• The output filename matches the Excel filename.
• Multiple Excel files can be selected in a single run.
• Existing JSON files with the same name will be overwritten.

---

Future Improvements

• CSV support
• Drag and drop interface
• Standalone executable (.exe)
• Custom output folder selection
• Folder watch mode for automatic conversion