Exporting data to different tabs in excel

I'd looking for something that I think I've seen in other systems referred to as "explode" functionality, which would effectively create a new excel tab for every list item and export to that tab. So, if I have a department list (for example), I'd like to export data to excel and have a tab show up with the data for each of the departments. This isn't the exact example I'm looking for (in fact, the example I'm looking for has about 100 items in the list), but this should give you a sense of what I'm looking for.

Thanks,

Josh

Accepted answers

All comments

rob_marshall

@jbrass ,

Not sure this is exactly what you are looking for, but when you export data, you can set the action to export all members of the list.

Which gives you this...but it does not rename the tabs

This is about the best we can do right now.

Thanks,

Rob

jbrass

Thanks Rob, that is helpful, and I somehow never noticed that feature before. This doesn't exactly solve what I need though. I have an L1 list and an L2 list. If L1 was customer and L2 was product, then I'm looking to export the data related to the 1st L1 item to excel, and then have the same happen in the 2nd tab but for the 2nd L1 item. Basically, if I have a dashboard which syncs on the L1, but shows both the L1 and L2 levels, then I'm looking for an excel tab that mimics what happens every time I select a new L1 item. Does that make sense?

Thanks,

Josh

neeti

Is there a way to rename the tabs yet?

Quick Links

Can you help?

Unanswered questions

Prevent end users deleting a list item when using Worksheet in UX.
Hi, I have a worksheet for end users to enter new hires into, for which the list item which persist across versions. I am having an issue where the end user can delete a list item using the grid functionality because the Current Version value is blank, but I want to prevent them deleting them (as data will be lost from…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
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…