Improve time period imports for CSVs

The standard excel format for Month-Year is MMM-YY.

I.e. if a user types Jan 20, excel will convert this to a numeric value and display Jan-20.

Anaplan does not recognise this as a valid time period when importing.

As this is the default excel format, it would be great if Anaplan could recongise this correctly. Rather than having to edit the format for each import file.

6 votes

New · Last Updated


  • Whilst you can define this manually as "mmm-yy" in the "Custom fixed-position pattern", I agree it would be useful if Anaplan auto recognised this common format.

  • Status changed to: New
  • This is also true in any text formatted and various delimited files.

    I made this suggestions several days before yourself.


Get Started with Idea Exchange

See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!