Convert JSON to CSV Online

The CSV Output

The example JSON produces this CSV:

name,age,email
Alice,30,alice@example.com
Bob,25,bob@example.com

Each object in the array becomes one row. The keys name, age, and email become column headers in the order they appear in the first object.

How JSON Arrays Map to CSV

CSV is fundamentally a tabular format. It requires a uniform set of columns across all rows, which means your JSON input must be an array of objects with a consistent structure.

The converter scans all objects in the array, collects the union of their keys, and uses that set as column headers. Each object becomes a row with values placed under the matching key.

When to Convert JSON to CSV

Spreadsheet Analysis

Excel, Google Sheets, and Numbers all read CSV natively. If your data lives in a JSON API or database export, converting to CSV lets you open it in a spreadsheet for sorting, filtering, pivot tables, and charts without writing any code.

Data Import

Most data import tools accept CSV: database bulk loaders, ETL pipelines, CRM systems, and analytics platforms. Converting JSON to CSV lets you move data from a web API into these systems through a standard format.

Email and Reporting

Many business tools generate reports as CSV for email attachment. If you are building a system that outputs JSON, converting to CSV produces a universally readable file that non-technical stakeholders can open in any spreadsheet application.

Data Sharing

CSV is the lingua franca of data exchange between organizations. When you need to share structured data with a partner who uses a different tech stack, CSV avoids format negotiation because every language and tool can read it.

Handling Edge Cases

Commas in Values

CSV uses commas as delimiters, so values containing commas must be wrapped in quotes. The converter handles this automatically: a value like "Istanbul, Turkey" becomes "Istanbul, Turkey" in the CSV cell.

Newlines in Values

Multiline JSON strings break CSV row boundaries unless the value is quoted. The converter wraps values with newlines in double quotes, which is the standard CSV escape for this case.

Unicode and Special Characters

CSV files need proper encoding. UTF-8 is the safe default. The converter outputs UTF-8 encoded CSV, which Excel and most modern tools handle correctly. Older Excel versions on Windows may need the file saved with BOM (byte order mark) to display non-ASCII characters properly.

JSON to CSV Limitations

CSV cannot represent hierarchical data. If your JSON has deeply nested structures, you lose the nesting information when converting to CSV. The flattened column names preserve the path, but the consumer must parse them back. For truly hierarchical data, stick with JSON or convert to a format that supports nesting like XML or YAML.

One-to-many relationships (like a user with multiple addresses) are particularly awkward in CSV. You either duplicate the user row for each address or join the addresses into a single cell, both of which make downstream processing harder.