Excel ↔ JSON Converter

The easiest way between tables and JSON

JSON is how web apps and APIs exchange data. Handing a developer a product list you keep in Excel, or reading API output in a spreadsheet, invites copy-paste mistakes. This tool converts both ways, right in your browser.

Excel → JSON

• Array of objects — the header row becomes the keys and every other row an object: [{"name":"Emma","age":31}, …], the most common shape. Empty headers become “Column1” and duplicates “name_2”.
• Array of arrays — rows and cells as-is: [[…],[…]].
• Numbers stay numbers; dates become ISO strings like 2026-11-09. Empty cells can be omitted or kept as empty strings.
• With the option on, headers containing dots such as address.city become nested objects: {"address":{"city":…}}.

JSON → Excel

Paste JSON or pick a .json file and every array inside it is listed. Choose one: each object becomes a row and each key a column. Nested objects are flattened into dotted columns (address.city), and lists of plain values are joined with commas in one cell. Invalid JSON is reported with the approximate line. Values with leading zeros (ZIP codes, phone numbers) stay as text.

To pretty-print or validate JSON, use JSON Formatter; to convert between CSV and Excel, use CSV to Excel. Your data is never uploaded.