File format
CSV files: format, quirks and conversion
Fileshape reads and writes CSV (.csv, .txt, MIME type text/csv). Conversion runs in your browser.
CSV (comma-separated values) is the lowest common denominator of tabular data: plain text, one record per line, fields separated by a delimiter. Almost every system can import and export it, which is why it's the default for moving data between apps. The format is only loosely standardised (RFC 4180), so files from different sources disagree on delimiters, quoting and encoding.
Fields containing the delimiter, quotes or line breaks are wrapped in double quotes, with inner quotes doubled. Fileshape uses a full CSV parser that handles all of this, auto-detects the delimiter and strips a UTF-8 byte-order mark. When writing, it quotes only where needed and uses CRLF line endings, which every spreadsheet and importer accepts.
Quirks
- European Excel uses semicolons because the comma is the decimal separator there.
- There are no types: 00123, 1E5 and 2026-01-02 are all just text until the importer interprets them.
- Cells starting with =, +, - or @ can execute as formulas when opened in a spreadsheet; Fileshape escapes them by default.