How is nested JSON handled in CSV?

Nested objects and arrays are flattened into dot-notation columns — {"address":{"city":"London"}} becomes an address.city column, and arrays get numbered like tags.0, tags.1.

Can I exclude some fields from the CSV?

Yes — every detected column appears as a chip above the editor; click to toggle it, or use All / None.

Why does my CSV open with broken characters in Excel?

Excel needs a byte-order mark to read UTF-8 — the downloads here include one, so accents and emoji display correctly.

Does CSV → JSON handle quoted fields with commas and newlines?

Yes — the parser implements the full CSV quoting rules ("" escapes, embedded delimiters and line breaks), and can infer numbers, booleans, and null while preserving leading-zero IDs as strings.

JSON ↔ CSV Converter

Turn a JSON array into a spreadsheet-ready CSV: nested objects flatten to dot-notation columns, you choose exactly which columns to export, and the download opens cleanly in Excel. The reverse direction parses CSV (quoted fields included) back to a JSON array with optional type inference — all in your browser.

How to use JSON ↔ CSV Converter

Paste a JSON array of objects — the CSV preview and the column chips appear instantly.
Click column chips to exclude fields you don’t want; pick a delimiter (comma, semicolon, tab, pipe).
Download the .csv (UTF-8 with BOM, so Excel shows accents correctly) or copy it. Switch direction for CSV → JSON.

Frequently asked questions

How is nested JSON handled in CSV?: Nested objects and arrays are flattened into dot-notation columns — {"address":{"city":"London"}} becomes an address.city column, and arrays get numbered like tags.0, tags.1.
Can I exclude some fields from the CSV?: Yes — every detected column appears as a chip above the editor; click to toggle it, or use All / None.
Why does my CSV open with broken characters in Excel?: Excel needs a byte-order mark to read UTF-8 — the downloads here include one, so accents and emoji display correctly.
Does CSV → JSON handle quoted fields with commas and newlines?: Yes — the parser implements the full CSV quoting rules ("" escapes, embedded delimiters and line breaks), and can infer numbers, booleans, and null while preserving leading-zero IDs as strings.

More Programmer & Developer Tools

Code Beautifier — Automatically format your JavaScript, CSS, and HTML with customizable indentation and style rules.
Minifier — Reduce bundle sizes by removing whitespace, comments, and optimizing code structure for production.
JSON Diff — Compare two JSON objects structurally to spot added, removed, and changed keys — or switch to line and word mode for plain text and code.
JSON Validator — Validate, parse, and prettify JSON data. Identifies syntax errors with precise line number reporting.
RegEx Tester — Build and test regular expressions in real-time with syntax highlighting and match group visualization.
Base64 Converter — Quickly encode and decode strings or files to Base64 format for safe data transmission.
Cron Generator — Generate cron job expressions using a human-friendly interface. Includes execution schedule preview.
JWT Debugger — Decode and inspect JSON Web Tokens. Verify signatures and view payload data without exposing secrets.