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’