Tool overview
What is a CSV ↔ JSON Converter?
A CSV ↔ JSON converter transforms delimited tables (CSV/TSV and similar) into JSON arrays of objects—and serializes JSON back to delimited text.
Why use this CSV ↔ JSON tool?
Move data between spreadsheets, scripts, and APIs without uploading datasets; pick delimiters and preview structure before export.
Key Features
CSV/TSV and custom delimiters, bidirectional conversion, client-side parsing, and one-click copy or download.
How to Use
Follow these steps to get accurate results from the tool interface above.
- Choose JSON → CSV or CSV → JSON (defaults to JSON → CSV).
- Pick a delimiter in the toolbar: comma (CSV), tab (TSV), semicolon, or pipe.
- Paste a JSON array of objects, or delimited text with a header row.
- Review the result—fields with delimiters, quotes, or newlines are RFC 4180 quoted.
- Download or Copy, or pipe JSON in from JSON Formatter / YAML ↔ JSON.
CSV to JSON & JSON to CSV — Syntax Reference
Online CSV to JSON and JSON to CSV conversion. Export expects a JSON array of objects. Import expects a header row plus values separated by your chosen delimiter (comma, tab, semicolon, or pipe).
| Feature / Context | Valid Syntax Example | Common Pitfall / Invalid Example |
|---|---|---|
| Valid Array Root | [{"id":1,"name":"Ada"}] | {"id":1,"name":"Ada"}A single object at the root is not an array—wrap records in square brackets. |
| Homogeneous Keys | [{"a":1,"b":2},{"a":3,"b":4}] | [{"a":1},{"b":2,"c":3}]Sparse objects produce empty cells but missing columns may shift alignment—normalize keys before export. |
| Escaped Delimiters | {"note":"hello, world"} | note: hello, worldFields with the active delimiter must be JSON strings; the exporter wraps them in RFC 4180 double quotes. |
| Tab-Separated Values (TSV) | id name
1 Ada | id,name with Tab selectedSet the toolbar delimiter to Tab for TSV ↔ JSON. A mismatched delimiter splits columns incorrectly. |
| Nested Objects | {"user":{"id":1}} | [{"user":{"id":1}}] without flattenNested objects are JSON-stringified into a single cell—flatten deep structures in JSON Formatter first if you need separate columns. |
Frequently Asked Questions
Expandable answers for common debugging bottlenecks and data privacy questions.
Official Documentation & References
Authoritative specifications and platform documentation for this utility.