Issue with Ascii characters in Anaplan

I’ve encountered an issue while importing data into Anaplan where certain special characters, specifically ASCII characters like ü, ä did not show properly, it showed as question mark Instead of importing these characters correctly, the data gets corrupted or replaced with incorrect symbols. As shown below,

Although it was corrected as soon as I imported the same file again with same process as shown below,

I was not able to understand the issue hence I would appreciate any insights on why did this happened with ASCII characters during the file import process.

Accepted answers

seymatas1

Hi @Prajjwal88,

Try using CSV UTF-8 instead of regular csv format.

I hope this helps.

Seyma Tas 🌷🙂

All comments

seymatas1

Hi @Prajjwal88,

Try using CSV UTF-8 instead of regular csv format.

I hope this helps.

Seyma Tas 🌷🙂

PulkitChawla

@Prajjwal88 - While Importing into Anaplan, please make sure that Data Import Source should be set to UTF-8 otherwise you won't be able to see these special characters after loading into Anaplan.

meghraj769

Sorry for late reply, but you can just try using CSV UTF-8 instead of regular csv format

Quick Links

Can you help?

Unanswered questions

Sorting General List
Hi, I wonder if there's a way I can sort my general list alphabetically. The list is used as a drop down menu in a line item module and I want the drop down menu to be easy to navigate. I've already tried the Order List action. I already have a module with a text-formatted line item based on that list. But when I try to…
Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…