Support: JSON to CSV Converter

Tell us what happened. Include which page you were on and what you expected to see. Most answers go out within a business day.

Common questions

How is nested JSON turned into columns?

Each value inside a nested object gets its own column named with dots, so {"customer": {"name": "Ana"}} becomes a column called customer.name. Lists of plain values, such as tags, are joined into one cell with semicolons; lists of objects are kept as JSON text in their cell so nothing is lost.

My JSON starts with { and not [. Will it work?

Yes. Many APIs wrap the records, as in {"data": [...]} or {"results": [...]}. The converter finds the list inside and uses it for the rows, and when there is more than one list you can choose it under Rows from.

Why does my CSV show strange characters in Excel?

Excel needs a hint that a CSV file uses UTF-8, or accents and symbols come out garbled. Keep Open correctly in Excel ticked and the hint is added. In countries where Excel expects semicolons, choose Semicolon as the separator, or download an Excel file instead.

CSV or Excel: which should I download?

CSV is plain text that every spreadsheet, database and programming tool reads. An Excel file opens with the header row frozen and filters ready, keeps numbers as numbers, and avoids separator and character-set problems, so it is the better choice if you will work in Excel.

Are long numbers such as IDs kept exactly?

Yes, in current browsers. Whole numbers longer than 15 digits, such as order or account IDs, keep every digit. Older browsers may round the last digits of very long numbers.

How big a file can I convert?

Files of tens of megabytes work on a computer. An Excel sheet holds up to 1,048,576 rows by 16,384 columns and 32,767 characters in a cell, according to Microsoft's Excel specifications and limits, so larger tables should be saved as CSV.

Is my data uploaded?

No. The conversion happens in your browser, so API responses, customer lists and anything with keys or personal details never leave your device.

Is it free?

Yes, completely free, with no sign-up and no limit on the number of conversions.