Data shuttle - uploading data from Excel sheet
Hi everyone,
I am looking for a workflow, that copies a data from excel file into Smartsheet (which also captures data from the form created within the sheet) without having the team members to access Smartsheet. The reason for considering this upload is, sometimes there will be a bulk data which just need to be copied into the forms which is time consuming, so in order to overcome this issue, I am looking for the ways to do this.
Can I use data shuttle to do this? or can I link the common one-drive file to Smartsheet?
Please provide suggestion! Thanks in advance 🤗.
Answers
-
You can use the integration between Excel and Smartsheet to automatically load data from Excel into Smartsheet without requiring team members to access Smartsheet. This can be done using tools like Smartsheet Data Shuttle or using scripts and macros in Excel that automatically update data in Smartsheet from Excel. Regarding OneDrive, you can use the external links feature in Smartsheet to access data stored in a shared OneDrive file. Choose the option that best suits your needs and situation.
-
Hi @BraylenStanton , thanks for responding. I have data shuttle but the unique identifier column in Smartsheet is a auto numbered column and the workflow is failing to run. Is it required to have a unique identification column for this upload workflow (when the data is copied from excel to Smartsheet automatically?)
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 377 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 33 Webinars
- 7.3K Forum Archives