Character encoding and Blender

During a Blender load, you may run into issues when Employee Names contain special characters (such as accented letters). The characters on these records will return unrecognisable - usually displayed as a question mark in a triangular box:

 mceclip0.png

This is because by default, Excel exports csv files using old encoding called Windows-1252.

To get around this issue, you can Save As the csv file with the encoding type 'UTF-8':

mceclip1.png

However, this may not be possible in older versions of Excel where UTF-8 is not a default option in the dropdown list. If this is the case, then you will need to follow these steps:

  • Click on the Save As button
  • To the left of the Save button, you will see Tools - click this and choose Web Options:

mceclip2.png

  • Select the Encoding tab and save the document as Unicode (UTF-8):

mceclip3.png

Once this encoding has been selected, the Blender load will recognise the special characters, and they will appear as expected.

Have more questions? Submit a request

Comments