littlekit.
Free. No account.

JSON to CSV

Builds CSV columns from the union of object keys, preserving first-seen order.

Your inputs stay in your browser. No account required.
Loading tool controls…

How JSON to CSV works

Builds CSV columns from the union of object keys, preserving first-seen order. Missing or null values become empty cells; nested values remain JSON strings. All cells are quoted and potential spreadsheet formulas are prefixed with an apostrophe.

Try an example

[{"name":"Alex","hours":3}] becomes a CSV header and one data row.

Good to know

Processed in this browser. Maximum 100,000 input characters and 10,000 records. JavaScript JSON parsing can round large numbers and keeps the last duplicate key; quote identifiers to preserve them. Formula protection intentionally changes leading =, +, -, @ and control-character values, including negative numbers. Verify spreadsheet import settings; CSV has no type information.

Your privacy

Processing happens on this device for this tool. We do not upload your input, put it in share links or save it to your favourites. Closing this tab discards the working input; downloaded results remain wherever you save them.

When this tool is useful

Use JSON to CSV for a quick local export of an array of objects when a spreadsheet or analyst needs rows and columns.

How to use it

  1. Provide a JSON array whose records are objects.
  2. Review the union of column names and the escaped CSV output.
  3. Download the file, then confirm how your spreadsheet interprets dates, nulls and nested values.

Checks before you rely on the result

  • Nested values are represented as JSON text rather than guessed into extra columns.
  • Records with missing keys produce an empty cell for that column.
  • CSV is a data interchange format; review formulas and leading zeros before opening it in a spreadsheet.

This page is maintained with the tool implementation and its deterministic tests. If the result looks wrong, report the issue with a non-sensitive example.

Read the JSON to CSV instructions

A useful next step

JSON Flattener
JSON to JSON Lines
JSON Lines to JSON
Made for clarity. Built to be useful.Report an issue