This information is for Club to explain how to open CSV files (exported via Reports) that contain Non-Latin or special characters.
The following steps applies to Member Associations using the following languages:
- Arabic (عربي)
- Azerbaijani (Azərbaycanca)
- Chinese (中文)
- Russian (Русский)
- French (Français)
1. Download and save CSV from Reports
2. Open a new Excel file
3. Select 'Data' > 'Get External Data' > 'Import Text File...'
4. Select file
5. Select File origin Unicode (UTF-8)
6. Continue as normal
Once you have selected the File origin, continue from this point as normal.
Select 'Delimited', then click 'Next'
Delimiters - select 'Comma', then click 'Next'
Column data format - select 'General', then click 'Finish'
Select 'Existing Sheet', then click ‘OK’