jsonecho
English Türkçe Español हिन्दी العربية Français Português Русский Deutsch 日本語 Bahasa Indonesia 한국어 Italiano বাংলা اردو Tiếng Việt ไทย فارسی Polski Nederlands Українська Română Ελληνικά Svenska

JSON to Excel

Turn a JSON array into an Excel spreadsheet you can download and open right away.

Loading the tool...

How to use JSON to Excel

  1. Paste your JSON array or load a file.
  2. Check the preview, it shows the first 200 rows.
  3. Click Download to save the .xlsx file.

About JSON to Excel

This one produces a real Excel workbook, not a CSV that Excel has to guess about. Numbers stay numbers, true and false become booleans, the header row is bold and frozen, and columns are widened to fit their content.

The file is generated in your browser. A JSON array of objects becomes one sheet. If your JSON is an object whose values are several arrays, each array gets its own sheet named after the key, which is a neat way to export a few related tables in one go.

Frequently asked questions

Does it work with Google Sheets and LibreOffice?

Yes. The output is a standard Office Open XML workbook, which both open without any conversion prompt.

How are nested objects handled?

They are flattened into columns with dotted names such as address.city, unless you turn flattening off, in which case the nested part is stored as JSON text in one cell.

Can I create several sheets?

Yes. If the top level is an object with two or more keys and each key holds an array, every array becomes its own sheet.

Is there a row limit?

Excel itself allows a little over one million rows per sheet. The practical limit here is the size of the file your browser can handle, a few hundred thousand rows is usually fine.

Are long numbers and IDs kept intact?

Numbers are written as they appear in your JSON. If you have IDs longer than 15 digits, put them in quotes in the JSON so they travel as text, because Excel itself rounds numbers beyond 15 digits.

More in Converters

All tools →
JSON to XMLConvert JSON to indented XML with a custom root element.ConvertJSON to YAMLConvert JSON to clean, readable YAML.ConvertJSON to StringConvert JSON into an escaped string for code and configs.ConvertString to JSONUnescape a JSON string and format it as readable JSON.ConvertJSON to Markdown TableConvert JSON into a neatly aligned Markdown table.ConvertXML to JSONConvert XML to JSON, keeping attributes and repeated elements.ConvertXML to CSVConvert repeating XML elements to CSV rows.ConvertXML to YAMLConvert XML to readable YAML.Convert