JSON to CSV Converter

Convert JSON arrays to CSV format for Excel and spreadsheets

JSON Input

CSV Output

What Is JSON to CSV?

CSV (Comma-Separated Values) is a flat format: each row is a line, each column is separated by a comma. JSON is nested. Converting JSON to CSV means flattening arrays of objects into rows, with each object property becoming a column. Spreadsheets like Excel and Google Sheets open CSV directly. So do many data pipelines and ETL tools.

This tool takes a JSON array and produces CSV. Each object in the array becomes one row. Nested objects and arrays are flattened or stringified depending on structure. The conversion runs in your browser; nothing is sent to a server.

How to Use This Tool

1

Paste Your JSON

Paste a JSON array into the left editor. The input should be an array of objects, e.g. [{"subscriberId": "SUB-001", "planId": "premium"}, {"subscriberId": "SUB-002", "planId": "basic"}]. You can also upload a file or use Sample.

2

Review the CSV

The right panel shows the CSV output. The first row is the header (column names). Values containing commas are quoted per RFC 4180.

3

Download or Copy

Use Download to save as a .csv file, or Copy to paste into a spreadsheet. If your JSON needs formatting first, use the JSON Formatter.

Where JSON to CSV Helps

API responses from Postman or fetch often return arrays of objects. Converting to CSV lets you open the data in Excel or Google Sheets for analysis, sharing with stakeholders, or importing into other systems. Database exports, webhook payloads, and log entries that are JSON arrays can be flattened to CSV for reporting or ETL pipelines. The JSON Path tool can extract specific values first if you need to filter before converting.

JSON to CSV Examples

Here is an example of converting a JSON array of subscriber records to CSV format.

Example: Subscriber records

JSON input (array of objects):

Input

CSV output:

Output

Limitations

CSV is flat. Deeply nested JSON (objects inside objects, arrays of arrays) doesn't map cleanly. This tool flattens one level: top-level keys become columns. Nested structures may be stringified or flattened with dot notation. For complex data, consider keeping it as JSON or using a format like Parquet.

If your data is in CSV and you need JSON, use CSV to JSON. For converting JSON to other formats, there are tools for XML, YAML, and TypeScript.

Frequently Asked Questions

What if my JSON is an object, not an array?

The tool expects an array of objects. Wrap a single object in brackets: [{"a": 1}]. Or convert it to an array in your source.

How are nested objects handled?

Nested objects are typically flattened with dot notation (e.g. user.name) or stringified. The exact behavior depends on the implementation. Check the output to confirm.

What about special characters in values?

Values with commas, quotes, or newlines are wrapped in double quotes per the CSV spec. Excel and most tools handle this correctly.

Can I convert CSV back to JSON?

Yes. Use the CSV to JSON tool on this site.

Is my data private?

Yes. Conversion runs in your browser. No data is uploaded.

Related Tools

JSON Formatter CSV to JSON JSON Validator JSON to XML JSON to YAML JSON to TypeScript JSON Path CSV Formatter

The CSV format is described in RFC 4180. For JSON, see json.org, RFC 8259, and MDN JSON. For the reverse conversion, use CSV to JSON.