Is there a way to automatically update an excel file from smartsheet
I am trying to display turn around time but we have so much data and the smartsheet charts aren't advanced enough to show what we need. I would like to use excel to graph the data but the smartsheet is updated daily and manually exporting to excel would be such a hassle. Is there any way I can make it export the data from smartsheet to the excel file weekly? I do not want to create a new excel file I want to continuously update one file using smartsheet data.
Answers
-
There is the Data Shuttle feature. It's located under Connections at the top of your sheets.
It is a paid feature how ever so please keep that in mind.
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
-
you can build a workflow with Microsoft Power Automate with an connector to Smartsheet. Alternatively a direct data connection between Smartsheet and Excel, but this way will only work, when you open the file.
-
I've looked into data shuttle and I run into this issue
How can I make it go to a local excel file?
-
Do you have a OneDrive or SharePoint storage space that you are leveraging ? You could put the file out there and then use the OneDrive client to sync the folder locally to your machine.
This way you'd still have it local but it would have a backed up cloud version that Data Shuttle may be able to access.
-
You can publish the sheet as Read Only - HTML then use the published URL to pull in to an Excel file using the "Get Data → From Other Sources → From Web". Then in the data tab you can use the "Refresh All" dropdown to open up the "Connection Properties". From there you can set up custom refresh rates to include on open and even time based for when the file is not open. The catches here are that the sheet does have to be published, and the query will not pull any hidden columns or rows that have been filtered out.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives