JSON to CSV Converter

Convert JSON arrays to CSV format for spreadsheets and databases

JSON Input

Delimiter:

Arrays:

Nulls:

Ctrl+Enter to convert

Share to Community

Was this tool helpful?

What is JSON to CSV Converter?

Free online JSON to CSV converter to convert a JSON array of objects to CSV (Comma-Separated Values) format instantly.

Paste your JSON and get a properly formatted CSV file ready to open in Excel, Google Sheets, or import into a database. Use it to convert an API response to a spreadsheet, export JSON to Excel, or flatten nested JSON to a table. The tool auto-detects column headers from your JSON keys, flattens nested objects with dot notation, and lets you switch the delimiter to comma, semicolon, tab, or pipe. Download the result as a .csv file with one click. Everything runs in your browser, so your data never leaves your device. No signup required.

How to Use JSON to CSV Converter

1Paste your JSON array into the input field
2Choose your preferred delimiter (comma, semicolon, tab, or pipe)
3Click 'Convert' to generate the CSV output
4Copy the CSV text or click 'Download CSV' to save as a file

Frequently Asked Questions

The tool accepts a JSON array of objects, e.g., [{"name": "Alice", "age": 30}, {"name": "Bob", "age": 25}]. Each object in the array becomes a row in the CSV, and the object keys become column headers.

Yes. By default the tool uses commas, but you can switch to semicolons, tabs, or pipes as the delimiter. This is useful for locales where commas are used as decimal separators.

Nested objects are flattened using dot notation. For example, {"address": {"city": "NYC"}} becomes a column named 'address.city'. Arrays within objects are joined with semicolons.

Click 'Download CSV' to save the file, then open it directly in Excel or import it through File, Import in Google Sheets. The headers come from your JSON keys, so each property lands in its own column. If your locale uses commas as decimal separators, switch the delimiter to semicolon before downloading.

Yes. Copy the JSON array from the API response, paste it in, and convert. As long as the response is an array of objects, each object becomes a row, which makes it a quick way to turn API data into a spreadsheet for analysis.

Share this tool

Related Tools

📋

YAML to CSV Converter

Free online YAML to CSV converter - convert YAML arrays to CSV spreadsheet format

📊

CSV to JSON Converter

Free online CSV to JSON converter - convert CSV data to JSON format with delimiter options and preview

<{>

JSON to XML Converter

Free online JSON to XML converter - convert JSON data to XML format instantly

🔄

XML to JSON Converter

Free online XML to JSON converter - convert XML documents to JSON format

CSV

CSV Viewer

Free online CSV viewer - view, sort, and filter CSV data in an interactive table format

YML

YAML ↔ JSON Converter

Free online YAML ↔ JSON converter - convert between YAML and JSON formats with validation and formatting

What is JSON to CSV Converter?

Free online JSON to CSV converter to convert a JSON array of objects to CSV (Comma-Separated Values) format instantly.

Frequently Asked Questions

Yes. By default the tool uses commas, but you can switch to semicolons, tabs, or pipes as the delimiter. This is useful for locales where commas are used as decimal separators.

Nested objects are flattened using dot notation. For example, {"address": {"city": "NYC"}} becomes a column named 'address.city'. Arrays within objects are joined with semicolons.