12 chars · 2 lines
12 chars · 2 lines
12 chars · 2 lines
12 chars · 2 lines
CSV type-preservation behavior
Both 42 and 37 look numeric, but CSV itself does not declare a type for either column. VetaTool therefore emits strings rather than guessing that one or both should become JSON numbers. This tool is free to use. No account or payment is required.
Last updated
Account IDs, postal codes, versions, and product codes can contain only digits but must remain text. Avoiding automatic numeric coercion protects those values.
The output below is the actual JSON produced by the same CSV to JSON mode for the preloaded source.
id,age
42,37[
{
"id": "42",
"age": "37"
}
]Common questions
Because CSV does not carry a reliable number type and VetaTool preserves cell text.
Yes. Apply an explicit transformation to known numeric columns.
Yes. Keeping CSV cell text as strings avoids JavaScript number precision changes during CSV-to-JSON conversion.
Debugging a specific CSV issue? Browse CSV troubleshooting.