nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Exporting into multiple files/tabs

CommunityMember113484

Hi,

I have a module that is dimensioned by product. I would like to export this module for each product in a single excel workbook, with each product on a new tab. Is this possible?

Thanks

Accepted answers

MagaliP

You can use the multi-sheet connection functionality in the Excel Add-in (it was released in 3.4 and is also available in 4.0)

All comments

MagaliP

You can use the multi-sheet connection functionality in the Excel Add-in (it was released in 3.4 and is also available in 4.0)

ChrisAHeathcote

@CommunityMember113484

Sadly I do not think this is possible via the UX or modelling environment.

However, I would explore using the add ins for Excel where you can create a dynamic link into your model and have the Excel update directly within Excel.

ashish.banka

@CommunityMember113484 While exporting, Pivot the product dimension into Pages. Now you can use Export>Grid Layout option and select "All Pages" radio button to export all the products data in single workbook with each product in separate tabs.

Screen Shot 2020-10-20 at 8.44.52 PM.png

Hope this helps

CommunityMember113484

Hi, Thanks for this - I've just downloaded the addin and I can only see it by a single product (as in the model builder view), but how do I get a new product per tab? Thanks

Quick Links

Can you help?

Unanswered questions

Near-Real-Time Anaplan → Claude MCP: Any Faster Than Bulk Export + MySQL?
We're looking to feed live or near-live Anaplan data into Claude through MCP, but our current approach — exporting CSV files via the Anaplan Bulk Export API, loading them into MySQL, and querying from there — has a significant lag (hour-long turnaround). Curious if anyone has found a faster path, whether that's through the…
Anaplan Analyst performance on large, sparse models
Has anyone tested Analyst’s response quality/speed on large, sparse models (think 10+ dimensions, millions of line items)? Wondering if there’s a practical ceiling before it starts timing out.
Anaplan ⇄ Google Sheets pivot tool — feedback welcome
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…