gratistools.be
Sign in

JSON to CSV Converter

Paste a JSON array of objects and get a CSV you can open in Excel or Google Sheets.

Runs on your device. Nothing you paste is uploaded.

How the JSON is turned into columns

  • An array of objects becomes one row per object. The columns are every key that appears in any object, in the order they're first seen; missing values are left empty.
  • Nested objects are flattened with dots: {"address": {"city": "Ghent"}} becomes a column address.city. The CSV to JSON converter can rebuild the nesting from those names.
  • Arrays inside objects are written as JSON text in one cell by default (["a","b"]), which keeps every row the same width. Turn on Expand arrays into columns to get tags.0, tags.1… instead.
  • A single object becomes a one-row CSV. An object whose values are all objects (records keyed by ID) becomes one row per entry, with the ID in a key column.
  • An array of arrays is written as-is, row by row.

Opening the CSV in Excel

If Excel shows everything in one column, it expects a different delimiter: pick Semicolon, which Excel uses in most European locales. If accented characters look garbled after opening a downloaded file, enable Excel-friendly download; it adds the UTF-8 byte-order mark Excel needs. Values containing the delimiter, quotes or line breaks are quoted correctly.

Is my data uploaded?

No. The conversion runs in your browser, so nothing you add is sent to gratistools.be. See the privacy page for details.