Hi Community,
I would like to ask this issue. I have never encountered this before so I hope you can provide me some insight.
For example:
This is the view of the file I am going to Import ini Excel mode(just a sample).
I do the usual Save as "CSV format". I open the CSV format and everything is fine. I proceeded in importing it to Anaplan and this is what I got:
I only have 1 column present. I tried to recreate the file over and over again and I still got the same issue.
Is this an issue in Anaplan or Excel. I just finish loading the other csv files that I have and there seem to be no problem just this one.
Appreciate the help.
Regards,
Solved! Go to Solution.
Check your delimiters if it is comma, pipe or anything else. Looks like Delimiter issue as @nathan_rudman highlighted
Misbah
As all the bosses mention it could be a number of different issues...
One option you could try:
It is also possible that text encoding type is not the correct format sometimes selecting UTF8 works for me when the file is saved as a .csv utf8 format.
Alternatively you could try to save it as .txt file and upload it this way.
Thanks,
Usman