Importing/Syncing Excel File

smarterwithsmart

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 Williams

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å

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