CSV to JSON
Parse CSV and convert to JSON. Auto-detects the delimiter, type-infers numbers and booleans, and produces a clean array of objects keyed by header row.
How to use the CSV to JSON
Paste CSV. Auto delimiter detection sniffs the first line for the most common separator. Type inference turns 123 into the number 123, true/false into booleans; everything else stays as string.
Converting CSV into JSON
CSV is what spreadsheets and data exports speak, but almost every script, API, and config expects JSON. The conversion looks trivial until the details bite: which character is the delimiter, whether the first row is a header, and whether 42 and true should stay as text or become a real number and boolean.
This parses CSV into a clean array of objects keyed by the header row, sniffing the delimiter automatically and optionally inferring numbers and booleans so the JSON is ready to use rather than all-strings. For the reverse direction the JSON to CSV converter flattens objects back into columns, and for tab-separated input specifically the TSV to JSON converter is tuned to that format.
Common use cases
- Feed an API — turn a spreadsheet export into JSON a request body expects.
- Seed test data — convert a CSV of records into a JSON fixture.
- Type-infer — get real numbers and booleans instead of quoted strings.
- Odd delimiters — handle semicolon, tab, or pipe files without manual fixes.
- Headerless data — convert files where the first row is already data.