Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Update existing smartsheet by excel

Peter Smith
edited 12/09/19 in Archived 2017 Posts



I have a smartsheet with 4 columns: building code, name, cs manager name and supervisor. I create this smartsheet by import excel. Excel has 4 same columns.. 


However, cs manager always change.  We have 1000 buildings.  

Admin will send update list every week.. I know there is data live connector.. if I change info in excel (the ond i use to import smartsheet)  than it change in SMARTSHEET. anyway can achieve? 




  • Peter Smith

    Ho, everyone, may I ask anyone has idea? 

    Smartsheet has video for how to install data connector.. however, not many resource to show how to use it


  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    Hi Peter, from my review of the Live Data connector it seems like it's more a tool for sending data from Smartsheet to tools like Excel for gathering reports. Not necessarily pulling from Excell and putting it into Smartsheets. I know that people have successfully integrated tools like Zapier. You might want to check into that. 

  • CanadaJim

    Can you have the admin switch to updating your Smartsheet instead?  Set them up as an editor?

  • Peter Smith

    Checked with Zapier. They say they can't do that. 

    My example to Zapier is: I have spreadsheet and SS with same info. Both of them include info  building plan no. , building manager, account manager.  I have updated spreadsheet to have right info. For example., If excel has 600 rows, 30 rows info need updated. How to use Zapier to achieve.

    Zapier says i need to have 30 Zap to do changes in SmartSheet. 


    The email from Zapier:

    In order for us to use the ROW ID, we need to the function of 'Find Row' in order to make sure we update your SmartSheets correctly. Unfortunately, it is not possible with SmartSheet's API to do this as it doesn't allow us to specify a column to be searched. So it would mean that each time you would want to update a row, you would need to create a brand new Zap for each row, which in the long run will cost you a lot and isn't sustainable to you.


  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    Are you adding buildings or do the number stay the same?

    If so, I believe I have solution. It would still require Zapier.

    It might take me a few hours to set up. Contact Richard at Smarter Business Processes if you are interested (richardr@smarterbusinessprocesses.com). We should be able to determine in the 1 hour free consult whether my solution will work for your problem.





  • Richard Rymill SBP
    Richard Rymill SBP ✭✭✭✭✭✭


    Craig has done some amazing things with Zapier and Smartsheet so it is more to do with  a creative design than a simple yes no I believe?  

    Craig and our team have this week completed another integration of Excel with Smartsheet, where data travels in both directions not just FROM Smartsheet and the client is delighted . We are regularly using Appsheet for this integration and it brings other benefits too, like conditional logic.  

    If you want the same Peter, we can offer that integration between Excel and Smartsheet as an alternative to the Zapier solution if that doesn't work out?  

    If it helps here is the case study from MGC Roofing in Florida... http://smarterbusinessprocesses.com/construction-company-works-smarter-smartsheet-appsheet-solution/

    Hope that info helps? Let me know if you'd like to work with us on this?


  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi Peter,

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

    Please see the attached link/screenshot for more information.


    I hope this helps you!


    Andrée Starå

    Workflow Consultant @ Get Done Consulting


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

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

This discussion has been closed.