Importing/Syncing Excel File
![smarterwithsmart](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
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
-
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
-
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 EXPERT CONSULTANT & PARTNER
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!