Export multiple Smartsheet Reports to One Excel Workbook

Title says all.
I'm trying to clean up stale data out of Smartsheets and store offline as the data is no longer relevant for stakeholders, however I want to keep a record of said data, just not in Smartsheets.
This is because I need to clean up Reference Sheet connections before my two master sheets have too many connections.
Right now, I have to manually do each report, one by one, to an excel doc export. Once all have been exported, I have to open and then copy from one workbook to another.
I'd like to be select all the valid reports, then export to one Excel workbook, and then rearrange the workbooks as necessary after export.
Any workarounds or features I am overlooking?
Best Answers
-
Hi @dhall
Are those reports organized in folders? You can try exporting the folder (or the entire workspace), though this comes with a 10,000 row limit across single export. You can also try requesting backup of your workspace and work through the different files using some Excel Macro.
Let me know if that helps or if you need any additional help fixing this.
Thanks
Amit
Best Regards
Amit Wadhwani, Smartsheet Community Champion
Smartsheet CoE, Ignatiuz, Inc., Exton, PA
Did this answer help you? Show some love by marking this answer as "Insightful 💡" or "Awesome ❤️" and "Vote Up ⬆️"https://www.linkedin.com/in/amitinddr/ -
Okay, so it worked exactly how I needed it to!
I just created a subfolder and moved the necessary reports and sheets into the folder. Once I confirmed all the required reports and sheets were in the new subfolder, I checked the box next to it and then chose "Export to Excel" as an action.
It created a .xlsx file with the name of the subfolder I created for this.
Only thing I needed to do was delete any comment pages that weren't needed and move the sheets around to the correct order. Took me 3 minutes instead of 15! Marking best answer, thanks again @Amit Wadhwani
Answers
-
Hi @dhall
Are those reports organized in folders? You can try exporting the folder (or the entire workspace), though this comes with a 10,000 row limit across single export. You can also try requesting backup of your workspace and work through the different files using some Excel Macro.
Let me know if that helps or if you need any additional help fixing this.
Thanks
Amit
Best Regards
Amit Wadhwani, Smartsheet Community Champion
Smartsheet CoE, Ignatiuz, Inc., Exton, PA
Did this answer help you? Show some love by marking this answer as "Insightful 💡" or "Awesome ❤️" and "Vote Up ⬆️"https://www.linkedin.com/in/amitinddr/ -
Interesting, I didn't know that selecting a folder would allow the option to export.
I'll try this out, I'll have to remove certain sheets/dashboards I don't care for to be in export.
After I'll try, I'll update the post with my findings. Thanks for sharing, @Amit Wadhwani!
-
Okay, so it worked exactly how I needed it to!
I just created a subfolder and moved the necessary reports and sheets into the folder. Once I confirmed all the required reports and sheets were in the new subfolder, I checked the box next to it and then chose "Export to Excel" as an action.
It created a .xlsx file with the name of the subfolder I created for this.
Only thing I needed to do was delete any comment pages that weren't needed and move the sheets around to the correct order. Took me 3 minutes instead of 15! Marking best answer, thanks again @Amit Wadhwani
-
Hi can you do this via dashboard?
-
Hi @mpmurillo
I hope you're well and safe!
Unfortunately, it's not possible now, but it's an excellent idea!
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 433 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 506 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives