What you get
With First row is a header on, each following row becomes an object whose keys are the header names:
id,name,active [
1,Ann,true → {"id": 1, "name": "Ann", "active": true},
2,Bo,false {"id": 2, "name": "Bo", "active": false}
]Turn it off to get an array of arrays instead, one per row.
Type conversion
Convert numbers & booleans turns 42 and 3.14 into numbers, true/false into booleans,
and empty cells into null. It deliberately leaves values alone when converting would lose information:
postcodes and account numbers with leading zeros (0412), phone numbers with +, and integers longer
than JavaScript can represent exactly stay as strings. Turn the option off to keep every value as a string.
Delimiters, quotes and line breaks
The delimiter is detected from the first rows; override it if the guess is wrong. Fields in double quotes may contain
the delimiter, line breaks and escaped quotes (""), as defined in RFC 4180. A UTF-8 byte-order mark at the start of
the file (added by Excel) is removed. Empty trailing lines are skipped.
Headers like address.city and address.zip can be combined into nested objects with Nest dotted headers,
reversing what the JSON to CSV converter does.
Is my data uploaded?
No. The conversion runs in your browser, so nothing you add is sent to gratistools.be. See the privacy page for details.