21 chars · 3 lines
21 chars · 3 lines
3 rows2 columnsComma delimiter
21 chars · 3 lines
21 chars · 3 lines
CSV empty-record conversion behavior
The final line contains two empty fields separated by a comma. That is structurally different from having no row at all: it is a complete two-column record, so the converter emits a second object with empty string values. This tool is free to use. No account or payment is required.
Last updated
For a two-column table, a line containing one comma encodes two empty fields. The converter preserves that record instead of silently dropping it.
The output below is the actual JSON produced by the same CSV to JSON mode for the preloaded source.
name,role
Ada,admin
,[
{
"name": "Ada",
"role": "admin"
},
{
"name": "",
"role": ""
}
]Common questions
The comma defines two fields, and both are empty values for the two header columns.
No. A completely blank line has one field in this parser and can trigger a column-count mismatch.
No. Whether they are meaningful depends on the source workflow, so VetaTool keeps valid records explicit.
Debugging a specific CSV issue? Browse CSV troubleshooting.