Skip to content
jsonblocks

Convert JSON to CSV online

Paste a JSON array of objects and get clean CSV with detected headers. This free JSON to CSV converter handles nested values, quoting, and custom delimiters - entirely in your browser.

JSON input

Valid JSON

CSV output

3 rows × 4 cols
sku,name,price,inStock
WIDGET-001,Blue widget,49.99,true
WIDGET-002,Red widget,39.5,false
WIDGET-003,Green widget,59,true

Nested objects and arrays are preserved as compact JSON inside their cells. Everything runs locally; nothing is uploaded.

How to convert JSON to CSV with jsonblocks

  1. Paste a JSON array of objects, or load the product sample.

  2. Check the detected headers; pick comma, semicolon, or tab delimiters.

  3. Preview the CSV output with correct quoting for tricky cells.

  4. Copy the result or download it as a .csv file for Excel or Sheets.

Frequently asked questions

Which JSON shapes convert to CSV?

Arrays of objects convert best: each object becomes a row and each key becomes a column. A single object converts to a one-row CSV. Primitive arrays and deeply uneven shapes convert with empty cells where keys are missing.

How are nested objects and arrays handled?

Nested values are encoded as compact JSON inside their cell, so no data is lost. If you need nested fields as their own columns, flatten the structure first or convert a sub-array.

Which delimiter should I choose?

Use commas for most tools, including Excel in English locales. Pick semicolons if your spreadsheet locale uses commas as decimal separators, or tabs for TSV output that pastes cleanly into documents.

How is quoting handled?

Cells containing the delimiter, quotes, or line breaks are wrapped in double quotes, and inner quotes are doubled, following RFC 4180. Spreadsheet apps open the result without extra configuration.

Can I convert CSV back to JSON?

This tool converts one way, JSON to CSV. To inspect the JSON side of a dataset, paste it into the formatter or open it in the block visualizer.

Is there a row limit?

There is no fixed limit; thousands of rows convert locally in the browser. For very large exports, prefer downloading the file over copying it into a spreadsheet.