Data WorkbenchJSON / JSON Formatter
A LITTLE ORDER, A LOT LESS WORK.

JSON to CSV

Combine object fields and export a spreadsheet-friendly CSV file.

01 — 18Start with data. Make room for work.
Batch processing available
INPUT
Results will appear here
Ctrl + Enter

All processing happens in this browser.

HOW IT WORKS

How to use it

  1. Accepts an object or an array of objects. Headers are the union of all fields; missing values become empty cells.
  2. Nested arrays and objects are serialized as JSON inside a cell, without flattening rows.
  3. Formula protection adds an apostrophe to formula-like text. CSV downloads include a UTF-8 BOM for spreadsheet compatibility.
Why does 00123 become 123 in Excel?

CSV cannot preserve column types. Import identifier columns explicitly as text.

Why is there an extra apostrophe?

Formula protection is enabled by default and can be disabled for trusted data.

Save these options

Save tool options only, without input text or file contents. Up to 20 presets.