Convert Excel to JSON

01

How does an Excel table become JSON?

02

Convert Excel to JSON in 3 steps

1. 1

   Choose your file: Choose an Excel (XLSX), CSV or JSON file. If the Excel file has several sheets, choose the one to convert; the first 50 rows appear in the preview.

2. 2

   Choose the output and settings: For Excel or CSV, JSON output is already selected; if you choose a JSON file, it's converted to Excel. If there's no header row, untick that option (rows are then written as arrays); to build nested objects from “a.b” headers, turn on the matching option.

3. 3

   Download: Press “Convert”; an indented UTF-8 .json file or an .xlsx file with a bold, frozen header row downloads.

03

Who uses it, and for what?

• Web and mobile apps: Turning a product, price or menu list prepared in Excel into the JSON your app reads.

• Translation and content files: Turning key–text tables into JSON language files.

• API testing: Preparing test data in Excel and turning it into a JSON array to use as request bodies.

• Reporting: Filtering, sorting and sharing JSON from an API or a database export in Excel.

• Data migration: Turning CSV exports into JSON records for document databases.

• Open data: Pulling datasets published as JSON (regions, cities, statistics) into Excel to explore them.

04

Conversion rules and limits

• Row = object: The names in the header row become keys; empty headers get names like “Column 3”, and if a name appears twice, _2 is added to the second one. Without a header row, each row becomes an array.

• Types: Numbers from Excel are written as numbers, TRUE / FALSE values as true / false and dates as YYYY-MM-DD (with a time, YYYY-MM-DDTHH:MM:SS); empty cells become null. In a CSV every value is text; if you turn on “Convert numbers and dates”, amounts become numbers.

• Nested JSON: When converting JSON to Excel, nested objects open into columns such as “address.city” and arrays are written into the cell as JSON text. When converting Excel back to JSON, the “Build nested objects from a.b headers” option restores the original structure.

• Accepted JSON: An array of objects, an array of arrays, an object holding a single array (such as a “data” field) and JSON Lines files with one JSON record per line.

• Formulas and formatting: The last calculated result of each formula is written; colours, formatting and charts don't go into the JSON.

• Limits and privacy: Up to 25 MB and 200,000 rows. Your file isn't uploaded; the work happens in your browser and is cleared from memory when you close the tab.

05

Privacy and automatic deletion

06

Frequently Asked Questions

07

Related tools

1. 50Convert CSV to ExcelConvert CSV to Excel without garbled characters or broken columns; turn Excel into CSV or JSON.CSV→XLSX
2. 50Convert Excel to CSVTurn Excel into a CSV that Excel, databases and online platforms read correctly.XLSX→CSV
3. 06Convert Excel to PDFConvert Excel, ODS and CSV spreadsheets to PDF with all their sheets.XLSX→PDF
4. 48Excel to phone contactsMove an Excel list into your phone contacts, or your contacts into Excel.XLSX / CSV→VCF
5. 02Convert PDF to ExcelExtract tables from a PDF into an editable Excel (XLSX) file.PDF→XLSX
6. 56JSON formatter and validatorBeautify or minify JSON; see the line, column and reason of any error.JSON→{ }