JSON ↔ CSV Converter
Convert between JSON and CSV formats instantly. Free, fast, no upload required.
Use JSON ↔ CSV Converter
Options
JSON vs CSV: when to use each
CSV is a flat, tabular format best suited for rows of uniform records: exports from spreadsheets, database dumps, and anything destined for Excel, Google Sheets, or a BI tool. It is compact, diff-friendly, and trivially streamable. JSON shines when your data has structure — nested objects, arrays, mixed types, or optional fields. Use JSON for API payloads, configuration, and documents where shape matters. A good rule of thumb: if you would be comfortable opening it in a spreadsheet, CSV is usually the right call. If not, stick with JSON.
How nested JSON is converted
CSV has no native concept of nesting, so this converter takes a pragmatic approach: any value that is itself an object or array is serialised to its JSON string and placed in the cell. That keeps the output round-trippable — you can parse those cells back to JSON later — without silently dropping data or forcing you to pre-flatten. The header row is built from the union of keys across all input objects, so rows with missing fields produce empty cells rather than mis-aligned columns. If your source is JSONLines (one object per line, no outer array), it is auto-detected and parsed the same way.
Common pitfalls: commas, quotes, and escaping
Most broken CSVs come from naive string joins. A field containing the delimiter, a double-quote, or a newline must be wrapped in double-quotes, and any embedded double-quotes must be doubled up (" becomes ""). This tool handles that automatically; the "Quote all values" option forces quoting on every cell when you need maximum safety for downstream parsers. Pick a delimiter your data does not contain — semicolons are standard in many European locales where commas are decimal separators, and tabs (TSV) are a safe pick for free-text fields. For line endings, LF is the Unix/macOS default; CRLF is what Excel on Windows expects, and what RFC 4180 technically mandates.
Frequently Asked Questions
Find this useful?
These tools are free and ad-free. Support the project!