Importing/Syncing Excel File

smarterppsdsmarterppsd ✭✭✭✭
edited 12/09/19 in Formulas and Functions
10/09/18 Edited 12/09/19

I have created some sheets that reference a master sheet. This master sheet was populated by importing an excel file. The data in that excel file is generated from a web page that exports to excel and is constantly updating. I'm seeking a solution to be able to update my master sheet. Importing doesn't work as it creates a new sheet and my formulas won't reference the new sheet. Copying and pasting doesn't work either as I'm over the 500 row limit.

Any ideas on a solution?


  • J. Craig WilliamsJ. Craig Williams Top Contributor

    I use either:

    a) AppSheet

    b) the API


    c) a partially manual import > move rows to a 'landing sheet' which connected to the final sheet using X-Sheet References. This one has limitations due to the number of cells that can be linked in this way.


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


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

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

Sign In or Register to comment.