CSV converter

Where CSV comes from

Comma-separated lists appeared in IBM Fortran compilers in the early 1970s, decades before any standard existed, and every vendor improvised its own quoting rules. RFC 4180 finally wrote the common conventions down in 2005 — describing established practice rather than prescribing anything new.

How CSV works

• Fields containing commas, quotes, or newlines are wrapped in double quotes with embedded quotes doubled — the rule that breaks every naive split-on-comma parser.
• RFC 4180 specifies CRLF record endings and an optional header row, though real-world files vary on both.
• Everything is a string: types, encodings, and even the delimiter are conventions, not rules.
• Excel chooses the delimiter from the OS locale, so machines in much of Europe expect semicolons in a file still named .csv.

When to use CSV

• Exports from databases, CRMs, and banking systems.
• Loading tabular data into spreadsheets, pandas, or R.
• Machine-learning training datasets.
• Bulk imports into web applications and e-commerce platforms.

Compatibility

Every spreadsheet, database, and programming language handles CSV, and browsers or text editors open it as plain text. The catch is dialect drift: delimiter, encoding, and quoting choices differ enough that robust importers always offer manual overrides.