What is CSV to JSON conversion?
CSV (comma-separated values) is the lingua franca of spreadsheet exports — Excel, Google Sheets, almost every database speaks it. JSON is the lingua franca of web APIs. Converting between them is the first step in countless data pipelines: importing a customer list, hydrating fixtures for tests, or feeding a chart library.
What this tool does
- Delimiter auto-detection — figures out commas, tabs, semicolons, or pipes from your data.
- RFC 4180 compliant — handles quoted fields, escaped quotes (
""), and newlines inside quoted values. - Header row — toggle on to produce an array of objects; toggle off for an array of arrays.
- Type parsing — convert numeric strings to numbers and
true/falseto booleans.
Tips
- If your file has UTF-8 BOM characters, paste them as-is — the parser strips them automatically.
- Tabs are visible delimiters in TSV files; choose Tab if auto-detect picks the wrong one.
- For very large CSVs, prefer a streaming parser at the command line; this tool is designed for inspection-sized data.
Parsing happens in your browser — no row is sent to a server.