JSON to CSV Converter Free Online

Free online JSON to CSV converter. Paste a JSON array and instantly convert it to CSV format. Download the result.

CSV output...

Input format

Input must be a JSON array of objects. Each object becomes a row. Object keys become CSV column headers.

JSON is the standard format for API responses and web application data, but most spreadsheet tools, database imports, and business intelligence platforms work with CSV. When you receive data from an API in JSON format and need to analyse it in Excel, Google Sheets, or import it into a database, this free JSON to CSV converter transforms your JSON array data into properly formatted CSV instantly - no server, no account, no waiting.

How to Use the JSON to CSV Converter

1

Paste your JSON array

Paste a JSON array of objects into the input area. The expected format is an array where each element is an object representing one row of data - for example: [{"name": "John", "age": 30}, {"name": "Jane", "age": 25}]. If your JSON is wrapped in a parent object, the converter will try to locate the first array within it automatically.

2

Click Convert to CSV

Click the Convert button. The tool reads all unique keys from across all objects in the array and uses them as column headers. Each object becomes a row. Missing keys in some objects produce empty cells in the corresponding columns, ensuring all data is represented correctly even if the JSON objects have inconsistent keys.

3

Copy or download the CSV

Click Download to save the CSV file to your device, then open it in Microsoft Excel, Google Sheets, Apple Numbers, or any spreadsheet application. Alternatively, click Copy to copy the CSV text to your clipboard for pasting directly into a spreadsheet or database tool.

When to Convert JSON to CSV

API data analysis in Excel or Google Sheets - REST APIs return JSON, but most analysts and business users are comfortable with spreadsheets. Converting JSON API responses to CSV lets non-technical stakeholders work with API data in familiar tools without any programming required.

Database imports - most database management tools (MySQL Workbench, pgAdmin, SQLiteStudio, MongoDB Compass) accept CSV for bulk data imports. If you have JSON-formatted data you want to load into a database table, convert it to CSV first.

Data migration - when migrating data between systems that use different formats, JSON to CSV conversion is often a necessary step in the data pipeline. Many legacy systems that export JSON need their data imported into systems that only accept CSV.

Business reporting - business intelligence tools like Tableau, Power BI, and Looker can import CSV files directly. Converting JSON data exports to CSV enables them to be loaded into these visualisation platforms without custom data connectors.

Sharing data with non-technical teams - JSON is not readable by most non-technical users. Converting to CSV produces a file that anyone with Excel or Google Sheets can open, filter, sort, and analyse without any technical knowledge.

Understanding the JSON Structure Requirements

The JSON to CSV converter works best with a specific JSON structure: an array of objects where each object represents one record (row). This is the most common format returned by REST APIs when fetching a list of items - a list of users, products, orders, transactions, and so on.

If your JSON has nested objects (for example, an address object inside a user object), those nested properties are either flattened using dot notation (address.city becomes a column named "address.city") or serialised as JSON strings within the CSV cell, depending on the converter's settings. If your JSON has arrays within objects, those arrays are typically joined as semicolon-separated strings since CSV cells cannot contain structured data.

Frequently Asked Questions

What JSON structure does the converter accept?
The converter works best with a JSON array of objects (records): [{...}, {...}, {...}]. Each object in the array becomes a row in the CSV, and the object keys become column headers. The converter reads all unique keys across all objects and creates columns for each, filling empty cells where a particular object does not have a specific key.
How are nested JSON objects handled?
Nested objects are flattened using dot notation. For example, if an object has an "address" property that is itself an object with "city" and "country" keys, the CSV columns will be named "address.city" and "address.country". Arrays within objects are joined as semicolon-separated values in a single CSV cell, since the tabular CSV format cannot represent nested structures natively.
What delimiter does the CSV use?
The default delimiter is a comma (,), which is the standard for most applications. Fields that contain commas are automatically quoted with double quotes following RFC 4180 CSV specification, so the data remains correctly parseable. If your target application requires a different delimiter (semicolon or tab), most spreadsheet applications let you specify the delimiter when importing CSV.
Is my JSON data sent to a server?
No. All conversion happens entirely in your browser using JavaScript. Your JSON data never leaves your device and is never transmitted to any server. This makes the tool safe for converting sensitive data such as customer records, financial data, health information, or any confidential business data.
Can I convert back from CSV to JSON?
Yes. Use the CSV to JSON converter tool to reverse the process. It reads the header row and creates a JSON object for each CSV row, reconstructing the array of objects format that the JSON to CSV converter accepts.