JSON to CSV Converter flattens a JSON array of objects into a comma-separated file that opens directly in Excel, Google Sheets, or any data tool. Developers use it to export API responses, database query results, and analytics datasets into the tabular format that product managers and analysts can filter and share. Nested objects are flattened using dot notation so all fields become separate columns.
The converter reads all objects in the array to collect every unique key and builds the header row. It then maps each object's values to the correct columns, leaving cells empty for keys that a particular object does not have. Nested objects like {"address": {"city": "London"}} are flattened into a column named "address.city" using dot notation.
Nested objects are flattened using dot notation. For example, {"address": {"city": "London"}} becomes a column named "address.city" with the value "London". Very deeply nested structures can produce many columns, so you may want to simplify the JSON before converting if the output is too wide.
CSV is a plain-text format with no concept of data types — all values are stored as text. When you open the result in Excel or Google Sheets, the application automatically detects numbers, dates, and other recognizable formats. If you need explicit type control, specify column types when importing in your spreadsheet tool.
Yes. If you paste a single JSON object, the tool treats it as a one-row table with the object keys as column headers. The tool works best with JSON arrays where each element is an object with a consistent structure.
Values that contain a comma are automatically wrapped in double quotes in the CSV output, following the RFC 4180 standard. For example, the value "London, UK" becomes ,"London, UK", in the CSV so the internal comma is not confused with the column separator.
No. The entire conversion runs in your browser using JavaScript. Your JSON data never leaves your device, making this safe to use with sensitive or proprietary data.
The converter collects all unique keys from all objects and uses them as column headers. Objects that are missing a key will have an empty cell in that column. This handles API responses where optional fields only appear on some records.
Tool workspace
Free JSON to CSV converter. Paste a JSON array and get a spreadsheet-ready CSV file for Excel, Google Sheets, or database imports. No login required.
Output
Input
[{"user":"Alice","role":"Admin"},{"user":"Bob","role":"Editor"}]Output
user,role Alice,Admin Bob,Editor