How the data is converted
Every conversion goes through an intermediate structure (objects, lists, strings, numbers): the input is parsed, then written out in the output format. Everything happens in the browser, nothing is uploaded.
- CSV: the first row gives the column names; each row becomes an object. Quoted fields may contain the delimiter, doubled quotes ("") or line breaks. On output, nested objects become dotted columns (
address.city) and lists are written as JSON in the cell. - XML: attributes become keys prefixed with
@, the text of an element that also has attributes or children becomes#text, and repeated elements become a list. The other way round, the same conventions produce attributes and repeated elements; key names that are invalid in XML are fixed (forbidden characters replaced by_). - YAML: read and written with the js-yaml library (YAML 1.2). YAML comments are not kept.
- Types: CSV and XML only contain text. With the option ticked, "42", "3.5", "true" and "false" become numbers and booleans; untick it to keep strings (for example postcodes such as "01000").
To validate or format JSON on its own, use the JSON formatter.