Live Data Connector (Data Extract from Excel Worksheet)
Who can answer technical questions about Live Data Connector to extract data from Excel?
Trying to determine if one can:
Include full path to Excel workbook in Smartsheet cell
Include name of Worksheet in Smartsheet cell
Point to designated Excel Worksheet in designated Workbook
Transfer data based on Excel Worksheet named ranges to Smartsheet
Thanks in advance.
John Cleaveland
john.cleaveland@mgroupcorp.com
Best Answer
-
The Smartsheet Live Data Connector provides a read-only experience and is not able to write data into Smartsheet (see the documentation for the Live Data Connector, here.)
It sounds like you may actually be more interested in the premium application Data Uploader, which would be able to "transfer data based on excel named ranges" as in your last point. (See here for more information on Data Uploader.)
If you have more questions, you may want to reach out directly to the Smartsheet Sales Team (here) who can discuss the product capabilities and what will best suit your current plan and set up.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
The Smartsheet Live Data Connector provides a read-only experience and is not able to write data into Smartsheet (see the documentation for the Live Data Connector, here.)
It sounds like you may actually be more interested in the premium application Data Uploader, which would be able to "transfer data based on excel named ranges" as in your last point. (See here for more information on Data Uploader.)
If you have more questions, you may want to reach out directly to the Smartsheet Sales Team (here) who can discuss the product capabilities and what will best suit your current plan and set up.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives