{}JsonLab

Free · client-side · no sign-up

JSON to CSV Converter

Turn a JSON array of objects into clean CSV you can open in Excel, Google Sheets or any spreadsheet. Nested objects are flattened into columns, special characters are escaped correctly, and everything happens in your browser.

Open the JSON editor

Use cases

Export API data to a spreadsheet

Convert a JSON API response into CSV so it can be opened and filtered in Excel or Sheets.

Share data with non-developers

Hand stakeholders a familiar CSV instead of raw JSON.

Import into BI or databases

Produce CSV that loads cleanly into analytics tools and bulk importers.

Flatten nested records

Collapse nested objects into dotted columns like address.city for tabular analysis.

Flatten nested objects

Nested objects become dotted columns (e.g. address.city); arrays are serialized into single cells.

Choose your delimiter

Comma, semicolon or tab — pick what your spreadsheet locale expects.

Header row toggle

Include or omit the column header row depending on your import target.

RFC-4180 escaping

Values containing commas, quotes or newlines are quoted and escaped correctly.

Example

JSON input
[
  { "id": 1, "name": "Ada", "city": "London" },
  { "id": 2, "name": "Linus", "city": "Helsinki" }
]
CSV output
id,name,city
1,Ada,London
2,Linus,Helsinki

How to use it

  1. 1Open the JSON editor and paste a JSON array of objects.
  2. 2Pick your delimiter and whether to include a header row.
  3. 3Copy the CSV or download it as a .csv file.

Frequently asked questions

What JSON shape works best?

An array of objects converts most naturally — each object becomes a row and the union of keys becomes the columns. Single objects and arrays of primitives are also supported.

How are nested objects handled?

With flattening enabled, nested objects expand into dotted column names; with it off, they're written as a JSON string in a single cell.

Is my data uploaded?

No. Conversion runs entirely in your browser, so your data never leaves the page.

Related tools

JSON Formatter & Beautifier

Beautify and format messy JSON instantly with a VSCode-grade editor. Validate as you type, view as a tree, minify, copy and download — all in your browser.

JSON Validator

Validate JSON online and get precise, line-and-column error messages for every syntax problem.

JSON Diff Tool

Compare two JSON documents and highlight everything that was added, removed or changed.

Ready to go?

No sign-up, no uploads — everything runs in your browser.

Open the JSON editor