Sequel pro - Import CSV file: Encoding error

Question

Sometimes, when you try to download a CSV file that was exported from an excel worksheet to Windows, you may get this error: "Error reading file: an error occurred while reading the file, because it could not be read using the encoding of your choice (Auto-detect - Unicode (UTF-8)). Only 23,000 rows were imported. "

Answer 1

To fix this, switch the encoding to "Western - Windows Latin 1". You can do this in the first window that opens when you want to select the CSV file.