AWR reports and exports use the UTF-8 encoding standard by design. This ensures special characters in keywords or URLs can be parsed correctly by third party software solutions you may be using for viewing or processing the data from these files. 

However, opening csv exports with Excel or other data viewers / editors sometimes results in special characters being displayed in a weird way. This happens because files and editors don't play nice when the character encoding is different. 

Here are some tips to resolve the issue: 

  • use Notepad or Notepad ++ to view or edit the data 
  • when opening the csv export with another software, make sure you select UTF-8 encoding. 

For example, with Excel you can use the following steps

  • Open Excel
  • Import the data using Data Import External Data Import Data
  • Select the file type of "csv" and browse to your file
  • Change the File_Origin in the import wizard to "65001: Unicode (UTF-8)"
  • Change the Delimiter to comma
  • Select where to import to and Finish

The special characters in keywords and URLs should be displayed correctly. 

If you are still experiencing problems, please contact our support team at help@advancedwebranking.com. 

Did this answer your question?