CSV & Delimited Files

CSV looks simple because it is plain text, but real files vary in delimiter, quote rules, character encoding, line endings, headers, and the way empty values are represented. A comma inside an address, a semicolon used as the actual separator, or a spreadsheet program guessing a date can change the structure of the data without an obvious warning.

When a CSV opens incorrectly, inspect the delimiter and encoding before editing the content. Quoted fields should remain intact, and text identifiers such as postal codes or account numbers should not be automatically converted to numbers. If you are preparing a file for import into another service, match that service’s expected separator, header names, and encoding rather than relying on whatever your desktop spreadsheet app chooses by default.

Practical tips

• Confirm the delimiter before splitting or importing columns.
• Use UTF-8 when the file contains accented or non-Latin characters unless a system requires otherwise.
• Preserve leading zeros in IDs, ZIP codes, and product codes.
• Check quoted fields that contain commas, tabs, or line breaks.
• Validate the number of columns on several rows before importing a large file.