formatika

Convert JSON to CSV

We turn JSON into CSV right in your browser — the file never goes to a server.

What you will lose

  • Nested objects have to be flattened: a table has no room for an object inside an object.
  • Numbers, booleans and empty values become plain text, and turning them back is guesswork.

How they differ

JSONCSV
Nestingnono
Value typesnono
Commentsnono
Released20011972
AuthorDouglas CrockfordIBM

JSON

Good at

  • Nesting of any depth
  • Numbers, strings, lists and null are told apart
  • Read by everything that talks over a network

Awkward about

  • No comments — nowhere to explain what a field means
  • One stray comma breaks the whole file
  • Harder for a human to read than YAML: braces and quotes

Use it when

  • Exchange between programs and APIs
  • The data is nested: objects inside objects
  • You need a format that does not argue about what a number is

CSV

Good at

  • Opens in anything, from Excel to a plain text editor
  • Lands in a spreadsheet without a line of code
  • Weighs exactly what the data weighs

Awkward about

  • No single standard: quotes, commas and line breaks are read differently everywhere
  • No nesting — an object inside an object has to be flattened
  • A number, a boolean and an empty cell look the same as text

Use it when

  • An export for a spreadsheet or a report
  • Exchange between systems that agreed on a separator
  • The data is flat: rows and columns, nothing nested

Common questions

Does the file get uploaded to a server?
No. JSON → CSV runs right in your browser and the file never leaves your device. It only goes to a server if the browser cannot cope — and then we delete it within a couple of hours.
Is nesting preserved?
No. CSV is a flat table, so anything nested is spread into columns with compound names.
Can I get the original quality back afterwards?
Yes, CSV supports lossless compression, so you can go back to the original.
How many files, and how large?
Up to 20 files at a time, 20 MB each. No sign-up, no watermarks.

Similar conversions

Open the full tool