JSON to CSV Converter

Convert JSON arrays or objects into CSV spreadsheets and TSV files. Flattens nested keys, parses quotes properly, and provides instant file download.

Free, no sign-upRuns in your browserUpdated November 2026
Converted CSV Results
3 Rows, 5 Columns
Header Columns: id, name, role... Output Size: 210 Bytes

How to use the JSON to CSV Converter

  1. Paste your raw JSON Array or list of objects into the source box, or click Load Sample JSON.
  2. Select your desired Column Delimiter (standard comma for US Excel, semicolon for European Excel, or tab for TSV).
  3. Choose whether to include the Header Row based on object keys.
  4. Click Download .CSV File to open the spreadsheet directly in Microsoft Excel, Google Sheets, or Apple Numbers.

Why Convert JSON to CSV for Data Analysis?

In modern web engineering and REST API architecture, JavaScript Object Notation (JSON) is the default format for transmitting structured datasets between servers and clients. However, when corporate business stakeholders, data analysts, and accountants need to analyze this information, JSON is difficult to parse visually.

Converting JSON payloads into Comma-Separated Values (CSV) allows immediate data exploration inside spreadsheet tools like Microsoft Excel, Google Sheets, Power BI, and Tableau. A tabular grid allows instant sorting, mathematical aggregations, pivot table creation, and VLOOKUP modeling.

JSON Array of Objects → Extraction of Unified Key Set → RFC 4180 Row Sanitization → Delimited CSV

RFC 4180 Compliance: Proper Quoting and Escaping

The biggest challenge when converting JSON to CSV is ensuring valid output under RFC 4180 (the official IETF specification for CSV files). Simple naive splitting often breaks spreadsheets whenever a field value contains a comma or quote mark:

  • Comma in Values: If an address is "123 Main St, Suite 400", leaving it unquoted causes Excel to split the street and suite into two separate columns. RFC 4180 mandates enclosing the cell in double quotes: "123 Main St, Suite 400".
  • Escaping Literal Quotes: If a string contains a literal quote mark (e.g. John "Babe" Ruth), RFC 4180 requires escaping it by doubling the quote: "John ""Babe"" Ruth".
  • Standard CRLF Line Endings: Compliant CSV files terminate rows using standard Windows CRLF (\r\n) carriage return and line feed sequences.

Handling Missing and Non-Uniform Keys

Unlike relational database tables where every row has identical columns, JSON objects often contain optional or jagged fields. For example, Record 1 might contain { "name": "Alice", "phone": "555-1234" }, while Record 2 contains { "name": "Bob", "email": "bob@example.com" }.

This converter first scans every object across the entire JSON array, compiles a comprehensive master set of all unique keys, and automatically populates blank empty cells for any records missing that specific attribute.

Worked Example: Employee Roster Transformation

Given the following JSON dataset:

[
  { "id": 101, "name": "Sarah Connor", "role": "Engineer", "salary": 115000 },
  { "id": 102, "name": "John Doe", "role": "Designer", "salary": 92000 }
]

The resulting RFC 4180 CSV export:

id,name,role,salary
101,Sarah Connor,Engineer,115000
102,John Doe,Designer,92000

Frequently asked questions

How do I convert a JSON file to CSV?
Paste your JSON text into the input box or click "Load Sample JSON". The tool automatically parses the objects and generates an RFC 4180 compliant CSV file ready for download.
What happens if my JSON objects have different keys?
The converter aggregates all unique keys across all objects into a single master header row, leaving blank cells for items that omit certain keys.
Why does European Excel show all CSV data in one column?
In countries that use the comma as a decimal point (like Germany or France), Excel expects semicolons (;) instead of commas (,). Use the Semicolon delimiter option to open directly in European Excel.
Can I convert TSV (Tab-Separated Values)?
Yes. Select the "Tab (TSV format)" option in the delimiter dropdown to export tab-separated data.
Is there a limit on the size of the JSON file?
Because conversions occur locally in your browser memory, this tool can comfortably process arrays containing tens of thousands of rows within seconds.
Is my proprietary data uploaded to an external server?
No. All JSON parsing and CSV generation occurs 100% on your local machine inside browser memory.

Last reviewed November 2026. Results are estimates for information only — see our disclaimer.