This information is for Club to explain how to open CSV files (exported via Reports) that contain Non Latin Characters.
The following steps applies to Member Associations using the following languages:
- Arabic (عربي)
- Azerbaijani (Azərbaycanca)
- Chinese (中文)
- Russian (Русский)
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’