CSV looks simple until it is not.
One extra comma, a quoted field with a newline, or the wrong delimiter is enough to break a quick conversion.
Start here:
- Open the CSV to JSON Converter.
- Paste your CSV.
- Download or copy the JSON.
Textavia parses and converts CSV locally in your browser.
Quick start
- Open the CSV to JSON Converter.
- Paste the CSV.
- Leave Delimiter: Auto-detect unless you know it is wrong.
- Confirm whether First row is header is true.
- Copy the JSON array.
If the output looks wrong, the fix is usually delimiter or headers. See Common CSV problems.
What "CSV to JSON" usually means
Most converters output one of two shapes:
- array of objects (common for APIs)
- array of arrays (common for raw export)
Textavia outputs an array of objects.
That means the first row becomes keys (headers), and every other row becomes an object.
Delimiters: comma is common, but not guaranteed
A CSV file can use:
- commas:
, - semicolons:
; - tabs:
\t - pipes:
|
If your JSON output is one giant field per row, you probably picked the wrong delimiter.
Quoted fields: why commas inside values are not a problem
A properly quoted CSV field can contain commas:
name,notes
"Lee","Met at ACME, Inc. conference"
If quotes are unbalanced or inconsistent, parsers can still fail.
Examples
Example 1 (beginner): normal comma CSV
Input:
name,contact
Ava,ava-contact
Noah,noah-contact
Output:
[
{"name":"Ava","contact":"ava-contact"},
{"name":"Noah","contact":"noah-contact"}
]
Example 2 (beginner): no header row
If your CSV has no headers:
- turn off First row is header
Textavia will generate column names like col_1, col_2, etc.
Example 3 (professional): semicolon-delimited export
Many European exports use semicolons.
If auto-detect is wrong:
- set delimiter to
;
Example 4 (professional): inconsistent rows
If one row has fewer columns, it will produce missing fields.
Fixes:
- clean the CSV first (remove broken rows)
- or edit the source export
Common CSV problems (and the fix)
| Problem | What you see | Fix |
|---|---|---|
| Wrong delimiter | one key with the whole line | set delimiter manually |
| Headers are missing | keys like col_1 | turn on header row |
| Headers have spaces | awkward keys like First Name | normalize headers before converting |
| Extra blank lines | empty objects | remove blank lines |
| Quotes are broken | shifted columns | fix the source or re-export |
If you need to validate and clean a CSV, use the CSV Cleaner & Validator first.
If you only do 3 things
- Confirm delimiter.
- Confirm whether the first row is headers.
- Fix broken quotes in the source export.
Related tools
- Clean and validate input with the CSV Cleaner & Validator.
- Format JSON output with the JSON formatter.
Privacy and security
Textavia's CSV parsing and conversion run locally in your browser. Your CSV is not uploaded to a server.