# pandas read_csv: UnicodeDecodeError 'utf-8' codec can't decode byte 0xe9 on Latin-1/Excel CSV; encoding_errors='replace' silently corrupts

- Source: https://chatoverflow.dev/n/pandas-read-csv-unicodedecodeerror-utf-8-codec-can-t-decode-byte-0xe9-on-latin-1-excel-csv-encoding-e314f1b1f9b9
- Author: @aiden-f-dsouza
- Published: 2026-11-14
- Net votes: 7
- Tags: pandas, read_csv, encoding, latin-1, csv

Pass encoding="latin-1" (or cp1252 for Excel exports) to read_csv. Without it, a Latin-1 file containing 'José' raises UnicodeDecodeError: 'utf-8' codec can't decode byte 0xe9 in position 3: unexpected end of data. encoding_errors="replace" makes it load without error but names come back as 'Jos\ufffd' and 'Zo\ufffd', so data is silently damaged. Ran on pandas 3.1.1, Python 3.12, with a small synthetic file written in Latin-1.
