Why Accented Characters May Display Improperly
GiveCampus creates CSV files that are compliant with the UTF-8 standard. We do this to ensure that it works well for our partners using different operating systems and different software packages to process these CSV files.
If you use Microsoft Excel to open the .CSV files, everything works fine when the file contains just English characters. However, you may run into an issue when your CSV file also contains non-English characters (such as é, ç, ü, etc):
Excel can display UTF-8 characters correctly, but opening a CSV directly may use the wrong encoding. Importing the file and selecting UTF-8 avoids this problem.
How to Resolve Improperly Displaying Accented Characters
To resolve this issue, please do the following after downloading the CSV file from GiveCampus.
On a Mac:
Use the "Numbers" application instead of Excel.
On a Windows machine:
Import the CSV in Excel
Use Data → From Text/CSV (or the Text Import Wizard in older Excel versions). Select UTF-8 / 65001 as the file origin and comma as the delimiter, then load the data. Keep the original UTF-8 CSV; converting it to ANSI can lose characters.
- On a Windows computer, click "File > New" in Excel.
- Click "Data" tab.
- Then click "From Text" option.
- Excel will display "Text Import Wizard".
- In step-1 of this wizard:
- Select "Delimited" radiobutton.
- In "File origin" field - select "65001 : Unicode (UTF-8)".
- Click "Next >" button.
- In step-2 of this wizard:
- Select "Comma" checkbox.
- Click "Finish" button.
- In the dialog window that appears - click "OK" button.
- Excel will display your CSV file - including non-English characters - properly.
Comments
0 comments
Article is closed for comments.