Convert CSV to JSON (and back)
Convert CSV or TSV to JSON, or JSON back to CSV. Auto-types numbers, handles quoted fields with commas and newlines, custom delimiters. Free, in your browser.
CSV5 lines · 185 B
JSON
Your spreadsheet stays on your device.
Parsing uses Papa Parse running in your browser. No upload, no server — safe for customer data, exports, and anything else you wouldn’t paste into a random site.
How to use it
- 1Pick a direction — CSV → JSON or JSON → CSV.
- 2Set the delimiter (comma, tab, semicolon, pipe, or a custom string). Toggle whether the first row is a header.
- 3Paste your data on the left. The output appears on the right and updates as you type.
- 4Click Download to save the result as a .json or .csv file, or Copy to send it to the clipboard.
Common use cases
- Lift a spreadsheet export into JSON to feed an API or a data pipeline.
- Convert a JSON array of objects (e.g. from a webhook log) into a CSV you can open in Excel or Numbers.
- Migrate data between systems that prefer different formats — most B2B exports are CSV, most modern APIs are JSON.
- Inspect a tab-separated SQL export by converting it to a readable JSON shape.
- Clean up an inconsistently-quoted CSV from someone else's pipeline — the parser handles quoted commas and embedded newlines.
Frequently asked questions
- Is my data sent to a server?
- No. The conversion runs entirely in your browser using Papa Parse. Important when the input is a customer list, sales export, or anything else with personal data — it stays on your machine.
- Does it handle CSV fields with commas, quotes, or newlines?
- Yes. The parser follows RFC 4180 — fields wrapped in double quotes can contain commas, newlines, and escaped quotes (""). The sample input demonstrates a row with a comma inside a quoted field.
- What's TSV?
- Tab-Separated Values — the same shape as CSV but with tabs between fields instead of commas. Pick Tab as the delimiter and paste your TSV input.
- Will numbers stay as numbers?
- Yes. CSV → JSON auto-detects numeric and boolean values ("42" becomes 42, "true" becomes true). If you'd prefer everything as strings, paste the JSON back through with the toggle and edit by hand.
- Can I round-trip a file?
- Yes — convert CSV → JSON, then hit Swap. The result goes back through as JSON → CSV. Useful for sanity-checking that the parser read your delimiter and quotes correctly.
- What about CSV without headers?
- Uncheck 'First row is header'. CSV → JSON returns an array of arrays (raw rows); JSON → CSV expects an array of arrays as input.
Try next
JSON Formatter and Validator
Free online JSON formatter, validator, and beautifier — pretty-print, minify, diff, and explore JSON. Nothing ever uploaded.
YAML ↔ JSON Converter
Bidirectional YAML / JSON conversion with multi-document support and indentation control. Free, in your browser.
Text Diff
Compare two pieces of text and see line-by-line, word-by-word, or character-by-character what changed.