What is JSON to CSV Converter?
Free JSON to CSV converter. Paste or upload a JSON array of objects and download a clean CSV in seconds. Handles nested objects with dot-notation flattening. 100% in-browser, no signup.
JSON to CSV runs entirely in your browser using JavaScript (browser). Your data never leaves your device.
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
Browse all 19 Developer Tools tools →CSV to JSON Converter
Convert CSV files to clean JSON instantly — free, private, no upload
JSON Formatter
Format, validate, and minify JSON instantly
Base64 Encoder / Decoder
Encode and decode Base64 text and files instantly
JSON to CSV: Turning API Data into Spreadsheets
REST APIs, modern databases, and JavaScript applications return data as JSON. Stakeholders, finance teams, and analysts typically work in spreadsheets — Excel and Google Sheets import CSV natively but cannot directly open JSON. Converting JSON arrays to CSV is one of the most frequent data-handoff tasks in any organization that combines engineering with business operations. This converter handles it in your browser instantly, with no upload required.
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 CSV columns. Sparse data — arrays where different objects have different keys — is handled correctly: missing keys produce empty cells rather than misaligned columns.
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 in a single column. This makes deeply nested API responses directly importable into spreadsheets without manual reshaping — useful for responses from services like Stripe, Salesforce, or Google APIs that return complex nested objects.
RFC 4180 CSV Compliance and Delimiter Options
The CSV output follows the RFC 4180 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, R's read.csv(), and virtually every other CSV reader. The delimiter selector lets you switch to semicolon (common in European locales where commas are used as decimal separators), tab (for TSV files), or pipe for compatibility with legacy systems.
Privacy When Exporting API Data
API responses often contain sensitive data — customer records, internal metrics, authentication tokens, or PII. This converter runs entirely in your browser. Your JSON is never uploaded or transmitted anywhere. This makes it safe to use with production API responses, internal data exports, and any JSON that contains values you would not want a third-party server to log.