Free · Private · Spreadsheet-safe

JSON to CSV Converter

Convert a JSON array or object to CSV online. Flatten nested fields, preserve 64-bit IDs and decimal tokens exactly, and protect spreadsheet cells from formula injection—all without uploading your data.

Convert JSON to CSV No sign-up · Runs in your browser
customers.csv
id,name,address.city
9007199254740993,Ada,London
9007199254740995,Grace,New York

2 rows · 3 columnsExact IDs preserved

Online data converter

Paste JSON and download clean CSV

LiveParse parses strict JSON with its lossless engine, discovers every column across the records, and creates RFC 4180-style delimited output locally.

Loading the JSON to CSV converter…

Enable JavaScript to convert, copy, and download CSV.

Three quick steps

How to convert JSON to CSV online

The converter accepts a JSON array of records, a single JSON object, or an array of primitive values. It does not send your input to an API.

  1. 1

    Paste or open JSON

    Use an API response, database export, analytics payload, or local .json file. Strict syntax errors include a line and column.

  2. 2

    Choose the table shape

    Keep nested objects compact or flatten them into columns such as address.city. Select comma, semicolon, tab, or pipe output.

  3. 3

    Copy or download CSV

    Review the generated row and column totals, then copy the result or save a .csv file for Excel, Sheets, a database, or a script.

Predictable flattening

How nested JSON becomes a CSV table

CSV is a two-dimensional format, while JSON can contain objects and arrays at any depth. With Flatten nested objects enabled, LiveParse turns each nested object path into a column. For example, {"address":{"city":"Seoul"}} becomes an address.city column.

Nested arrays stay as compact JSON inside one correctly quoted cell. This avoids silently multiplying rows or losing the relationship between array items. Turn flattening off when another system expects the original nested object in a single cell.

Column headers are the union of keys found across all records, so later records can introduce fields without being discarded. Missing values become empty cells. Repeated JSON keys receive separate headers such as status #2 instead of overwriting an earlier value.

Object
One row for a single object; multiple rows for an array of objects.
Nested object
Flattened to escaped dot-path columns, or kept as compact JSON.
Nested array
Serialized as compact JSON in one CSV cell.
Missing field
Written as an empty cell while the shared header remains.

Data integrity first

CSV output designed for real production data

64-bit numbers stay exact

Large IDs such as 9007199254740993, long decimals, and exponent notation are copied from the original JSON token instead of passing through a JavaScript number.

Spreadsheet formulas are neutralized

Text beginning with =, +, -, or @ receives a leading apostrophe so opening untrusted CSV is less likely to execute a formula.

CSV quoting is automatic

Commas, selected delimiters, quotes, and line breaks are escaped automatically. A quote inside a field is doubled before the entire field is quoted.

Your data stays local

Parsing and conversion happen in the current browser tab. LiveParse does not upload, store, or log the JSON or CSV content you provide.

Common workflows

When to convert JSON to CSV

Analyze an API response

Turn an array returned by a REST or GraphQL endpoint into columns that analysts can filter, sort, chart, or join.

Open data in Excel or Sheets

Export predictable CSV without first writing a conversion script or pasting sensitive records into a remote service.

Prepare a database import

Choose a delimiter required by a warehouse or relational database while keeping absent fields explicit and nested arrays intact.

Convert logs and exports

Move JSON records from browser storage, a NoSQL database, or an observability tool into a portable tabular file.

Questions answered

JSON to CSV FAQ

Is this JSON to CSV converter free?

Yes. It is free to use without an account, quota, or paid tier.

Can it convert nested JSON to CSV?

Yes. Nested objects can be flattened into dot-path columns. Nested arrays remain compact JSON in one cell so the converter does not invent extra rows.

Will large JSON numbers be rounded?

No. LiveParse keeps the original JSON number token when creating CSV, including integers beyond JavaScript's safe range and decimals with trailing zeros.

Does it support JSON with different keys in each record?

Yes. Headers are collected from all records, not only the first one. A record without a particular key gets an empty cell in that column.

Can I use semicolon, tab, or pipe delimiters?

Yes. Choose comma, semicolon, tab, or pipe before converting. Fields containing the chosen delimiter are quoted automatically.

How do I convert CSV back to JSON?

Use the CSV to JSON converter. It supports headers, quoted fields, multiline values, optional type inference, and JSON downloads.