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?

Comments

  • J. Craig WilliamsJ. Craig Williams Top Contributor

    I use either:

    a) AppSheet

    b) the API

    or

    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.

    Craig

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

    Hi,

    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.

    https://www.smartsheet.com/datauploader

    I hope this helps you!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    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.

Sign In or Register to comment.