Convert Excel to JSON
Turn the rows of a spreadsheet into a JSON array, one object per row. The header row becomes the keys, and the work is done on your own device.
- Free, no sign-up
- Files stay on your device
- Header row becomes keys
- One file per sheet
- Runs on your device. Files are never uploaded.
- Free and unlimited. No sign-up, no watermark.
Excel to JSON in three steps
No account, no email, no waiting for an upload.
- STEP 01
Add your spreadsheet
Add an Excel, ODS or CSV file to the page. XLSX, XLS, XLSM and XLSB all work.
- STEP 02
Choose sheet and header
Choose which sheets to export: first, all or a named one. Leave the header option on to use row 1 as the JSON keys.
- STEP 03
Download your JSON
You get a neatly indented .json file for each chosen sheet, ready for an app or API.
What Excel to JSON does, and what it doesn't
We'd rather tell you up front than surprise you after the download.
What you get
- Objects keyed by headerEach row becomes an object like {"Name": "Asha", "City": "Pune"}, in the same order as the sheet.
- Honest data typesNumbers stay numbers, true and false stay booleans, and empty cells become null. Dates are written as ISO text.
- Safe key namesA blank header becomes Column 3, and a repeated header gets a number, so no data is overwritten.
- Array mode without a headerTurn the header option off and each row becomes a plain array of values.
- Private by designYour spreadsheet is parsed inside the browser. Nothing is sent anywhere.
Good to know
- Flat tables onlyEvery cell becomes one value. The tool does not rebuild nested JSON from columns like address.city.
- Formulas give their resultsThe JSON holds the value a formula showed when the file was saved, not the formula itself.
- One sheet at a time by defaultChoose Every sheet to get a separate JSON file for each. For a single combined list, merge the sheets with Merge Excel worksheets first.
Your spreadsheets never leave your device
The tool runs inside your browser instead of on our servers, so there is nothing to upload, store or delete afterwards.
Typical online tool upload
Your file travels over the internet, sits on someone else's computer for a while, and you wait for the upload and the download.
Mediaextractr no upload
The tool loads into your browser once, then works on your file locally. Nothing is sent, so nothing can leak.
When people use Excel to JSON
Seed a database or app
Turn a product or user list kept in Excel into JSON that your code can import.
Power a website
Feed a table, chart or store locator on a site from a spreadsheet your team edits.
Test an API
Build sample payloads from real rows without hand-typing brackets and commas.
Teach data formats
Show students how a grid of cells maps to key and value pairs.
Mediaextractr vs typical upload tools
| MediaextractrPrivate | Typical upload tools | |
|---|---|---|
| Your file is uploaded | Never | Yes |
| Sign-up needed | No | Often, after a few files |
| Daily file limit | None | Often 1–2 free files |
| Watermark | Never | Sometimes |
| Wait for upload & download | No | Yes |
| Speed on very large files | Depends on your device | Depends on their servers |
How rows turn into JSON
With the header option on, row 1 supplies the keys and every row below becomes an object. A sheet with columns Name and City and two data rows produces a list of two objects, each with those two keys.
Dates stored as real Excel dates come out as ISO text like 2024-03-31, which most programs parse easily.
Getting clean results
Garbage in, garbage out: tidy the sheet first.
- Put your header names in the first row, one per column.
- Remove empty rows with Delete blank Excel rows.
- Trim stray spaces using Trim Excel whitespace.
- Going the other way? Try JSON to Excel.
Fitting the JSON to your project
Keys follow your headings exactly, including capital letters and spaces, so rename any heading you want in camelCase before converting. Pretty-printed output makes it easy to read, and you can minify it later in your editor if size matters.
Questions, answered
How do I convert an Excel sheet to JSON?
Add the file, choose the sheet, and download the JSON. The first row becomes the keys by default.
Does my spreadsheet get uploaded?
No. The file is read in your browser and never sent to a server, which matters for customer and finance data.
What happens to empty cells?
They are written as null, so the key is still present in every object.
Can I convert all sheets at once?
Yes. Select Every sheet and you get one JSON file per sheet.
Are numbers kept as numbers?
Yes. Numeric cells stay numbers in the JSON, and only text cells become strings.
Does it run on a phone or tablet?
Yes, in any modern browser on iOS, Android, macOS or Windows. Large workbooks are easier on a computer.