DocsBolt

JSON to CSV Converter

Turn JSON data into CSV format for use in Excel and data analysis tools.

.json · up to 200 MB per file

  • JSON
  • up to 200 MB per file
  • Never uploaded

What JSON to CSV does

Flatten JSON into CSV so a spreadsheet can open it. APIs, exports and logging systems hand you JSON, which is excellent for programs and awkward for people. CSV opens straight into Excel or Sheets where you can sort, filter and chart the data without writing any code.

Worked example

in · orders.json
[
  { "id": 1, "item": "Pen", "qty": 3 },
  { "id": 2, "item": "Book, red", "note": "gift" }
]
out · orders.csv
id,item,qty,note
1,Pen,3,
2,"Book, red",,gift

Columns are the union of every object's keys, in first-seen order. Missing values are empty; a value with a comma is quoted.

How it works

  1. 01

    Upload JSON

    Choose the .json file — an array of objects works best.

  2. 02

    Convert

    DocsBolt maps JSON objects to CSV rows.

  3. 03

    Download

    Get a .csv with one row per record and a column per key.

Diagram: a JSON document passes through the converter and comes out as a CSV document, with its headings, table and picture preserved.JSONCONVERTCSV

Formats and limits

Accepts
.json
Produces
CSV
Files per run
One
Size limit
200 MB per file

When you'd use it

  • An API export to open in Excel
  • Analytics events to load into a spreadsheet
  • A list of records for someone who wants a table

Limitations

  • Nested objects and arrays inside a record are written into one cell as JSON text rather than being split into extra columns.
  • The column set is the union of all keys; records missing a key get an empty cell.

Questions

What happens to nested objects?

They are kept, but not spread out: a nested object or array is written into its cell as compact JSON text, because CSV is strictly two-dimensional. Top-level keys become the columns. If you need the nested fields as their own columns, flatten the JSON first.

How are arrays handled?

Arrays of records become rows, which is the usual shape of an API response and converts cleanly. Arrays sitting inside a single field are combined into one cell.

Will my column order be preserved?

Columns follow the key order in the source data. JSON objects have no guaranteed ordering, so if a specific column order matters, rearrange it in the spreadsheet afterwards.

What happens to your file

Your file is never uploaded or stored.

Full detail in the Privacy Policy.

Tools people use next

More Data tools

Markdown, HTML, JSON, XML, CSV, plain text and eBook conversions.

Browse Data & text tools