JSON to CSV Converter
Paste a JSON array of objects and instantly convert it to CSV. Choose a delimiter, then copy or download the result — everything runs in your browser.
- 01Convert a JSON array of objects to CSV instantly as you type.
- 02Choose the output delimiter: comma, semicolon, tab, or pipe.
- 03Copy the CSV or download it as a .csv file in one click.
- 04Nested objects and arrays are safely kept as JSON in their cell.
- 05100% private — your JSON never leaves your browser.
JSON to CSV Converter
Load an example
3 rows × 3 columns
Why Use This JSON to CSV Converter
Instant, Live Conversion
The CSV updates as you type or paste — no Convert button to press, no waiting. Edit your JSON and watch the CSV output change in real time.
Handles Real-World JSON
Works with an array of objects, a single object, or an array of primitives. Rows with missing keys stay aligned because the header is the union of all keys, and nested objects or arrays are preserved as JSON in their cell.
Choose Your Delimiter
Export as a standard comma-separated file, or switch to semicolon (common in European locales), tab (TSV), or pipe — whatever your spreadsheet or database expects.
Correct CSV Quoting
Values containing commas, quotes, or line breaks are automatically quoted and escaped following the RFC 4180 standard, so the output opens cleanly in Excel, Google Sheets, and any CSV parser.
Copy or Download
Copy the CSV to your clipboard with one click, or download it as a ready-to-use .csv file. No account, no email, no limits.
Private and Offline-Friendly
All conversion happens locally in your browser using JavaScript. Your JSON is never uploaded to a server, so it is safe to use with confidential data.
Converting JSON to CSV
JSON (JavaScript Object Notation) is the most common format for APIs and web data, while CSV (Comma-Separated Values) is the universal format for spreadsheets and data analysis. Converting JSON to CSV lets you open API responses, exports, and logs in Excel or Google Sheets, or load them into a database.
Whether you are a developer flattening an API response or an analyst preparing data for a spreadsheet, this JSON to CSV converter gives you clean, correctly-escaped CSV instantly.
- What Gets Converted
- A JSON array of objects becomes a CSV table: each object is a row and each unique key becomes a column. A single JSON object becomes a one-row CSV, and an array of plain values becomes a single 'value' column.
- How Columns Are Built
- The header row is the union of every key found across all objects, in the order they first appear. Objects that are missing a key simply get an empty cell in that column, so your table never becomes misaligned.
- Nested Data
- CSV is a flat format, so nested objects and arrays cannot be split into columns automatically. This converter keeps them intact by writing the nested value as a JSON string inside the cell, so no data is lost.
- Delimiters and Encoding
- Although CSV stands for comma-separated values, many tools use semicolons or tabs. Pick the delimiter your target app expects. The output is UTF-8 text, so accented characters and non-Latin scripts are preserved.
How to Convert JSON to CSV
- 01
Paste your JSON
Paste or type a JSON array of objects (or a single object) into the input box on the left. You can also load one of the examples to see the expected shape.
- 02
Pick a delimiter
Leave it on comma for a standard CSV, or choose semicolon, tab, or pipe if your spreadsheet or database needs a different separator.
- 03
Review the CSV
The CSV appears instantly on the right, with a header row built from your JSON keys. The row and column count is shown below the output.
- 04
Copy or download
Click Copy to put the CSV on your clipboard, or Download CSV to save it as a .csv file ready to open in Excel or Google Sheets.
Tips for JSON to CSV Conversion
Use an Array of Objects
The cleanest CSV comes from a JSON array where every item is a flat object with the same keys, like [{"a":1,"b":2}, {"a":3,"b":4}]. Each key becomes a column.
Flatten Deeply Nested JSON
If your data has many nested levels, consider flattening it first (for example user.id → user_id) so each value gets its own column instead of being stored as a JSON string.
Match the Delimiter to Your Locale
Spreadsheets in some European locales expect a semicolon delimiter because the comma is used as a decimal separator. Choose the delimiter your version of Excel expects to avoid everything landing in one column.
Watch for Inconsistent Keys
When objects have different keys, the header is the union of them all and missing values become empty cells. Check that this is what you want before importing.
Keep UTF-8 in Mind
The download is UTF-8. If Excel shows garbled accented characters, import the file via Data → From Text and select UTF-8 encoding.
Validate Your JSON First
If you get an 'Invalid JSON' message, check for trailing commas, single quotes instead of double quotes, or unquoted keys — these are the most common JSON mistakes.
JSON and CSV Reference
JSON vs CSV
JSON is a hierarchical, typed format ideal for APIs and nested data. CSV is a flat, untyped table format ideal for spreadsheets and bulk data. Converting between them is a routine step in data pipelines.
When to convert JSON to CSV
- Open an API response or export in Excel or Google Sheets.
- Load data into a database or BI tool that imports CSV.
- Share tabular data with non-technical colleagues.
- Quickly inspect a list of records as rows and columns.
RFC 4180 quoting
The CSV standard requires fields containing a delimiter, double quote, or line break to be wrapped in double quotes, with embedded quotes doubled. This converter applies those rules automatically.
Conversion Rules
Array of objects → table
Each object becomes one row; each unique key becomes one column.
[{"a":1,"b":2}] → a,b / 1,2
Header = union of keys
Columns are every key across all objects, in first-seen order.
Missing keys become empty cells.
Nested value → JSON string
Objects and arrays are written as JSON text inside the cell.
{"tags":["a","b"]} → "[""a"",""b""]"
Quoting
Cells with a delimiter, quote, or newline are wrapped in double quotes.
Hello, world → "Hello, world"
JSON to CSV Converter FAQ
Q01How do I convert JSON to CSV?
Paste your JSON array of objects into the input box. The tool instantly converts it to CSV: each object becomes a row and each key becomes a column. Then click Copy or Download CSV. Everything happens in your browser.
Q02What JSON structure does it expect?
An array of objects works best — for example [{"name":"Alice","age":30}, {"name":"Bob","age":25}]. A single object becomes a one-row CSV, and an array of plain values becomes a single-column CSV.
Q03What happens to nested objects and arrays?
CSV is a flat format, so nested values cannot become their own columns automatically. The converter keeps them by writing the nested object or array as a JSON string inside that cell, so nothing is lost. For separate columns, flatten the JSON first.
Q04Can I use a semicolon or tab instead of a comma?
Yes. Use the delimiter selector to switch between comma, semicolon, tab, or pipe. Semicolon and tab are useful for European spreadsheets and TSV workflows.
Q05Is my JSON uploaded to a server?
No. The conversion runs entirely in your browser with JavaScript. Your data is never sent or stored anywhere, so it is safe to convert private or sensitive JSON.
Q06Will the CSV open correctly in Excel?
Yes. Values containing commas, quotes, or line breaks are quoted and escaped following the RFC 4180 standard, so the file opens cleanly in Excel, Google Sheets, and other spreadsheet apps.
Q07Is there a size limit?
There is no fixed limit, but because everything runs in your browser, very large files (tens of megabytes) depend on your device's memory. For typical API responses and exports it is instant.
Q08Is this JSON to CSV converter free?
Yes, completely free with no signup, no watermark, and no limits. Convert as much JSON as you like.