JSON to CSV

Convert JSON to CSV format

Developer Tools

How to Use JSON to CSV

  1. 1Paste your JSON array
  2. 2Click Convert to CSV
  3. 3Copy or download the CSV output

About JSON to CSV

JSON to CSV Converter takes a JSON array of objects and transforms it into comma-separated value (CSV) format. Property names from the first object are extracted and used as column headers, and every object in the array becomes a row in the CSV output.

Fields containing commas, newlines, or double quotes are properly escaped according to the RFC 4180 CSV standard, ensuring the output is safe to import into Excel, Google Sheets, database tools, or any application that accepts CSV files.

All conversion runs entirely in your browser — paste your JSON array and the CSV output is ready to copy or download in seconds, with no server uploads required.

Key Features of JSON to CSV

  • Convert a JSON array of objects to CSV format instantly
  • Automatically extracts column headers from the first object's keys
  • Properly quotes fields containing commas, newlines, or double quotes
  • Handles missing properties in some objects (outputs empty cells)
  • RFC 4180-compliant CSV output — compatible with Excel and Google Sheets
  • Works entirely in-browser — no server upload required
  • Copy or download the CSV output with one click
  • Handles large JSON arrays efficiently

Supported Formats

Input Formats

JSON array of objects (e.g., [{"key":"value"},...])Formatted or minified JSON

Output Formats

CSV with header rowRFC 4180-compliant comma-separated format

Expects a flat array of objects. Nested objects are serialized as JSON strings in the CSV cell.

Examples

Convert API response data to CSV for a spreadsheet

Export a JSON array from an API into a format ready for Excel or Google Sheets.

Input

[{"name":"Alice","role":"Admin","active":true},{"name":"Bob","role":"User","active":false}]

Output

name,role,active
Alice,Admin,true
Bob,User,false

Convert a JSON product catalog to CSV for bulk import

Prepare product data from a JSON file for bulk import into an e-commerce platform.

Input

[{"sku":"ABC-1","title":"Widget","price":9.99},{"sku":"ABC-2","title":"Gadget","price":24.50}]

Output

sku,title,price
ABC-1,Widget,9.99
ABC-2,Gadget,24.50

Common Use Cases

  • Exporting API response data into a spreadsheet for non-technical stakeholders
  • Converting database JSON exports to CSV for bulk import into other systems
  • Preparing JSON data for analysis in Excel or Google Sheets
  • Generating CSV reports from JSON log or event data
  • Converting JSON configuration arrays to CSV for data validation workflows
  • Sharing structured data with colleagues who prefer spreadsheet tools

Troubleshooting

Only the first object's keys appear as headers

Solution

The tool derives column headers from the first object. If different objects have different keys, only the first object's keys will become columns. Normalize your data so all objects have the same keys.

Nested objects appear as [object Object] in the CSV

Solution

Nested objects are serialized as JSON strings. Flatten your JSON structure before converting for cleaner output.

CSV does not open correctly in Excel

Solution

Ensure Excel is configured to use commas as the delimiter. Use Data > Text Import Wizard to specify the comma delimiter explicitly.

Frequently Asked Questions

What JSON structure is expected?

The tool expects a JSON array of objects, e.g. [{"name":"Alice","age":30}]. Each object becomes a row, and the first object's keys become CSV headers.

Are nested objects supported?

Nested objects and arrays are serialized as JSON strings in the CSV cell. Flatten your JSON structure before converting for fully flat output.

What if some objects are missing certain keys?

If an object is missing a key, the corresponding CSV cell will be empty. The tool uses the first object's keys as the definitive set of columns.

Can I import the CSV into Excel?

Yes. The output is RFC 4180-compliant CSV which Excel can open directly.

How does the tool handle commas inside values?

Values containing commas, double quotes, or newlines are automatically wrapped in double quotes per the CSV standard.

Is there a size limit for the JSON input?

There is no server-imposed size limit. Arrays with thousands of objects typically convert in under a second.

Is my data sent to a server?

No. All processing is done entirely in your browser. Your JSON data never leaves your device.

What happens if my JSON is invalid?

The tool will display an error message if the JSON cannot be parsed. Validate your JSON using the JSON Validator tool first.