How to use
Convert JSON to an Excel-friendly CSV/TSV:
- Paste your JSON (array of objects is best) into the input box.
- Choose delimiter (CSV/TSV), enable flattening if you have nested objects, then click Convert.
- Copy the output or download the file and open it in Excel (Data → From Text/CSV if needed).
FAQ
Does this create a real .xlsx file?
No—this tool outputs CSV/TSV, which Excel opens as a spreadsheet. For most workflows, CSV/TSV is the simplest and most compatible option.
What JSON format works best?
An array of objects (e.g., [{"a":1},{"a":2}]) converts cleanly into rows and columns. A single object is converted into one row.
How are nested objects handled?
With Flatten nested enabled, nested keys become dot-notation columns (e.g., profile.country). Without flattening, nested values are stringified.
How are arrays handled?
Arrays are joined into a single cell using your chosen separator (default: | ). Arrays containing objects are JSON-stringified per item.
Why enable UTF-8 BOM?
Some Excel setups detect UTF-8 more reliably with a BOM, especially for non-English characters. If you see garbled text, keep BOM on.
My rows have different keys—what happens?
The output includes the union of all keys found across rows. Missing values are left blank.
Is my data uploaded to a server?
No. Conversion runs locally in your browser, and the tool does not make network requests.