JSON to CSV Converter
Convert an array of JSON objects into CSV.
Turn an array of JSON objects into downloadable CSV with correct quoting for commas, quotes, and line breaks.
Tool area
Worked example: an object array with a comma-containing field
Enter [{"name":"Alice","role":"Senior, Eng"},{"name":"Bob","role":"PM"}] and the output is a header row name,role, followed by Alice,"Senior, Eng" and Bob,PM. Because the role value itself contains a comma, the tool automatically wraps it in quotes so a spreadsheet does not split it into two columns.
This conversion direction has no delimiter selector and no option to add a UTF-8 BOM; the output always uses commas with no BOM. Double-clicking the downloaded file to open it directly in Excel can show garbled characters for Chinese text or emoji if Excel guesses a non-UTF-8 encoding; importing through Data > From Text/CSV and manually choosing UTF-8 is more reliable.
What happens when the input is not an array, and how to verify the output
If you paste a single object such as {"name":"Alice"} instead of an array, the tool shows "The JSON root must be an array of objects" and clears the output. If the pasted text is not valid JSON at all, for example a missing closing quote, it shows a fixed English message, "The input is not valid JSON.", which does not get translated on the Chinese site, so you need to check the raw input yourself for the missing character.
To verify the output, paste the CSV back into this site's CSV to JSON tool and confirm the restored object count and keys match the original JSON. You can also open the file in a spreadsheet and manually check that fields containing a comma or line break stayed inside a single cell.
How to use
- Paste the source data.
- Convert and review the output.
- Copy or download the result.
Use cases
- Convert spreadsheet exports.
- Prepare data for APIs or analytics.
Content and verification review:
How to verify a JSON to CSV Converter result before relying on it
This section covers three ways JSON to CSV Converter differs from this site’s other CSV-exporting tools: no delimiter choice, no formula-injection guard, and no byte-order mark in the download.
Convert a small array and check the column order
Paste [{"name":"Alice","age":18},{"name":"Bob","age":20}] and click Convert: the output is a two-row CSV with a header row, and the column order follows the order keys first appear across the objects — name, then age. This tool has no delimiter dropdown and no row/column summary line the way some other converters on this site do; the only way to check the result is to read the output box directly.
Missing keys across objects become blank cells, not dropped columns
Paste [{"name":"Alice","age":18},{"name":"Bob","city":"Taipei"}] — the second object has no “age” and an extra “city” — and the columns become the union of every key seen (name, age, city); Bob’s age cell and Alice’s city cell are both left blank rather than the column being removed or the conversion failing. Pasting a single object instead of an array, or an empty array [], both trigger the same “JSON root must be an array of objects” error — an empty array is technically an array, but with zero rows there are no columns to build, so it gets the same message as a genuinely wrong shape.
The download has no BOM and no formula-injection escaping
Unlike this site’s other CSV exporters, this file downloads without a UTF-8 byte-order mark, so a CSV containing non-ASCII text may look garbled if double-clicked open directly in Excel — importing it and manually selecting UTF-8 encoding avoids that. It also does not automatically neutralize values starting with “=”, “+”, “-”, or “@” (which spreadsheet apps can misread as formulas), so check any field starting with one of those characters before opening the file in a spreadsheet with macros enabled.
Acceptance checklist
- The pasted content is a JSON array of objects (wrapped in [ ]), not a single object and not an empty array.
- Column order and any blank cells from missing keys have been checked in the output, since columns are the union of all object keys, not just the first object’s keys.
- The downloaded CSV is opened with UTF-8 explicitly selected (import, not double-click) whenever it contains non-ASCII text.
- Any field value starting with =, +, -, or @ has been checked manually, since this converter does not add formula-injection protection the way some of this site’s other CSV tools do.
Who is it for
- Developers handing API results to spreadsheet users
- Analysts reviewing arrays of flat JSON objects
- Operations teams preparing simple import files
Real examples
Export an API list to a spreadsheet
Use an array of objects with consistent keys. After conversion, verify the header row and fields containing commas, quotes, or line breaks before opening the CSV in Excel or Google Sheets.
Prepare a file for another system
Check the destination system for required column names, order, encoding, and allowed values. This tool produces standard CSV but cannot automatically satisfy a specific CRM, commerce, or accounting import schema.
Good to know
- Nested objects and arrays are not automatically flattened into a business-specific schema.
- Missing keys can become blank cells, so review column completeness before importing the file elsewhere.
- CSV does not preserve JSON types; spreadsheets may reformat dates, leading zeros, and long numeric identifiers.
FAQ
- Are quotes and line breaks supported?
- Yes. Conversion uses a CSV parser that handles quoted fields.
- Is data uploaded?
- All input and files are processed only in this browser tab and are not uploaded to a server.
Privacy & local processing
🔒 This tool runs entirely in your browser. No data is uploaded to any server.
All input and files are processed only in this browser tab and are not uploaded to a server.
Trust & usage note
This tool runs mainly in your browser. Your input is not actively uploaded to a server. Avoid entering highly sensitive data. Results are for reference only.
Last updated:
Get updates
New tools and practical tips, straight to your inbox. No spam, unsubscribe anytime.