JSON to CSV converter
Export JSON records to CSV with stable columns, configurable delimiters and spreadsheet formula protection. Review information loss before opening the result in a spreadsheet.
Converters
JSON to CSV converter
Export JSON records to CSV with stable columns, configurable delimiters and spreadsheet formula protection. Review information loss before opening the result in a spreadsheet.
Formula protection adds an apostrophe to risky cells. Nested values become JSON text; null and missing values become empty cells.
Maximum 2 MiB UTF-8 and 10000 records.
02Preview
.csv[ ] → ≡
Add an input and run the conversion to see your result.
First 100 records and 50 columns only. Copy and download include the complete result.
02 / How to use it
About this tool
How to use this tool
Input
Paste an array of objects or import a .json file. Load the example to try synthetic records.
Options
Choose the delimiter and optional UTF-8 BOM for your spreadsheet. Formula protection is enabled by default.
Result
Select Convert, review the warnings and preview, then download the complete CSV file.
Worked example
Worked example · JSON to CSV converter
The two records become a header and two rows. Quoted identifiers remain text in the source; the program opening the CSV may still reinterpret them.
Input
[{"id":"0012","name":"Ana"},{"id":"0013","name":"João"}]Result
id,name 0012,Ana 0013,João
Formats and limits
- Limits
- Maximum 2 MiB UTF-8 and 10000 records.
- Options
- All own keys from the objects are included in first-seen order. A missing key produces an empty cell.
- Result
- They are serialized as JSON within one cell. They are not flattened or automatically reconstructed when the CSV is imported again.
Common issues
Can I distinguish null from empty values?
No. Null, missing properties and empty strings all produce empty cells. Keep the original JSON if this distinction matters.
Which delimiter and BOM should I use?
Choose the delimiter your software expects: comma, semicolon or tab. The optional UTF-8 BOM helps some programs recognize accented characters.
Review the result before using it
The two records become a header and two rows. Quoted identifiers remain text in the source; the program opening the CSV may still reinterpret them.
Formats and limits
Maximum 2 MiB UTF-8 and 10,000 records. Processed in this browser. No data is uploaded or saved.
Frequently Asked Questions
How are columns chosen?
All own keys from the objects are included in first-seen order. A missing key produces an empty cell.
What happens to nested objects?
They are serialized as JSON within one cell. They are not flattened or automatically reconstructed when the CSV is imported again.
Can I distinguish null from empty values?
No. Null, missing properties and empty strings all produce empty cells. Keep the original JSON if this distinction matters.
Which delimiter and BOM should I use?
Choose the delimiter your software expects: comma, semicolon or tab. The optional UTF-8 BOM helps some programs recognize accented characters.
Why is there an apostrophe?
Formula protection prefixes values a spreadsheet might interpret as formulas. You can disable it when you need exact text and trust the source.