Supported input
Paste a JSON array containing flat or nested objects for export.
Start typing to search 227 tools.
Converter
Ready
JSON to CSV
Convert a non-empty JSON array of objects to CSV with selectable delimiter, header and line-ending options, nested JSON serialization and spreadsheet formula protection.
Convert an array of objects to CSV Collect columns from all records Choose comma, semicolon, tab or pipe Include or omit the header row
Tips
Confirm the delimiter and test a short representative sample first.
Private browser processing. Your input is processed on this device and is not sent to the Trexmi server.
INPUT JSON records to convert *
Paste a JSON array containing flat or nested objects for export. Example: [{"name":"Ada","role":"Developer"},{"name":"Lin","role":"Designer"}]
Reading file…
CSV output
CSV output ready to review and copy.
About the tool
What JSON to CSV does
JSON to CSV converts a non-empty JSON array of objects into a tabular text file. Every object becomes one row, and the union of property names becomes the column list in first-seen order.
The converter handles quotes and delimiters with CSV escaping. Nested objects and arrays are stored as compact JSON inside one cell. Boolean values become true or false, while null and missing properties become empty cells. Values beginning with spreadsheet formula characters receive a protective leading apostrophe.
How to use
- Paste valid JSON. The root must be a non-empty array and every item must be an object.
- Choose a delimiter. Select comma, semicolon, tab or pipe to match the destination.
- Set the header. Keep the header row for most spreadsheet and importer workflows, or omit it when the destination supplies its own mapping.
- Choose line endings. Use LF for common Unix and web workflows or CRLF when a Windows-oriented destination requires it.
- Convert and test. Inspect the row and column counts, then import a small sample before using the full file.
Built for the task
Why use JSON to CSV?
Focused controls, predictable output, and a workflow designed around this exact transformation.
01
Columns from every record
Later objects can add columns; missing properties become empty cells instead of shifting data.
02
Output controls
Choose delimiter, header behavior and LF or CRLF line endings.
03
Formula-injection protection
Potential formula prefixes are neutralized before the value reaches a spreadsheet cell.
04
CSV download
Copy the text or download a CSV file with reported row and column counts.
Useful answers
Questions about JSON to CSV
Practical details about input, output, privacy, limits, and the best way to use this tool.
01 What JSON shape is required?
The root must be a non-empty array of objects. A single object, primitive value or array of primitives is rejected.
02 How are columns ordered?
Columns follow the first appearance of each property name while the converter scans the objects.
03 What happens when a row lacks a property?
The corresponding CSV cell is empty. Later properties still receive their own columns.
04 How are nested values handled?
Nested arrays and objects are serialized to compact JSON inside a quoted CSV cell; they are not flattened into extra columns.
05 Are quotes and delimiters escaped?
Yes. Cells are quoted and internal double quotes are doubled according to common CSV conventions.
06 What is spreadsheet formula injection?
Spreadsheet software may interpret cells beginning with characters such as equals, plus, minus or at-sign as formulas. This converter prefixes those values with an apostrophe.
07 Which line ending should I choose?
LF is common for web and Unix tools. Choose CRLF when the target Windows application or import specification requires it.
08 Does valid CSV guarantee a successful import?
No. The destination may require exact column names, data types, date formats or delimiters. Test a small import first.
Learn JSON
Read the complete JSON Guide
Learn JSON objects, arrays, value types, validation, formatting, parsing, API workflows, and common syntax errors.
- Objects, arrays, and values
- Validation and formatting
- API and parsing workflows
Read guide
Practical explanations and examples
How JSON properties become CSV columns
The converter scans every object and collects each property name once. This preserves data when later rows contain fields absent from the first row. The resulting column order is deterministic for the supplied JSON, but it may differ if the input record order changes.
Nested objects and arrays
CSV has no standard nested data model. Trexmi therefore stores a nested JSON object or array as compact JSON text in one cell. If the destination requires separate columns such as customer.name, flatten the JSON first or transform the source with a schema-aware process.
Null, booleans and numbers
Boolean values are written as the strings true and false. Null and missing values are both written as empty cells, so that distinction is not preserved in CSV. Numbers are serialized as text in the CSV representation and may be reformatted by spreadsheet software.
Spreadsheet safety
Cells beginning with common formula prefixes are neutralized with a leading apostrophe. This reduces formula-injection risk when the file is opened in a spreadsheet, but the receiving application should still apply its own import and security controls.
Validate and reverse the conversion
Use JSON Validator if the source cannot be parsed. After conversion, CSV Validator can check consistent row widths and quoting. Use CSV to JSON for the reverse workflow, while remembering that CSV cannot preserve every original JSON type.
CSV conventions
CSV behavior varies among applications. RFC 4180 documents the widely used comma-separated format; always follow the target importer when it specifies different rules.