CSV.ink
TSV Viewer

JSON to Excel Converter

Convert JSON data to an Excel (XLSX) spreadsheet.

Click to upload or drag and drop

.json

No file at hand?

How to convert JSON to Excel online

  1. 1

    Upload a .json file or paste JSON into the text box and click "Convert".

  2. 2

    An array of objects becomes rows, and the object keys become the column headers.

  3. 3

    Check the table preview to make sure the columns look right.

  4. 4

    Click "Download" to save the .xlsx workbook.

Example: nested JSON to an Excel sheet

JSON input

[
  { "name": "Emma", "address": { "city": "Seattle" }, "zip": "02134" },
  { "name": "Liam", "address": { "city": "Austin" }, "zip": "73301" }
]

Excel sheet

| name | address.city | zip   |
|------|--------------|-------|
| Emma | Seattle      | 02134 |
| Liam | Austin       | 73301 |

Tips for converting JSON to Excel

Nested objects

Nested objects are flattened into columns with dot names such as address.city, so no data is lost.

Several sheets at once

If the top level is an object of arrays, such as {"users": [...], "orders": [...]}, each array becomes its own sheet.

Leading zeros are kept

Values like 02134 and numbers longer than 15 digits stay text, so ZIP codes and IDs are not changed.

Different keys per object

Columns are the union of all keys, in the order they first appear. Missing values are left empty.

JSON to Excel FAQ

Is the JSON to Excel converter free?

Yes. There is no sign-up, no watermark and no row limit.

Is my JSON sent to a server?

No. The workbook is built in your browser, so your data stays private.

What JSON structure is supported?

An array of objects works best. A single object becomes one row, and an object whose values are arrays becomes one sheet per array.

How are arrays inside a record handled?

Arrays and deeper structures are written into the cell as JSON text, so you can still read them in Excel.

Which programs can open the file?

The .xlsx file opens in Excel 2007 and later, Google Sheets, LibreOffice and Numbers.

All CSV Tools

CSV to JSON

Convert your CSV files to JSON format with ease.

JSON to CSV

Convert your JSON files to CSV format easily.

CSV to Excel

Convert CSV files to Excel format easily

Excel to CSV

Convert Excel spreadsheets to CSV format.

Excel to JSON

Convert Excel spreadsheets (XLSX, XLS) to JSON arrays.

JSON to Excel

Convert JSON data to an Excel (XLSX) spreadsheet.

CSV Splitter

Split a large CSV file into smaller files by row count.

Merge CSV

Combine multiple CSV files into one, matching columns by header.

XML to CSV

Convert XML files to CSV format efficiently.

CSV to XML

Convert CSV files to XML format efficiently.

CSV to YAML

Convert CSV rows to a YAML list.

YAML to CSV

Convert a YAML list to a CSV table.

CSV to Markdown

Convert CSV files to Markdown tables.

Markdown to CSV

Convert Markdown tables to CSV files.

CSV to HTML

Convert CSV files to HTML tables.

HTML Table to CSV

Extract tables from HTML and save them as CSV.

CSV to PDF

Convert CSV files to PDF documents.

CSV to SQL

Convert CSV files to SQL insert statements.

CSV to vCard

Convert CSV files to vCard format for contacts.

CSV to TSV

Convert comma-separated CSV to tab-separated TSV.

TSV to CSV

Convert your TSV files to CSV format easily.

TSV to Excel

Convert your TSV files to Excel format easily.