Developer Tools guide
JSON to CSV Converter Guide
This page holds the detailed reference that supports the focused interactive tool.
Open the JSON to CSV ConverterJSON to CSV examples and workflows
Use this converter when JSON needs to move into spreadsheets, imports, data reviews, or CSV-based tools.
How to use this tool
- Paste a JSON array of objects or one JSON object.
- Choose delimiter, headers, and nested flattening.
- Convert, then copy or download the CSV output.
Real examples
- Convert
[{"id":1,"email":"a@example.com"}]into spreadsheet CSV. - Flatten nested fields into columns such as
user.nameanduser.email. - Export API fixtures for QA, migration imports, or product data reviews.
Common use cases
- Move JSON from an API into Excel or Google Sheets.
- Create CSV imports from developer fixture data.
- Review nested JSON records in a flat table format.
Flatten nested JSON
Enable flattening when nested values should become spreadsheet columns such as user.email, plan.name, or address.city.
Objects and arrays in cells
CSV cannot store nested objects directly. Keep flattening enabled for object fields you want as columns; arrays are serialized so list values stay visible in one cell.
Excel and Sheets import
Use comma output for most spreadsheet imports, or semicolon output when your locale uses comma as a decimal separator. Keep headers enabled so reviewers can scan the exported fields.
API export to spreadsheet
Paste API response JSON, format it first if needed, then export CSV for QA review, migration checks, customer support handoffs, or product catalog cleanup.
Edge cases / errors
- Arrays and nested objects are serialized or flattened.
- CSV has no native data types; values become text cells.
- Invalid JSON must be fixed before conversion.
Sample input/output
- Input:
[{"id":7,"user":{"name":"Ada"},"active":true}] - Flattened CSV:
id,user.name,activethen7,Ada,true. - Without flattening: nested objects are serialized as JSON text inside a cell.
Common errors and fixes
- Nothing converts: paste a JSON object or an array of objects, not JavaScript code.
- Missing columns: enable headers and flatten nested fields when records are uneven.
- Broken spreadsheet cells: keep CSV quoting enabled for commas, quotes, and newlines.
Edge cases table
| Case | What to check |
|---|---|
| Mixed keys | Headers are built from all rows so sparse fields remain visible. |
| Arrays in cells | Arrays become serialized values because CSV has no nested type. |
| Delimiter choice | Use semicolon output for locales where comma is used as a decimal separator. |
Related workflow
- Validate the input first with JSON Formatter.
- Use CSV to JSON to reverse-check exported rows.
- Convert YAML configs through YAML to JSON before flattening them.
Nested JSON to spreadsheet flattening guide
Choose a flattening strategy before exporting JSON to Excel, Google Sheets, migration CSV, or a support handoff.
Flattening choices
| JSON shape | CSV result | Best use |
|---|---|---|
{"user":{"email":"a@example.com"}} | user.email column | API response review and spreadsheet filters. |
| Array of objects with uneven keys | Union of all headers | QA exports where sparse fields still matter. |
| Array values inside a field | Serialized cell value | Tags, scopes, roles, or compact list review. |
| Deep nested objects | Dot-path columns | Migration mapping and field inventory. |
For API exports
Format the JSON first, confirm the root is an array of similar objects, then flatten nested fields. After export, scan the header row for unexpected paths before sending the CSV to a non-developer reviewer.
For Excel and Google Sheets
Keep headers enabled, choose the delimiter your locale expects, and watch for long serialized arrays. If a cell contains JSON text, spreadsheet filters may not behave like filters on normal columns.
For import templates
Use a small representative JSON sample, export CSV, then manually verify required columns. A generated CSV is a starting point; production imports still need field mapping and validation.
Related Data tools
Use these tools as a local data conversion workflow.
JSON Formatter / Validator
Format and validate JSON before converting it.
CSV to JSON Converter
Convert spreadsheet-style rows back into JSON.
YAML to JSON Converter
Convert YAML config snippets into formatted or minified JSON.
XML Formatter / Validator
Format and validate XML from APIs, feeds, and config files.
JSON to CSV Converter FAQ
Answers for local JSON to CSV conversion and flattening.
Does this JSON to CSV converter upload my data?
No. The JSON is parsed and converted in your browser. Nothing is uploaded to WebUtilsLab.
What JSON shape works best?
An array of objects works best because each object becomes a CSV row. A single object becomes one row.
How are nested objects handled?
With flattening enabled, nested object keys become dot paths such as user.name.
Can I use semicolon or tab output?
Yes. Choose comma, semicolon, tab, or pipe output before converting.