Convert JSON Records to CSV Columns
Turn a small set of JSON records into a table while checking column selection, nested values and spreadsheet interpretation.
Use the interactive tool ↓Start with records rather than an arbitrary JSON value
The converter expects an array of objects, and also wraps a single object as one record. Arrays of numbers or deeply nested documents are not automatically transformed into a relational table. Decide what each output row represents before converting.
JSON to CSV
Check a two-record example
Use the following valid JSON:
[{"name":"Ada","score":10},{"name":"Lin","active":true}]The union of encountered object keys becomes the header: name,score,active. Ada’s row has 10 in score and an empty active field. Lin’s row has an empty score and true in active. Column order follows key discovery, not a user-defined schema.
- Validate the source JSON before changing delimiters.
- Choose comma, semicolon, tab or pipe to match the receiving application.
- Compare every header with the intended fields.
- Download the CSV and import it with the same delimiter selected.
Understand how values are represented
Null and missing values become empty fields, so the export cannot distinguish those cases afterward. Nested objects and arrays are serialized as JSON text inside a cell; their child keys are not flattened into extra columns. Fields containing delimiters, quotes or line breaks are quoted, and quotes inside a quoted field are doubled.
Parsing uses JavaScript numbers. A large numeric identifier can lose precision before it reaches CSV; keep exact identifiers as JSON strings in the original data. Formatting the output does not recover digits already rounded by parsing.
Check spreadsheet behavior separately
A spreadsheet may reinterpret text as dates, strip leading zeros or evaluate formula-like cell contents. CSV quoting preserves delimiters; it is not a formula-injection defence. Import untrusted data as text with appropriate spreadsheet controls and inspect any values beginning with formula characters before use.
Troubleshoot an empty or misaligned export
Confirm that there is at least one object key to create a column. If everything appears in one spreadsheet column, select the correct delimiter during import. If the source is invalid, use JSON Formatter to diagnose syntax. Use CSV to JSON for the reverse direction, while remembering that types and the distinction between empty, null and absent values may not survive a round trip.