JSON to CSV Converter

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

[
  { "id": 1, "item": "Pen", "qty": 3 },
  { "id": 2, "item": "Book, red", "note": "gift" }
]

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.

Formats and limits

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

Tools people use next

• CSVEXCEL

  CSV to Excel

  Open any CSV as a real .xlsx workbook.

• XMLJSON

  XML to JSON

  XML converted to JSON with attributes and nesting kept.

• JSONPDF

  JSON to PDF

  Pretty-printed JSON in a monospace PDF.

• CSVPDF

  CSV to PDF

  A tidy printed table from a CSV, with the delimiter detected.

• MARKDOWNANYTHING

  Markdown to Anything

  Export Markdown to PDF, Word, HTML, or Text with formatting intact.

• HTMLPDF

  HTML to PDF

  A paginated PDF from an HTML file — links and headings kept.