Mallcomm creates CSV files that are compliant with the UTF-8 standard. We do this to ensure that it works well for our customers using different operating systems and different software packages to process these CSV files, and to ensure that the processed CSV files can be imported back into Mallcomm.
If you use Microsoft Excel to open the CSV files, everything works fine when the file contains just English characters. However, you may run into an issue when your CSV file also contains non-English characters (such as é, ç, ü, etc):
- Microsoft Excel is unable to properly display UTF-8 compliant CSV files when they contain non-English characters.
To resolve this issue, please do the following after saving the CSV file from Mallcomm.
Method 1
- On a Windows computer, open the CSV file using Notepad.
- You may need to change the setting highlighted below to make it visible
- Click "File > Save As".
- Make sure you set the "Save as type" to All files and check it has just one .csv on the end of the file. I have highlighted in the image below where to check this.
- In the dialog window that appears - select "ANSI" from the "Encoding" field. Then click "Save".
- Open this new CSV file using Excel - your non-English characters should be displayed properly.
Method 2
- On a Windows computer, click "File > New" in Excel.
- Click on the "Data" tab.
- Then click the "From Text" option. Select the CSV you file you downloaded from Mallcomm.
- Excel will display "Text Import Wizard".
- In step-1 of this wizard:
- Select the "Delimited" radio button option.
- In "File origin" field - select "65001 : Unicode (UTF-8)".
- Click "Next >" button.
- In step-2 of this wizard:
- Select "Comma" checkbox.
- Click "Finish" button.
- In the dialog window that appears - click "OK" button.
- Excel will display your CSV file - including non-English characters - properly.