14 chars · 2 lines
14 chars · 2 lines
2 rows2 columnsComma delimiter
14 chars · 2 lines
14 chars · 2 lines
CSV empty-cell conversion behavior
The sample has a role column but the data cell is blank. CSV does not tell the converter whether that means null, unknown, intentionally empty, or missing, so VetaTool preserves the cell as the empty string "". This tool is free to use. No account or payment is required.
Last updated
Different systems use blank cells differently. Preserving an empty string avoids silently choosing a meaning that the CSV file never declared.
The output below is the actual JSON produced by the same CSV to JSON mode for the preloaded source.
name,role
Ada,[
{
"name": "Ada",
"role": ""
}
]Common questions
No. VetaTool emits an empty string.
The source row still contains that column, so preserving the key keeps the table shape intact.
Yes. Do that as an explicit schema-aware transformation after CSV parsing.
Debugging a specific CSV issue? Browse CSV troubleshooting.