CSV encoding defines how characters are stored inside a CSV file. “CSV” describes the rows and columns; “CSV UTF-8” means those characters are encoded as UTF-8. A file can be a CSV regardless of which character encoding it uses.

If the wrong encoding is used, names, accents, currencies, and symbols can break. For example, é can become é, and company names can become unreadable.

Common CSV encodings

The most common encodings are:

  • UTF-8: the default for modern CSV files
  • UTF-8 with BOM: often used by Excel to detect UTF-8
  • ISO-8859-1: common in older Western European exports
  • Windows-1252: common in older Microsoft exports

⚠️ Encoding problems are data quality problems

If names or addresses break during import, deduplication and enrichment can fail later. Fix encoding before cleaning or matching records.

Signs of a CSV encoding problem

You might have an encoding issue when you see:

  • Broken accents, such as François
  • Question marks inside names
  • Strange symbols in addresses
  • Currency symbols replaced by boxes
  • Columns that import correctly but values look corrupted

Encoding is different from a CSV delimiter. Encoding controls characters. Delimiters control columns.

How to avoid CSV encoding issues

Choose UTF-8 when you export a CSV file, especially if names or addresses contain accents or other non-English characters. For a whole worksheet, the Excel-to-CSV guide shows where to select CSV UTF-8 when available. If a file displays François instead of François, check the encoding used to open it before changing the text itself. If the characters have already been replaced with ?, reopen the original export with the right encoding rather than editing the damaged copy.

When you save an Excel sheet as CSV, choose its CSV UTF-8 format if available. Reopen the resulting file and inspect a few names, currency symbols, and column headers before importing it elsewhere.

For a delimited text export, the TXT-to-CSV workflow shows how to choose the source encoding before exporting UTF-8. Check accented values in the import preview so an encoding mistake does not carry into the new file.

Datablist can open large CSV files in the browser and helps you inspect values before you run data cleaning, deduplication, or enrichment.

Learn more about the CSV format in What does CSV stand for? and What are CSV headers?.