JSON to CSV Converter

1. Paste your JSON — Any array, object, or nested structure. Upload a .json file or drag & drop one directly.
2. Pick your delimiter — Comma (default), semicolon (for European Excel locales), tab (TSV), or pipe.
3. Choose options — Toggle the header row, dot-notation flattening, UTF-8 BOM for Excel, CRLF line endings, always-quote mode, and array stringification.
4. Click "Convert to CSV" — The tool flattens nested objects, escapes quotes and delimiters, and renders the result as both a styled table preview and the raw CSV source.
5. Copy or download — Click Copy CSV to copy the raw CSV to your clipboard, or Download .csv to save the file.

JSON is the dominant data format for APIs, app config, and database exports — but for human-readable analysis, spreadsheet pivot tables, or one-off Excel reviews, CSV is still king. Converting between them sounds simple until you hit nested objects, mixed-shape arrays, or values containing commas and quotes. Our converter handles all the messy edge cases so the output Just Works:

• Dot-notation flattening — Nested objects like {"user":{"name":"Jane","age":30}} become columns user.name and user.age. Works recursively to any depth.
• Heterogeneous arrays — When array items have different keys, the converter takes the union of all keys as columns. Missing values become empty cells.
• Configurable delimiter — Comma, semicolon (for European Excel), tab (TSV), pipe, or your own single character.
• Excel-ready BOM — Optional UTF-8 byte-order-mark so Excel renders accents, currency, and CJK characters correctly.
• Smart quoting — Cells with delimiters, quotes, or newlines are automatically wrapped in double quotes with internal quotes doubled per RFC 4180. Toggle "always quote" for downstream consumers that prefer fully-quoted CSV.
• Configurable line endings — CRLF (Windows/Excel) or LF (Unix).
• Array stringify mode — Array values inside cells become JSON strings (so the structure survives the round-trip) instead of being silently dropped.
• Live table preview — See the result as a styled table AND the raw CSV source via the tab toggle.

100% browser-based — your data never leaves your machine. No file size limits beyond browser memory, no signup, no privacy concerns. Safe for API responses with tokens, internal exports, customer data, and anything else you wouldn't want passing through someone else's server.

• Privacy-first — Runs 100% in your browser. No upload, no server logs, no third-party API calls.
• RFC 4180 compliant — Quote handling, escaping, and line endings match the standard so Excel, Google Sheets, Python pandas, R, and every other CSV consumer parses the output cleanly.
• Real nested-object handling — Many free converters either fail on nested JSON or drop nested keys silently. Ours flattens predictably with dot notation.
• Excel-ready out of the box — Tick the BOM and CRLF options and your file opens correctly in Excel without "this file appears to be corrupted" or mangled non-ASCII characters.
• No ads, no signup, no tracking — Clean interface, no cookie banners.
• Draft persistence — Your last input auto-saves in localStorage.
• Keyboard-first — Ctrl+Enter runs the conversion without lifting your hands off the keyboard.

• API response → Excel analysis — Stakeholders want a spreadsheet, not a JSON dump. Convert and email the CSV.
• Database export → BI tool — Many BI tools accept CSV but not JSON arrays. The flattened CSV imports cleanly.
• MongoDB / NoSQL export → relational DB — Flatten nested documents into a CSV that a relational schema can ingest.
• Survey/form responses — JSON from a form-builder API converted to CSV for analysis in Excel pivot tables.
• E-commerce orders → bookkeeping — Take the order API response, convert to CSV, import to QuickBooks or a similar accounting tool.
• Test fixtures → spreadsheets — Generate test data in JSON, export to CSV for QA spreadsheets.
• Log analysis — Structured JSON logs converted to CSV for Excel filtering and chart building.
• Quick data preview — JSON is hard to scan visually. The table preview here is sometimes all you need.