This information is for Member Associations to explain how to open CSV files (exported via Reports) that contain Non Latin Characters.



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’