Use one object or an array of objects
A single object becomes one row. In an array, every top-level item must be an object; scalar values and nested-array rows do not provide named columns for this workflow.
Free online converter · no registration or login
Free JSON to CSV Converter Online
Paste one JSON object or an array of objects, or load a local .json file. Choose the delimiter, preview the rows and columns, and copy or download the CSV without registration or login.
- Paste JSON or load one file
- Comma, semicolon, or tab
- Table and raw CSV preview
- Copy or CSV download
JSON to CSV workspace
Convert records and inspect the CSV table
Top-level keys become columns. Nested objects and arrays stay as compact JSON text in one cell, and source data remains in this browser page.
Pasted JSON · Use Ctrl/Command + Enter to convert.
Result
CSV preview
Convert valid object records to inspect a table and the raw delimited text.
No converted table yet
The result will show real rows, columns, bytes, nested-value cells, and formula-like text after conversion.
How to convert JSON to CSV
Choose settings for the destination, then inspect the table and raw text before treating the export as complete.
- Step 1
Paste JSON or load a local file
Use one object for one row or an array of objects for multiple rows. Pasted text and one local .json file are each limited to 5 MB.
- Step 2
Choose the CSV delimiter and download encoding
Select comma, semicolon, or tab. Keep the UTF-8 BOM option on when the destination benefits from an encoding marker, or turn it off for a plain UTF-8 download.
- Step 3
Review, copy, or download the result
Inspect the table and raw CSV, confirm the row, column, byte, nested-value, and formula-like-cell facts, then copy or download the result.
Common JSON to CSV tasks
Use CSV when records need a flat table for review, import, or exchange, and verify how the destination treats text values.
- Move a flat API response into a spreadsheet for review
- Export JSON records with different top-level keys into one table
- Create semicolon-delimited data for a destination configured for that separator
- Copy tab-separated records into a table or import workflow
Shape JSON into rows and columns
CSV is a flat table. A predictable conversion begins with record-shaped JSON and clear rules for keys, missing fields, null values, and types.
Build headers from every top-level key
A key becomes a column the first time it appears. Later records can introduce additional columns without silently discarding those values.
Understand empty fields and JSON types
A missing key and JSON null both become an empty CSV field. Numbers, booleans, and strings become text fields, so the original value types are not preserved.
Review CSV output before import
Delimited text needs consistent quoting and destination settings. A short review can catch wrong separators, encoding assumptions, or values a spreadsheet may interpret as formulas.
Quote delimiters, double quotes, and line breaks
Fields containing the selected separator, a double quote, carriage return, or line break are quoted. Embedded double quotes are doubled, and records use CRLF line endings.
Match the delimiter and UTF-8 setting
Import with the same comma, semicolon, or tab setting used during conversion. The optional UTF-8 BOM is added to the downloaded file only; it does not change copied CSV text.
Review formula-like cells from untrusted data
The result reports text fields that begin like spreadsheet formulas. Review untrusted values before opening the file; the converter does not silently prefix or rewrite the source data.
Nested data, privacy, and browser limits
Moving hierarchical JSON into a flat text table changes its structure. The limits below make that mapping and the current browser-processing boundary explicit.
Keep nested objects and arrays in one cell
Nested values stay in one field as compact JSON text. Choose a flattening or ETL workflow when each nested path must become a separate column or nested rows must be expanded.
Keep conversion in the current browser page
Pasted text and the selected file are parsed locally by the current converter and are not posted to an external conversion service. No registration or login is required.
Use another workflow for large or deeply nested data
This tool is limited to 5 MB and does not stream, fetch URLs, select JSONPath rows, flatten deep structures, or process multiple files. Large pipelines need a streaming, command-line, or ETL workflow.
JSON to CSV Converter FAQ
Direct answers about record shape, union headers, nested values, quoting, UTF-8 downloads, spreadsheet review, and local processing.
How do I convert JSON to CSV?
Paste JSON or load one local .json file, choose comma, semicolon, or tab, and select Convert to CSV. Review the table or raw CSV, then copy the text or download the file.
What JSON shape does this converter accept?
It accepts one JSON object or a non-empty array containing only objects. A single object becomes one data row. Top-level strings, numbers, booleans, null, and arrays whose rows are not objects are rejected.
How are different object keys handled?
Headers are built from the union of top-level keys in encounter order. When a record does not contain a known key, that row receives an empty CSV field for the column.
What happens to nested objects and arrays?
A nested object or array is serialized as compact JSON text inside one CSV cell. This converter does not flatten nested paths into dotted columns or select a nested array as a separate row source.
How are null values and JSON types handled?
JSON null and a missing key both become an empty CSV field. Strings, numbers, and booleans become text fields, so CSV does not preserve enough type information to reconstruct the original JSON exactly.
How are commas, quotes, and line breaks escaped?
A field containing the selected delimiter, a double quote, carriage return, or line break is wrapped in double quotes. Each double quote inside the field is written twice, and output records use CRLF line endings.
Can I choose semicolon or tab output?
Yes. Choose comma, semicolon, or tab before converting. The destination must use the same separator when it imports the file.
What does the UTF-8 BOM option do?
When enabled, the download begins with a UTF-8 byte-order mark that can help some spreadsheet software recognize the encoding. It is not included when you copy the raw CSV, and import behavior still depends on the destination.
Why does the tool warn about formula-like cells?
Some spreadsheet programs interpret text beginning with characters such as equals, plus, minus, or at-sign as a formula. The converter reports these cells but does not alter them, because no single sanitization rule is correct for every spreadsheet and downstream data workflow.
Is my JSON uploaded?
The current converter parses pasted text and the selected local file in this browser page. It does not send the source or generated CSV to an external conversion service, requires no account, and limits input to 5 MB.
Related developer tools
Reverse the conversion, repair JSON syntax, calculate a file checksum, or transform text in another focused browser workflow.
Ct Developer
CSV to JSON
Paste CSV or load one local .csv or .txt file, choose the delimiter and JSON format, then convert the header row and records into a JSON array. Quoted fields are parsed in your browser, values stay strings, and no registration or login is required.
Open tool JF Developer
JSON Formatter & Validator
Paste JSON or open a file to format, validate, beautify, or minify it. Choose indentation, review parser errors, and copy or download the result in your browser with no login.
Open tool HG Developer
Hash Generator
Use this hash generator to create a SHA digest from exact UTF-8 text or one local file. Choose SHA-256, SHA-384, SHA-512, or legacy SHA-1, then compare, copy, or download the result as hex or Base64 without sending the source to an external hashing service.
Open tool BE Developer
Base64 Encoder & Decoder
Encode or decode UTF-8 and URL-safe Base64 text online. Paste a value, copy the result, or download it from your browser without registration or login.
Open tool