CSV

JSON to CSV Converter

LOCAL · Browser-Only

Convert JSON arrays to CSV format for spreadsheets and databases

JSON Input

Delimiter:

Arrays:

Nulls:

Ctrl+Enter to convert

·Share recipe

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

What JSON format does this tool accept?

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.

Can I use a different delimiter?

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.

How does it handle nested JSON objects?

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.

How do I open the converted CSV in Excel or Google Sheets?

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.

Can I convert an API response to a spreadsheet?

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

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

📊

Convert csv to json online

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

🔄

Xml json converter

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

CSV

View csv file

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

YML

Yaml to json online

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

⇄

Toml parser

Convert between TOML and JSON online - bidirectional converter with full TOML v1.0 support

⚡

Bulk text transform

Free online batch processor - process multiple files at once with 40+ text transformations

⇌

Unit Converter

Free online unit converter - convert between units of length, weight, temperature, speed, and data storage

Keep reading: Bash/Shell Cheat Sheet and http status codes reference. Doing this in code instead? See the encoding endpoints.

CSV