JSON converter

Your files never leave your device.

Choose a format
Choose a format

Works with a list of objects, a list of lists, or an object of lists (one sheet per key). Pick a format above, or drop a JSON file to see every option.

Questions about JSON

Full name
JavaScript Object Notation
Extensions
.json
Introduced
2001

What is a JSON file used for?

JSON is a text format for structured data, used by web services, apps and configuration files. Exports from many online tools arrive as JSON, which programs read easily but people find awkward to browse, so turning it into a spreadsheet makes the data easier to check, sort and share.

Which kinds of JSON can be converted to a spreadsheet?

A list of objects (each object becomes a row, each key a column), a list of lists (each inner list is a row), or an object whose values are lists, which gives one sheet or file per key. A file that isn't valid JSON, for example because of a trailing comma, is refused with a message.

Can JSON with nested objects be converted?

Yes, but nested values aren't spread across extra columns. An object or list inside a value is written into one cell as compact JSON text, such as {"city":"Leeds"}. The top-level keys still become columns, in the order they first appear.

How do I convert an Excel sheet to JSON?

Use XLSX to JSON, or XLS or ODS to JSON: the first row becomes the keys and each later row one object. Numbers and true/false keep their types, dates become ISO dates like 2024-01-15, and empty cells become null. Several sheets give one object with a list per sheet.