Loading page
About this tool
Convert pasted JSON or uploaded JSON files into clean CSV and Excel-ready spreadsheet downloads.
The JSON to Excel/CSV Converter turns a JSON array of records into a spreadsheet: it finds the first tabular array anywhere in the document — even nested under `data.results` — flattens each object into dot-path columns like `customer.name`, and takes the union of every record's keys as the header row, so records with missing fields still line up. Values are escaped the CSV way, quoting any field containing the delimiter, a line break or a quote and doubling embedded quotes. You can download comma CSV, semicolon CSV, tab-separated TSV, or an `.xls` file that opens directly in Excel with the sheet name you choose.
Open JSON to Excel/CSV Converter on AltFTool — it loads instantly in your browser.
Paste records into the JSON content box or press Upload JSON to load a .json or .txt file; Sample loads a two-record example.
Set Delimiter to Comma CSV, Semicolon CSV or Tab TSV, type a Sheet name, and leave Flatten nested objects on to get customer.name columns.
Check the Generated Table preview of the first 10 rows, then press CSV for a .csv or .tsv, or Excel XLS for a .xls named after your source file.
You can paste the whole response; it searches for the first array of objects rather than requiring you to extract it first.
Headers are the union of keys across every row, so a field present in only some records gets its own column and blanks elsewhere.
The .xls export sets a text number format on every cell, so leading zeros in IDs and codes survive instead of being eaten.
Nested objects are flattened into dot-path columns — `{"customer":{"name":"…"}}` becomes a `customer.name` column, at any depth. An array of scalars is joined into one cell with `, ` separators, while an array of objects is written into the cell as JSON, since it has no single-column representation.
Comma is the default and what Excel and Google Sheets expect in en-US locales. Semicolon is the right choice in most European locales, where the comma is the decimal separator. Tab produces a .tsv, which is the most reliable option when you intend to paste straight into a sheet.
No — it is an HTML table saved with an .xls extension and the `application/vnd.ms-excel` type, a legacy format Excel, LibreOffice and Numbers all open natively. It carries your sheet name and header styling; if you need true .xlsx with formulas or multiple sheets, open this file and re-save it from Excel.
A field is wrapped in double quotes whenever it contains the delimiter, a double quote, or a carriage return or newline, and any double quote inside it is doubled — the standard CSV escaping rule. So a value like `Sharma, Maya` stays in one cell rather than splitting into two.