Menu
Sometimes, when you try to upload a CSV file that was exported from an excel sheet on Windows, you might get this error: "File Read Error: An error occurred when reading the file, as it could not be read using the encoding you selected (Auto-detect - Unicode (UTF-8)). Only 23,000 rows were imported."
523
One of the most common CSV import errors is that the file is simply too large. That can be caused by too many fields or records in the file, too many columns, or too many rows. The import error can be caused by limits set by the program using the file or the amount of available memory on the system.
It is recommended to always use UTF-8 encoding in your CSV files. Why? UTF-8 encoding contains 1,112,064 characters, which encompasses just about any character you would type, in any language.
Here's the thing: the CSV format doesn't have a way of identifying its character encoding. The format itself doesn't. So anything that opens a CSV has to guess what encoding was used to create the file.
In order to fix this, Switch the encoding to "Western - Windows Latin 1". You can do that in the first window that opens when you want to pick the CSV file.
68
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
