Any files which contain either Logographic characters (such as Japanese) or Cyrillic characters (such as Russian) need to be saved in UTF-8 format. This allows Excel to preserve the characters, which then allows for their format to be maintained when imported into the platform.
Some older versions of Excel do not have the option to save in UTF-8 format. This is important when importing leads via CSV, and importing Validation Lists on to the platform, as any special characters in the file will only be preserved in UTF-8 format. We will run through the options for older systems below.
We will outline the process for Windows users first, then Mac users.
For Office 2016:
- Click File then Save As
- In the 'Save As' window choose Browse
- In the 'Save As' dialog click the Save as type drop down
- Select the 'CSV UTF-8 (comma delimited) (*.csv)' option
- Click Save
Older versions of Excel do not have an encoding option, so the below process is required:
- Right click the file and select 'Open With Notepad'
- Click File
- Click Save As
- In the 'Save As' dialogue, click the Encoding drop down
- Select the 'UTF-8' option
- Click Save
1. Open the File with TextEdit
2. Go to File > Save As (if Save As isn't there, hold the Options key and it will appear)
3. Select UTF-8 from the dropdown. Make sure file is still .csv in the name.