Clubbing multiple excel exports

Hello All,

We have a requirement from user where they want to club multiple excel exports from Anaplan as a single file (meaning each sheet in excel having the respective export from Anaplan). Is this possible? IF yes, can you suggest how to proceed.

Report 1 -> Sheet1 of excel

Report 2 -> Sheet2 of (of same excel)..and so on...

Accepted answers

All comments

AjayM

Hi Harshitha,

I came across similar requirement but no, it is not possible to club reports into a single excel file from within Anaplan. As we know, each export action generates a file for itself and there is no work around to club these reports into multiple worksheets within same excel file.

Joining you, keen to know if there is any workaround to achieve this, from other community experts.

Cheers!

andrewtye

Hi @harshitha.narayan@sony.com

One question would be - why the requirement? If it's to use the data for packs, etc have you looked at Management Reporting to cover off the ask?

But have you considered the use of the excel add-in or O365 app which would allow users to have multiple tabs that are refreshed from the model.

Andrew

harshitha.narayan

Hello Andrew,

Thank you for the reply! The model that we are using is currently a stand alone system and not be integrated with any other tool. I am not sure on how to incorporate the excel add-in here.

It would be great if you can guide us on this.

Thank you,

Harshitha N.

Quick Links

Can you help?

Unanswered questions

import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
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.…