Maintain Formatting in Data Export

kylavalley

When exporting data from Anaplan to Excel, it would be great to have the option to maintain certain formatting options such as wrapped text and conditional formatting. 

Miran

Status changed to: New

CWREN

another thread with the same thing: https://community.anaplan.com/t5/Idea-Exchange/Option-to-export-conditional-formatting-in-export-to-xls/idc-p/122060#M9235

 

 

There is a definite need to be able to export conditional formatting from both NUX and standard reports and exporting. 

 

At the moment we are having to replicate formatting in Excel which is time consuming. It also steers users and stakeholders to just export the raw data in Excel and continue to format and produce reports in Excel when they could be done in excel and exported where necessary

zbunting

I also agree that this should be on the roadmap.

VeronicaP

It will be kept under consideration for the roadmap of Anaplan for Microsoft 365 on Excel.

ExcelGunnar

Agree with original ask. I think having the formats available in MS 365 Add in doesn't address the actual issue.

Vamsi_Kaki

If data exported with conditional formatting from Anaplan to Excel, cells show CF but what if user wants to apply CF with another conditions in Excel? How can CF be differentiated from Original file and later applied conditions?