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 🤗.

Find more posts tagged with

Accepted answers

All comments

BraylenStanton

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.

Mounika

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?)

i018485

@BraylenStanton do you anything about data shuttle upload workflow that runs, but nothing happens? I am trying to upload from an excel file in SharePoint. The source and the destination files are both visible. I run it manually, it says "running", but no feedback, no messages, no way to see what happened, like a real log. The mapping is all done. Thanks!!!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.