Recent Data Export Format Change

Hello,

The data exported to excel from a module has recently had formatting changes. As of today, when I export a module from a dashboard it appears to no longer have formating. I think this could possibly be related to the maintenance performed over the weekend (05/14/22). Has anyone else noticed this? Will the formatting be brought back?

Accepted answers

luke_e

The recent release changed the file-type sort order on the Export process.

Screen Shot 2022-05-17 at 10.35.14 am.png

I think .xls was originally the default.. now it's .csv (which doesn't have formatting). You'd need to select .xls/.xlsx from the drop-down to get a formatted worksheet. Have already had a few users commenting on it.

rohan.suratwale

Hello @MGerke ,

Yes recently Anaplan has introduced multiple exports formats for Model builder as well as users,

by default you might have exported the data into the CSV format that might have disrupted the formatting on the data columns.
--ROHAN

All comments

luke_e

The recent release changed the file-type sort order on the Export process.

Screen Shot 2022-05-17 at 10.35.14 am.png

rohan.suratwale

Hello @MGerke ,

Yes recently Anaplan has introduced multiple exports formats for Model builder as well as users,

by default you might have exported the data into the CSV format that might have disrupted the formatting on the data columns.
--ROHAN

MGerke

Thank you, that is very helpful!

GTMGray

Is there a way the default can be changed back to xls, as opposed to being csv?

Jsalvata

Agreed, it would be great to have Administrative functionality or a Model specific option to set the default export format. The majority of my business users prefer formatted excel exports over the .csv.

@VickiA looping you in, maybe we can get this on Anaplan's radar?

philip.austin

Hi @MGerke , @Jsalvata and @BhardwajS . This idea is set to solved since it was answered that users can override the new default back to .xls (the old default) if they want to do so. Some customers have exressed the same thoughts as your latest comments, that you would like the default changed back or that there be an option for the default. Since your initial idea request is set to Solved I have created a new one to reflect this latest desire. If this is still of interest to you, please vote for it? Here.

Quick Links

Can you help?

Unanswered questions

OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385