Free JSON to CSV Converter
Convert JSON arrays to CSV in your browser. Paste JSON or upload a .json file — the converter parses any array of objects and maps all keys to columns. Nested objects are optionally flattened using dot notation (e.g. address.city becomes a column). Preview the result as a table, then copy or download a properly-escaped CSV file. 100% client-side, no data leaves your device.
🗂️
Arrays of objects
Paste any JSON array of objects — the converter maps all unique keys across every row to CSV columns automatically.
🔀
Flatten nested JSON
Enable flattening to expand nested objects into dot-notation columns. address.city becomes its own column.
🔒
100% private
All conversion runs in your browser. Your JSON is never sent to any server.
Frequently Asked Questions
What JSON structure is expected?+
The tool expects a JSON array of objects — the standard format for tabular data, like what you get from a REST API. Example: [{"name":"Alice","age":30},{"name":"Bob","age":25}]. Each object becomes a row, and all unique keys across all objects become columns.
What happens to keys that are missing in some rows?+
Missing keys are output as empty cells in that row. All column headers are derived from the union of all keys across every object in the array, so no data is lost.
What is dot-notation flattening?+
When enabled, nested objects are flattened into top-level columns using dot notation. For example, {"address":{"city":"London"}} becomes a column named address.city. Arrays within objects are serialized as JSON strings.
Does the CSV handle commas and quotes inside values?+
Yes. Any value containing a comma, double quote, or newline is wrapped in double quotes and internal double quotes are escaped as "" — this is standard RFC 4180 CSV escaping, compatible with Excel, Google Sheets, and any CSV reader.
Can I change the delimiter?+
Yes. Choose between comma (default), semicolon (common in European locales), tab, or pipe using the delimiter selector.
Is my JSON data safe?+
Yes. All conversion happens entirely in your browser. Your JSON — including API responses, tokens, or any other sensitive values — is never sent to any server.
You might also like
JSON to CSV: Turning API Data into Spreadsheets
REST APIs and modern databases return data as JSON. Stakeholders, finance teams, and analysts typically work in spreadsheets (Excel, Google Sheets) — which import CSV natively. Converting JSON arrays to CSV is one of the most frequent data-handoff tasks in any organization that combines engineering with business operations.
What JSON Structures Can Be Converted?
This tool converts JSON arrays of objects — the standard format returned by most REST APIs and ORMs. Each object in the array becomes one row. The tool automatically collects all unique keys across every object in the array and maps them to columns, so sparse data (rows with different key sets) is handled correctly with empty cells where a key is missing.
How Dot-Notation Flattening Works
When "Flatten nested objects" is enabled, nested properties are promoted to top-level columns using dot notation. A record like {"user":{"name":"Alice","city":"London"}} becomes two columns: user.name and user.city. Arrays inside objects are serialized as JSON strings and placed in a single column. This makes deeply nested API responses directly importable into spreadsheets without manual reshaping.
RFC 4180 CSV Compliance
The output follows the RFC 4180 CSV standard: values containing commas, double quotes, or newlines are wrapped in double quotes, and embedded double quotes are escaped by doubling them (""). This ensures correct parsing by Excel, Google Sheets, Python's csv module, and virtually every other CSV reader.