Bring data into Smartsheet with API or ODBC from Excel
Hi,
Does anyone know how to configure Excel or Smartsheet so that a sheet can read data from Excel? I have it working so that Smartsheet is a source and use excel to pick up a sheet's data but not the other way.
All the literature and videos say it can be done but I cannot find out how!
Answers
-
Do you have access to the add-on Data Shuttle / Data Uploader?
-
Hi @David J
I hope you're well and safe!
Have you explored using the premium app, Data Shuttle?
Is that an option?
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
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.
-
Hi Andree, Paul
Thanks for the replies, I'm very well thank you!
Yes, we currently use the shuttle by extracting data from our ERP and manually dropping into the sheet as an attachment, then the shuttle does it's magic by updating the target tables. I'm looking to remove the 'middleman' and was hoping the ERP extract could be parked on a share drive and then the connector would read the excel directly (the shuttle can still be used).
Also, I find limitations with the shuttle as it only allows a file to be picked up from say a personal onedrive so if someone is away, then no one else can update that file in its location.
My smartsheet account contact advises me the connector is meant to be a unidirectional flow of data from SMAR to certain applications like Excel. I have had the API working but again, only one way.
David
-
Happy to help. 👍️
-
Excellent!
Happy to help!
✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful, Insightful/Vote Up/Awesome. It will make it easier for others to find a solution or help to answer!
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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives