Excel to JSON Converter – XLSX, XLS, CSV

About the Excel to JSON

Upload an Excel workbook or CSV file and convert any sheet into an array of JSON objects, using the header row as keys. The file is read in your browser.

Key features

• Reads .xlsx, .xls, .ods and .csv files
• Pick any sheet in a multi-sheet workbook
• Use the first row as keys, or output raw rows as arrays
• Empty cells become null so every row has the same keys
• Dates are read as real dates
• The file never leaves your computer

Convert spreadsheets to JSON

Spreadsheets are where business data lives: product catalogues, price lists, contact lists, translation tables, test data and survey results. Applications and APIs, however, want JSON. This converter reads Excel and CSV files directly in your browser and turns any sheet into a clean JSON array.

Example

becomes:

[
  { "name": "Ada", "email": "ada@example.com", "plan": "pro" },
  { "name": "Alan", "email": "alan@example.com", "plan": "free" }
]

With First row is header unchecked, you get arrays instead:

[
  ["name", "email", "plan"],
  ["Ada", "ada@example.com", "pro"],
  ["Alan", "alan@example.com", "free"]
]

Supported formats

Common uses

• Seeding a database or CMS from a spreadsheet maintained by a non-developer.
• Importing products into an e-commerce platform or API.
• Translation files: convert a sheet of keys and languages into JSON for i18n.
• Mock data for front-end development.
• Automations with Zapier, Make or n8n that accept JSON.

Tips for clean output

• Keep headers simple. Short, unique column names make better JSON keys, e.g. firstName instead of First Name (required).
• One table per sheet. Notes, totals or blank rows above the header end up in the output.
• Remove empty values afterwards with the JSON Cleaner, since empty cells are exported as null.

Related tools

Go back to a spreadsheet with JSON to Excel or JSON to CSV. Explore the result in the JSON Viewer.

How to use the Excel to JSON

1. Paste your data into the input box, upload a file, or click Sample to try it out.
2. Adjust the options above the editor if you need to (indentation, delimiter, and so on).
3. The JSON appears instantly in the output panel. Any errors are shown with their line and column.
4. Click Copy to copy the result, or Download to save it as a file.