JSON to CSV

What is JSON to CSV?

JSON to CSV converts structured JSON arrays into comma-separated value format with proper quoting, escaping, and header row generation. It handles nested objects by flattening them with dot-notation column names (address.city, address.zip), arrays by joining elements or creating multiple columns, and mixed-type fields by applying consistent type coercion. The tool preserves data types where possible and handles null, undefined, and empty string distinctions correctly in the CSV output.

Data analysts converting API data for spreadsheet analysis, developers exporting application data for stakeholders, and operations teams preparing data for system imports. The tool runs entirely in your browser — your data never leaves your device.

How to Use JSON to CSV

1. Paste a JSON array of objects or upload a .json file
2. Configure flattening options — dot notation for nested objects, join character for arrays
3. Preview the resulting CSV table with column headers derived from JSON keys
4. Download the .csv file or copy the output to clipboard

Common Use Cases

• Exporting API response data to CSV for analysis in Excel or Google Sheets
• Converting JSON database exports to CSV for import into legacy systems that only accept tabular data
• Flattening nested JSON objects into a spreadsheet-friendly format for non-technical stakeholders
• Preparing JSON data for bulk upload to CRM or marketing platforms that accept CSV imports

Pro Tips

• Nested objects flatten to dot-notation columns by default — {address: {city: 'NYC'}} becomes the column 'address.city'; some spreadsheet tools may not handle dots in headers, so the tool offers underscore as an alternative separator
• JSON null and empty string are different but CSV cannot distinguish them — the tool preserves null as an empty cell by default, but you can configure a sentinel value like 'NULL' to maintain the distinction
• Arrays of varying lengths in JSON rows create ragged CSVs — the tool pads shorter arrays with empty cells to keep columns aligned, but verify the alignment if your data has inconsistent array sizes

Why Use This Tool?

• Privacy-first: All processing happens locally in your browser. No data is transmitted to any server.
• No installation required: Works in any modern browser on desktop or mobile.
• Completely free: No account, no credit card, no usage caps.
• Fast and reliable: Powered by modern Web APIs for near-instant results.

Related Concepts

Learn more about related topics: Data flattening, CSV escaping, RFC 4180, Data export.

Frequently Asked Questions