I have list called "Employee" with code like "0000007". I need to import this employee details to my list. But when i convert my input file from excel to CSV, the code column getting convereted as number (like only '7').
Can someone help me to create the list with text formatted code.
I tried this way adding single quote in front of the code & imported the same to Anaplan. The issue is single quote appearing in Anaplan as well. Is there any other way where i can upload the data without single quote.
The key is to ensure the value is a text string (in excel) prior to saving. If the leading zeros are in the CSV file, they will get loaded into Anaplan correctly... try opening the CSV file with a text editor (I use Notepad++)... you should see the zeros in the text editor. You shouldn't see the single quote.
The single quote, for me, works every time, but I only use it if I have to. When opening the file in Excel (if you want to view it) open the file in a way that doesn't cause Excel to convert the column to numbers (and remove the leading zeros). For example, open the file using: Data > From CSV > Do Not Detect Data Type. There are other ways...
When you manipulate or open a .csv file the leading zero's get truncated. If you need to manipulate the data, you can perform a text import of the .csv file into excel and format the columns to preserve the leading zeros. I've attached some screenshots in a word document as an example. Hope this helps.