Set .xlsx as the default format when extracting data from Anaplan

Set .xlsx as the default format when extracting data from Anaplan

It is great that now we are able to export data in xlsx format. Thanks Anaplan Team! It would be helpful to have xlsx as the default format when manually exporting data from the system. Current default format is .xls.

Super Contributor
Status changed to: Your support is needed
Occasional Contributor

Hey Anaplan Dev Team,

Max pointed out a very useful platform change that is super-easy to be applied. Reshuffling the list of availale imports to move xlsx formats up is probably not more than few minutes of work for the dev. 


When would we expect that to be done?





Our users find it extremely annoying that the format defaults to .xls and has to be changed manually every time data are exported.

An alternate suggestion would be to allow the default format to be set by Customer.

Occasional Contributor

Bumping this idea up


It's probably one change in coding for IT guys in the JS script generating a list of dropdown elements:


Dojo.js -> _createLayoutTab

changing order of the table elements there probably would do the magic.


Many users find this XLS as default choice in export file type list quite unpleasant, so this small thing would make their life much easier



Nicolas Cadier
Certified Master Anaplanner

This would be a nice change, more user friendly and easy to implement!

New Contributor

We had the default export format modified from .xls to .csv on our models (an incident is in progress)...

Case Number: 00419405

Case Subject: Anaplan : Export on .csv by default

So it seems that it is possible to have the default format changed and instead request the .xlsx format?
It would be good to have the admin option to change this setting for a model...


Certified Master Anaplanner

Yes, Please allow either Workspace admin or each user to change their desired file type in Export Format. Received complain about switching to .csv format. It would take additional steps every time user will choose to export files in xlsx. Majority of my model users preferred (and using) "xlsx" or "xls".