You can import special characters into line items, lists, and modules.

Consider character encoding when you import special characters, such as characters from non-Roman alphabets, into Anaplan.

Note: You can import special characters into Anaplan as data. However, try to avoid special characters in list item names, or other values used as mappings in an import. This can result in errors when you import.

Anaplan encodes TXT exports as UTF-8. As such, if you plan to export data from Anaplan as a TXT file, encode your import files as UTF-8 to reduce the risk of any errors. Additionally, UTF-8 encoding reduces data upload times and does not restrict the potential range of Unicode characters you can import. However, there are some Unicode considerations you should remember when you import data.

Imports from other systems

If your import file originates in Excel, save your Excel spreadsheet as unicode text. This encodes your file as the little-endian (LE) variant of UTF-16. When you import your data into Anaplan, ensure you select UTF-16 LE from Text Encoding in the File Options dialog.

If you want or need to use the big-endian (BE) variant of UTF-16, save your import file as UTF-16 BE and select UTF-16 BE from Text Encoding in the File Options dialog. All applications, systems, or databases that use the data you import should use the same variants of UTF-16. 


We may update our documentation occasionally, but will only do so in a way that does not negatively affect the features and functionality of the Anaplan service.