JSON ↔ CSV

Convierte entre JSON y CSV en tu navegador. Elige el delimitador, configura el comportamiento de la cabecera, pega y copia. Compatible con RFC 4180, sin subir nada.

Dirección
—

About this tool

JSON to CSV converts a JSON array of flat objects into a CSV table in your browser. The header row is derived from the union of keys across all objects, in the order they first appear. Nested objects and arrays are stringified into the cell by default, with an option to flatten one level of nested keys using dot notation (user.name, user.email). The output is RFC 4180-compliant: fields containing commas, quotes, or newlines are quoted, and embedded quotes are doubled. You can choose a delimiter (comma, semicolon, tab, pipe).

When to use it

  • Converting a JSON API response into a CSV for import into Excel or a spreadsheet
  • Flattening a nested JSON document for a one-off data analysis in a tool that only understands CSV
  • Producing a CSV from a JSON config to share with a non-developer colleague
  • Building a CSV fixture from a JSON spec for a data import pipeline

When not to use it

  • You need to round-trip back to JSON losslessly — flattening loses type information (numbers become strings), and CSV cannot represent nested structure natively
  • You need to transform a single nested object — JSON to CSV expects an array of flat-ish records as input
  • You need BigInt or arbitrary precision numbers — they are converted to strings to fit in a CSV cell

Frequently asked questions

What delimiter should I use?

Comma for the default case (RFC 4180, what Excel expects on Windows). Semicolon for Excel on systems where the locale uses comma as the decimal separator (much of Europe). Tab for TSV — useful when your data has lots of commas. Pipe when the data has both commas and tabs.

Are nested objects supported?

Yes, with the 'flatten one level' option. `{"user": {"name": "Ada"}}` becomes a row with a `user.name` column. Deeper nesting requires a separate flattening step before the conversion.

← Back to the homepage · More guides · More from the blog