ToolAtlas
FavoritesRecent

JSON ↔ CSV

Processed in this browser

Text limit: 2000000 characters

This tool never uploads your input.

An API list that an analyst wants in Excel. Flatten first if you need real columns. YAML is a different converter.

A report is JSON and finance wants a grid. That is this page: array-of-objects ↔ CSV in the tab. Nested addresses and tag arrays will not become clean columns.

Validate first on JSON formatter. Config files are JSON ↔ YAML. Deduping the resulting emails is line deduplicator.

Excel and semicolon locales

Nested address.city will not become a column unless you flatten first. Double-clicking a CSV in Excel often assumes a legacy code page — use Data → From text, UTF-8. Some locales expect ;. JSON Lines / a 2 GB stream is out of scope.

How to use it

  1. Paste a JSON array or a CSV with a header row.
  2. Convert. Download or copy.
  3. Open in Excel via “from text” if accents break.

Honest limits

Not a data warehouse. Not Excel formulas. Not BI.

FAQ

Why is my nested JSON one ugly cell?

CSV is a rectangle. Objects-in-objects are stringified. Flatten in code if you need address.city columns.

Is this the JSON formatter?

No. Pretty-print and validate there first if the paste will not parse.

Excel opened it with mojibake.

Use Data → From text and UTF-8. Some locales expect ; not ,.

JSON Lines / NDJSON?

This wants a JSON array (or a headered CSV), not a 2 GB stream of single objects.

Is the data uploaded?

No. Huge pastes are RAM-limited.

Related tools