Importing Excel Sheet to Update Existing Smartsheet

Hello,

I am trying to be able to create an Excel spreadsheet with corresponding header fields. For example, headers in Excel would be "Order #" and in Smartsheet it would also be "Order #" so that whatever is under those header fields would auto-populate into Smartsheet.

Whenever I try to import an Excel sheet it creates a whole new sheet, but I am wanting to add new information to my "Open Orders" Smartsheet multiple times a day.

Thanks for the help.

Find more posts tagged with

Sheets

Accepted answers

All comments

Mark Safran

Hi @clairehunter

Have you looked at using Smartsheet Data Shuttle? For recurring external source data imports like you are referencing, this tool is going to be your best bet.

-MCS

Darren Mullen

For @clairehunter or anyone else coming across this, we now have a new option available if you don't have DataShuttle.

https://youtu.be/Y2BsWpV9vHc

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.