Importing Excel into existing sheet

Braden Bradford
Braden Bradford ✭
edited 10/27/22 inAdd Ons and Integrations

I am looking for a way to automate an import process.

1. Can you import into an existing sheet?

2.什么我在to accomplish is, I keep an update of projects in Smartsheet but I have to manually update notes which come from a daily report I receive. Is there a way to take the daily report and merge the data from smartsheet and excel?

Thanks

· Share on Facebook Share on Twitter

Comments

  • Gwyneth C
    Gwyneth C ✭✭✭✭✭✭

    Hi Braden,

    I can answer the first question...the answer is that importing always creates anewsheet.

    More detail about importing from Excel is here:

    http://help.smartsheet.com/articles/504553-importing-files-to-create-new-sheets

    Reaching out to the community for ideas about automation (as you've done), is a great idea. Interested to hear how/whether others are solving for similar scenarios.

    · Share on Facebook Share on Twitter
  • Tony Davidson - SmartSheet Certified User 2016
    Tony Davidson - SmartSheet Certified User 2016 ✭✭✭✭✭✭

    I am not aware of a way to do that merge and would be interested to see if that's a capability.

    · Share on Facebook Share on Twitter
  • Laura
    Laura ✭✭✭✭✭✭

    Were you able to successfully merge the data from smartsheet and excel?

    Also, when you import an excel sheet into SS and then update the original excel sheet, SS will NOT update correct? Is it possible for SS to update live through an excel sheet?

    · Share on Facebook Share on Twitter
  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    If you are on an Enterprise account, data in Smartsheet can be viewed via the ODBC connection in Excel.

    https://help.smartsheet.com/articles/1910037-using-the-smartsheet-live-data-connector-enterprise-only-

    Depending on what the data is and how it is produced will determine the options for merging it. I'd need to know more to give a more valid answer.

    Is one tool being to enter the data and another to manipulate/analyze it?

    Or is the data updates done in both?

    Or is the manipulation/analysis done in both?

    罗ts of variables to play with.

    Craig

    · Share on Facebook Share on Twitter
  • Marcin P
    Marcin P ✭

    Hi,

    I have a SS with imported data from excel. I have added few columns before original data and few after.

    I have two questions:

    1. Is it possible to import data from excel into existing sheet without loosing these added columns?

    As far as I found, it's not possible, so I found a little workaround:

    2.I have cleared all basic columns (except added ones) and just copied data from excel ctrl+C and ctrl+V, but this allows us to copy no more than 500 rows at the time and all activities taken before in added columns stays as they were before. So I have to mark up all coulumns and just delete what's there.

    It's quite painful, so it could be totally wonderful if we could just import data column by column into existing sheet.

    I hope you guys at Smartsheet are working on it:)

    best regards

    Marcin

    · Share on Facebook Share on Twitter
  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    (1) No. Imports go to new sheet.

    I only see one question.

    Here's what I do:

    Case 1: Only new data (columns do not match)

    1. Import Excel (to new Sheet)
    2. Rearrange columns if necessary. For my most common Case 1, the Excel data (generated by another program), I need to rearrange two columns to get the order of 5 columns of interest to match the Sheet in Smartsheet.
    3. Select all content in the imported sheet (Copy)
    4. Paste all content to the bottom of the destination sheet.
    5. Move new rows to proper hierarchy if applicable.
    6. Delete imported sheet

    Note: If columns match one-to-one, Copy Rows or Move Rows also works.

    Case 2: Excel data is the "master", row count same

    Process is the same as Case 1, except the matching data range in the destination is deleted first.

    Case 3: Excel is the "master", row count changes

    We use AppSheet to provide the link between Excel and Smartsheet. Sync occurs at the touch of button. New rows are added to Smartsheet when needed by AppSheet. Existing rows that no longer match are maintained in Smartsheet until user decides to delete them (another AppSheet process)

    I hope this helps.

    Craig

    · Share on Facebook Share on Twitter
  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi,

    Smartsheet just released a new add-on called Data Uploader that could be an option.

    Please see the attached link/screenshot for more information.

    //www.santa-greenland.com/datauploader

    I hope this helps you!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    https://workbold.com/

    Andrée Starå| Workflow Consultant / CEO @WORK BOLD

    W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

    · Share on Facebook Share on Twitter
  • jgneely72151
    jgneely72151 ✭✭✭✭✭

    Yes, it would be great if you can append an import to an existing sheet. Please add this to your product enhancements list.

    Thanks!

    Jennifer Neely

    · Share on Facebook Share on Twitter
  • Teri Ann Oursler
    Teri Ann Oursler ✭

    Craig,

    I tried the steps you mention above and I cannot get my 1518 rows of data to copy from one SmartSheet to another. The copy does nothing. I have let it sit for 2 full minutes and never get it copied. If I select just 499 rows it work, but slowly.

    Help, I need to update the data in my Smartsheet that is linked to my reports and dashboard at least every 2 weeks.

    Thanks, Teri

    · Share on Facebook Share on Twitter
  • Gwyneth C
    Gwyneth C ✭✭✭✭✭✭

    嗨,珍妮花,

    As Andre notes, this is currently available with Data Uploader. Specifics on requirements and how it works are outlined here:

    https://help.smartsheet.com/articles/2478361-data-uploader

    If you have a moment, please do add you own use case scenario to the product enhancements list by using theSubmit Product Enhancement Requestlink here (or under Quick links).

    Thanks!

    · Share on Facebook Share on Twitter
  • MichaelTomar
    MichaelTomar ✭

    You can automate data import from CSV to Smartsheet usingSkyvia. It is a no-code data integration platform. It is a freemium product.

    · Share on Facebook Share on Twitter

Categories

@Melitta<\/a> the only way to do this is via the API. If you have Bridge then you could achieve this.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":107797,"type":"question","name":"Why is my global update to add profile data coming in blank in tests?","excerpt":"Hi all, I'm trying to make a global update to add a new profile data point (created date) to metadata and summaries. I've tried doing it with both the system created date column and a helper column replicating the created date column (read in another discussion that I should try that). Both result in an incomplete data row…","snippet":"Hi all, I'm trying to make a global update to add a new profile data point (created date) to metadata and summaries. I've tried doing it with both the system created date column…","categoryID":343,"dateInserted":"2023-07-19T14:36:17+00:00","dateUpdated":null,"dateLastComment":"2023-07-19T17:21:41+00:00","insertUserID":163671,"insertUser":{"userID":163671,"name":"warrena","title":"SVP Operations","url":"https:\/\/community.smartsheet.com\/profile\/warrena","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BwvmQS-uIbI!gk_kZ2_XMHI!WXFAoXDNJfe","dateLastActive":"2023-07-19T17:19:56+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":137019,"lastUser":{"userID":137019,"name":"Samuel Mueller","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Samuel%20Mueller","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B9G8B70WXQWC\/nKTI46EH9WQOM.jpg","dateLastActive":"2023-07-19T19:42:59+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":35,"score":null,"hot":3379568878,"url":"https:\/\/community.smartsheet.com\/discussion\/107797\/why-is-my-global-update-to-add-profile-data-coming-in-blank-in-tests","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107797\/why-is-my-global-update-to-add-profile-data-coming-in-blank-in-tests","format":"Rich","lastPost":{"discussionID":107797,"commentID":386005,"name":"Re: Why is my global update to add profile data coming in blank in tests?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/386005#Comment_386005","dateInserted":"2023-07-19T17:21:41+00:00","insertUserID":137019,"insertUser":{"userID":137019,"name":"Samuel Mueller","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Samuel%20Mueller","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B9G8B70WXQWC\/nKTI46EH9WQOM.jpg","dateLastActive":"2023-07-19T19:42:59+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/50Z2MUOUC5U8\/screenshot-2023-07-19-at-10-31-00-am.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot 2023-07-19 at 10.31.00 AM.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-19T17:17:08+00:00","dateAnswered":"2023-07-19T15:28:11+00:00","acceptedAnswers":[{"commentID":385957,"body":"

@warrena<\/a> Sometimes the test function can be a little wonky. It's hard to say for sure why its not showing up because your setup looks right. If it was me, I would apply to global update to only one project and then investigate. Just make sure when you go to the next step you only check one project to update.<\/p>"},{"commentID":385993,"body":"

@warrena<\/a> <\/p>

the screen after you do the test is this<\/p>

\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n


<\/p>

When you hit apply update it will take you to the next and final screen and there will be the option to select the projects you want to apply the update to. Select only one and hit apply. <\/p>

\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n

This is after you do the test<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":65721,"type":"question","name":"Live Data Connector to SAGE accounting","excerpt":"I was reading up on data connectors to 3rd party platforms such as Excel, Access, etc. but didn't see any information about accounting systems such as Sage or Quickbooks. Has anyone ever linked an accounting systems to Smartsheet? I am assuming it is possible, but I want to gather other's experiences if they have. Thanks!","snippet":"I was reading up on data connectors to 3rd party platforms such as Excel, Access, etc. but didn't see any information about accounting systems such as Sage or Quickbooks. Has…","categoryID":343,"dateInserted":"2020-02-03T18:53:46+00:00","dateUpdated":"2022-06-14T14:36:40+00:00","dateLastComment":"2023-07-17T15:46:19+00:00","insertUserID":35371,"insertUser":{"userID":35371,"name":"tye.gardner35371","url":"https:\/\/community.smartsheet.com\/profile\/tye.gardner35371","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-02-27T20:42:44+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":21126,"lastUser":{"userID":21126,"name":"JeremiahHorstick","url":"https:\/\/community.smartsheet.com\/profile\/JeremiahHorstick","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-07\/5b\/45\/n5b45eb0c1a48afae956282248c8ad587.jpg","dateLastActive":"2023-07-17T15:44:13+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":1238,"score":null,"hot":3270369005,"url":"https:\/\/community.smartsheet.com\/discussion\/65721\/live-data-connector-to-sage-accounting","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/65721\/live-data-connector-to-sage-accounting","format":"Rich","lastPost":{"discussionID":65721,"commentID":385580,"name":"Re: Live Data Connector to SAGE accounting","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/385580#Comment_385580","dateInserted":"2023-07-17T15:46:19+00:00","insertUserID":21126,"insertUser":{"userID":21126,"name":"JeremiahHorstick","url":"https:\/\/community.smartsheet.com\/profile\/JeremiahHorstick","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-07\/5b\/45\/n5b45eb0c1a48afae956282248c8ad587.jpg","dateLastActive":"2023-07-17T15:44:13+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-02-04T12:58:50+00:00","dateAnswered":"2020-02-04T07:52:54+00:00","acceptedAnswers":[{"commentID":238948,"body":"

Hi Tye,<\/p>

If I'm not misstaken, @JeremiahHorstick<\/a> has done this previously. <\/p>

I hope that helps!<\/p>

Have a fantastic week!<\/p>

Best,<\/p>

Andrée Starå<\/p>

Workflow Consultant \/ CEO @ WORK BOLD<\/a><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=343&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-dateLastComment&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":625,"limit":3},"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending Posts

  • 活动目录集成

    Hello, We have recently setup our Active Directory Integration. Are we able to pull data that is included in AD into a sheet in Smartsheet? For example: Name, Title, Department? And if so, how? Thanks, Melitta

  • Why is my global update to add profile data coming in blank in tests?

    Hi all, I'm trying to make a global update to add a new profile data point (created date) to metadata and summaries. I've tried doing it with both the system created date column and a helper column replicating the created date column (read in another discussion that I should try that). Both result in an incomplete data row…

  • Live Data Connector to SAGE accounting

    I was reading up on data connectors to 3rd party platforms such as Excel, Access, etc. but didn't see any information about accounting systems such as Sage or Quickbooks. Has anyone ever linked an accounting systems to Smartsheet? I am assuming it is possible, but I want to gather other's experiences if they have. Thanks!

Help shape the future of Smartsheet.
Share your ideas and feature requests.

 Watch video