All Collections
Advertising Center: Amazon PPC Software
Why are foreign characters not shown properly in my Advertising Center's Keyword CSV download?
Why are foreign characters not shown properly in my Advertising Center's Keyword CSV download?

An explanation on why & how to correct your initial CSV download when working with Advertising Center's Keywords and/or Search Terms reports

Seller Labs avatar
Written by Seller Labs
Updated over a week ago

The Advertising Center creates CSV files that are compliant with the UTF-8 standard. We do this to ensure that the downloads work well for our customers using different operating systems and different software packages to process CSV files.
​
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 the Advertising Center.

For Windows operating system:

Method 1

  • On a Windows computer, open the CSV file using Notepad.

  • Click "File > Save As".

  • In the dialog window that appears - select "ANSI" from the "Encoding" field.  Then, click "Save".

  • That's all! 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 "Data" tab.

  • Then click "From Text" option. Select the CSV you file you saved from Advertising Center.

  • Excel will display "Text Import Wizard".

  • In step-1 of this wizard:

  • Select "Delimited" radio button.

  • 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.

For Mac operating system:

  • Use the "Numbers" application instead of Excel.

_______________

Need help? Our support team is happy to assist you! 🙂

  • Connect via the in-app chat icon, located in the bottom-right of your screen while logged into any of our apps

  • Search the Knowledge Base to see if your question has already been answered

  • Make an appointment with us for more direct support

Did this answer your question?