Converting JSON and CSV into each other

Export JSON objects as a CSV table

A JSON input is a single object or an array of objects. The existing keys become columns. Optionally, use a column name per row to determine which fields are exported in which order. Non-existent values remain empty. Nested objects and arrays stand as JSON text in a cell, instead of losing their structure through ambiguous point notation.

Read in CSV without reinterpreting IDs or date values

The CSV direction supports comma, semicolon, tab and automatic separator recognition. Quotes and line breaks within correctly masked fields are taken into account. The first row must contain unique column names. All values remain strings: “00123” does not become 123, and a date is not converted to another format.

Large numbers and formula protection

JSON numbers are read without the usual JavaScript rounding of large integers. The CSV export masks fields and protects potential table formulas by default with a leading apostrophe. This consciously changes these values. For a pure data import, you can turn off the protection; then control how the target program interprets cells.

What is lost when switching between JSON and CSV

CSV does not know JSON data types. zero is written as “zero” when exported, missing fields remain empty. On the way back, both are read as strings. The converter therefore does not promise the same type of concentricity. Up to 500 KB, 10,000 records and 200 columns are processed locally; the result is available as a file.

Frequent questions