Level 2 Sprint 2 - Dem01 data uploading wrong information

Hi All - I am trying to upload the Volume+Growth+Rates.csv https://anaplanenablement.s3.amazonaws.com/Files/Level2_onDemand/Volume+Growth+Rates.csv . The first time I tried, I got the error.

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

Data in sheet

Added information

Comments

Misbah

@sunilramakumar

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.

You should be able to see the results as expected

Hope that helps

Misbah

sunilramakumar

Hi Misbah - Thank you for your inputs. But I am getting the error:

Option 1:

Is this something related to the date format that I have selected ? ( There seems to be no year in the file)

Option 2 :

sunilramakumar

Checked with mentor and he advised changing the date format to Y-M and it uploaded correctly. Thank you all for the help

rachelwatsky

Do you know why the Y-M format worked? I was stuck on the same issue forever

sunilramakumar

Hi Rachel - I am still a novice, but my understanding is that the Y-M maps to the source and the input file has that format

hpatel

One thing to do before importing such files is to open it in notepad and check the Date format.

For this file, you will see it has 20-Jan, 20-Feb, etc. (Y-M) format. Hence if you select Y-M when uploading this file, it will be uploaded successfully.

Thanks!

vivekpratap2015

HI @sunilramakumar

Can you please explain the way to solve the date format issue , as even i am stuck at this point.

hpatel

Hi Vivek,

Please check my comment above. Open the file you're trying to load in notepad. Check the format and select that format when you go through the upload exercise.

For the Dem01 data, it should be Y-M format. Hope this helps.

Thanks,
Hiren

Cynthia1

Hi all,

I am encountering the same problem here and hope someone could help me out. I have changed the format in excel file as below and then save it to csv before i import it.

Screenshot 2021-01-15 at 10.40.55 AM.png

This is what i get:

Screenshot 2021-01-15 at 10.42.00 AM.png

I couldn't get the Y-M format:

Screenshot 2021-01-15 at 10.42.27 AM.png

May I know what was not right?

Appreciate any advices. Thank you.

BR - Cynthia

hpatel

Hi Cynthia,

Please check my comment above. Open the file you're trying to load in notepad. Check the format and select that format when you go through the upload exercise.

For the Dem01 data, it should be Y-M format.

Once you change the csv file in any format, save it and open it in notepad to ensure it retains the format that you wanted to use.

Hope this helps.

Quick Links

Recent release news

June 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our June 2025 official release notes. The information below offers supplemental information to that post. Security and administration New 'Application Owner' security role Tenant administrations can assign the Application Owner role to users in their tenant.…
Register for our July 30 platform release webinar!
Anaplan's next quarterly platform release webinar will be held July 30, 2025 at 8 a.m. Pacific Time. During this session, we will explore the latest features so you can optimize your Anaplan experience. Our expert-led session will equip you with a practical guide and live demonstrations to help you get the most out of new…