Paste your JSON or upload a .json file and download a perfectly formatted CSV in one click. Handles arrays of objects, nested structures with configurable flattening depth, and custom delimiters (comma, semicolon, or tab). All conversion runs in your browser: your data is never sent to a server. No sign-up. No logs ever kept. Free forever.

Free JSON to CSV Converter: Paste, Convert & Download Instantly

Paste or upload any JSON array — download a clean CSV spreadsheet instantly. Free, private, runs in your browser.

Your JSON data is processed locally in your browser. Nothing is sent to any server. Zero logs. Zero tracking.

0 chars
Paste JSON above to get started.

Convert JSON to CSV Free: Instant, Private, No Limits

JSON is the language of APIs and modern data. CSV is the language of spreadsheets and business analysis. Getting data from one to the other should be simple, but nested JSON structures, inconsistent keys, and special character escaping make it surprisingly tricky to do manually.

Our free JSON to CSV converter handles all of that automatically. Paste your JSON array, set your options, and download a properly structured, correctly escaped CSV file in seconds: entirely in your browser, with no data leaving your device.

What JSON Structures Are Supported?

Array of Objects (Most Common)

The standard API response format: a JSON array where each element is an object with the same keys. Each object becomes a row in the CSV; each key becomes a column header. Example:

[
  {"name": "Alice", "age": 30, "city": "London"},
  {"name": "Bob",   "age": 25, "city": "Paris"}
]

Output: a CSV with columns name, age, city and two data rows.

Nested Objects (With Flattening)

When objects contain nested child objects, the flattening option expands them into dot-notation column headers. For example, {"user": {"name": "Alice", "role": "admin"}} becomes columns user.name and user.role. Set the maximum flattening depth to control how deep the converter goes with deeply nested structures.

Three Delimiter Options

Not all CSV files use commas. Choose the right delimiter for your target application:

  • Comma ( , ): the standard delimiter. Compatible with Microsoft Excel (English locale), Google Sheets, and most data import tools.
  • Semicolon ( ; ): used as the default in European locales of Excel (where commas are decimal separators). Use this if your CSV opens with all data in one column in Excel.
  • Tab ( \t ): produces a TSV (tab-separated values) file. Useful for data that contains commas within values, or for pasting directly into spreadsheet cells.

Proper CSV Escaping: Always

The converter follows the RFC 4180 CSV standard for escaping:

  • Values containing commas, semicolons, tabs, or newlines are wrapped in double quotes
  • Double quote characters within values are escaped as two double quotes ("")
  • Newlines within values are preserved and the value is quoted

This means the output is always a valid, correctly escaped CSV that imports cleanly into any spreadsheet application: no manual fixing needed.

Header Row Control

The header row (column names) is included by default. Toggle it off if you need a raw data CSV without headers: for example, when appending rows to an existing spreadsheet that already has its own header row.

Upload a JSON File Directly

Instead of pasting, click the Upload tab and select a .json file directly from your device. The file content is read in the browser: it is not uploaded to any server. Maximum file size is 2 MB for browser-based processing. For larger files, consider splitting the JSON first.

Who Converts JSON to CSV?

  • Data analysts: export API data into Excel or Google Sheets for analysis without writing a script
  • Developers: quickly inspect API responses in spreadsheet format during development or debugging
  • Marketers: convert CRM or analytics exports into spreadsheet-friendly format
  • Business intelligence teams: prepare data from REST APIs for import into BI tools
  • Database administrators: convert JSON query results to CSV for bulk import into relational databases
  • Non-technical users: work with JSON data in a familiar spreadsheet format without writing code

How to Convert JSON to CSV Online

  1. Paste your JSON into the input panel: or click Upload to select a .json file.
  2. Set options: choose delimiter, toggle header row, and enable or disable nested object flattening.
  3. Click Convert: the CSV output appears in the output panel.
  4. Download CSV: click Download to save the .csv file to your device.

Free, Private & No Limits

This JSON to CSV converter is completely free to use with no sign-up and no usage limits. Convert as many JSON files as you need. All processing happens in your browser: your data is never sent to our servers, and we keep zero logs.

Frequently Asked Questions

Is the JSON to CSV converter free?
Yes, completely free, forever. All features including nested flattening, delimiter options, and file upload are available with no account, no subscription, and no usage limits.
Is my JSON data sent to a server?
No. All conversion happens locally in your browser using JavaScript. Your data is never transmitted to our servers and we keep zero logs.
Why does my CSV open with all data in one column in Excel?
This happens in European locales of Excel where the comma is a decimal separator and semicolons are expected as the CSV delimiter. Switch to the Semicolon delimiter option and re-download the CSV. Alternatively, use Excel's "Get Data from Text/CSV" import wizard and manually select the delimiter.
Does the converter handle nested JSON objects?
Yes. Enable the "Flatten nested objects" option and nested keys are expanded into dot-notation column headers (e.g. user.name, user.address.city). Set the maximum depth to control how many nesting levels are flattened.
What happens if my JSON array has inconsistent keys across objects?
The converter builds a unified set of all keys found across all objects. Missing values for a given object result in an empty cell for that column. No data is lost or silently dropped.
Can I convert JSON to TSV (tab-separated) instead of CSV?
Yes. Select the Tab delimiter option. The output is a tab-separated values file, which you can save with a .tsv extension. This format is especially useful for data containing commas within values.