CSV to JSON Converter
Convert CSV files or pasted text into a JSON array. Auto-detects delimiter, parses numbers and booleans, handles quoted fields.
Last updated: April 2026 · Runs in your browser · No sign-up
Quick workflow
Export from Excel or Google Sheets as CSV, paste here, get JSON you can feed into an API, a test fixture, or a config file. Useful for converting business-owned spreadsheets into machine-readable data.
CSV pitfalls to watch
- BOM (byte-order mark) at the start — strip before parsing.
- CR vs LF line endings — both are handled.
- Locale differences: 1.234,56 (DE) vs 1,234.56 (US).
Frequently Asked Questions
Does it auto-detect the delimiter?
Yes. Commas, semicolons and tabs are detected by sampling the first few lines. You can override manually if detection guesses wrong.
Are types inferred?
Optional. With type inference on, '42' becomes 42, 'true' becomes true, empty cells become null. Off, every value stays a string.
What if my CSV has no header row?
Toggle 'no header' — keys become col1, col2, col3 etc. Or supply your own comma-separated header.
Does it handle multi-line fields?
Yes, per RFC 4180. Fields containing newlines must be enclosed in double quotes; escaped quotes use doubling ("").