Spreadsheets export CSV; APIs consume JSON. This converter bridges the two, parsing quoted fields containing commas and newlines correctly rather than naively splitting on the delimiter — which is where most quick scripts fall over on real-world data.
Correctly, provided the field is wrapped in double quotes as the CSV convention requires. The parser tracks quote state rather than splitting blindly on every delimiter.
Because locales that use a comma as the decimal separator would otherwise create ambiguity, so Excel switches the field delimiter to a semicolon. Select it in the delimiter option.
Yes when a field parses cleanly as a number, otherwise it stays a string. Leading zeros are preserved as text so postcodes and account numbers are not corrupted.
As empty strings, which preserves the column structure. If you need nulls, a find and replace over the output is the simplest fix.
All free tools · Blog · About · Contact