JSON Forge
100% Client-Side: your data is never sent to a server

JSON to CSV

Convert a JSON array of objects into CSV for Excel, Google Sheets or a database import. Nested objects are flattened using dot notation such as address.city.

Loading editor…
Paste or type JSON on the left to explore it as a tree.
Empty🔒 Processed locally in your browser

How to convert JSON to CSV

  1. Paste a JSON array of objects into the editor.
  2. Open the Code tab and choose CSV.
  3. Copy the result and save it as a .csv file, or paste it straight into a spreadsheet.

How nested data is flattened

CSV is flat, so nested objects become columns named with dot notation (address.city) and array items are numbered (tags.0, tags.1). Columns are the union of all keys found in the array, so records that miss a field simply get an empty cell.

Quoting and escaping

Cells containing commas, quotes or line breaks are wrapped in double quotes, and inner quotes are doubled, following RFC 4180. That keeps the file readable by Excel, Google Sheets and every mainstream CSV parser.

What is JSON?

JSON (JavaScript Object Notation) is a lightweight, text-based data format that is easy for people to read and for machines to parse. It is the de facto standard for web APIs, configuration files and data exchange between services. A JSON document is built from just six value types: objects, arrays, strings, numbers, booleans and null.

{
  "name": "Ada",
  "age": 36,
  "admin": true,
  "skills": ["math", "code"],
  "address": { "city": "London" },
  "manager": null
}

JSON is stricter than JavaScript object literals: keys and strings must use double quotes, trailing commas are not allowed and comments are not part of the specification (RFC 8259).

Why format JSON?

APIs usually return minified JSON on a single line, which is efficient for machines but unreadable for people. Formatting (also called pretty printing or beautifying) adds consistent indentation and line breaks so that you can scan the structure, spot mistakes and review changes. Minifying does the opposite and strips whitespace to reduce size.

Frequently asked questions

What if my JSON is a single object?

A single object produces one row. A JSON array of primitives produces a single column called value.

Is my JSON uploaded to a server?

No. Parsing, validation, formatting, diffing and code generation all run inside your browser, using a Web Worker. Your data is never sent to any server, which makes the tool safe for API responses, configuration files and other sensitive payloads.

Does it work offline?

Yes, after the first visit. The editor and tools are stored in your browser, so you can use them without a connection. Only the TypeScript, CSS and HTML language workers used for extra highlighting in the Code tab are downloaded the first time you use them.

How large a JSON file can I open?

Files of 20 MB and more work. Parsing happens off the main thread and the tree view is virtualized, so only the rows you can see are rendered. The editor switches to a lighter mode for very large documents.

What is the difference between formatting and minifying JSON?

Formatting (pretty printing) adds line breaks and indentation so people can read the data. Minifying removes all optional whitespace to make the payload as small as possible for network transfer or storage. Both produce identical data.

Fix common JSON errors

JSON examples to try

Cheat sheets

More JSON tools