So I changed the format on the excel to date 03/04/12 and tried again and it uploaded. But the values are showing up as below, which appears no relation to the data in the sheet. Can you please advise what I am doing wrong
I would recommend not to change the format into dates.Here is what you can do
Step 1: Without opening the Input .csv file upload the file into Anaplan It so happens when you open csv files it changes the period format. But if you wish to open the file before loading it, it may look like this
You can try change the format in your source file . Right Click on any Cell and click on Format Cells and choose the option of "mmm-yy" Once that is done save the file.
Alternatively if you want to save yourself some time just download it again from the exam portal and use that without opening
Step 2: Keep the time mapping as Period of M-Y on Anaplan.