How values are written
- Strings are written as-is, double-quoted only when they contain the delimiter, a newline, or a quote.
- Numbers / booleans are stringified.
- Nulls become empty cells.
- Nested objects / arrays are JSON-stringified into a single cell, unless "Flatten nested objects" is on — then keys are joined with dots (
user.name).
FAQ
Why CRLF for Excel?
Microsoft Excel on Windows expects CRLF line endings; LF-only files open as a single row in older versions. Use CRLF when targeting Excel; LF is fine for everything else.