Importing numerous workbooks into Smartsheet from one Excel document
We are importing a ton of material from XLS into Smartsheet. Each XLS has numerous workbooks/tabs. Is there a way to tell Smartsheet to load a specific tab or do you have to save off one tab at a time into a new document to load them?
Best Answer
-
Hi Pamela,
To my understanding you only can import one tab at a time, and it will only import the first one.
So if you have several tabs, you have to import the first one, then change the tab order in Excel, to have the next to be imported first, then import again, and so on.
Hope it works for you :)
Answers
-
Hi Pamela,
To my understanding you only can import one tab at a time, and it will only import the first one.
So if you have several tabs, you have to import the first one, then change the tab order in Excel, to have the next to be imported first, then import again, and so on.
Hope it works for you :)
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.3K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 477 Announcements
- 5K Ideas & Feature Requests
- 85 Brandfolder
- 151 Just for fun
- 72 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 302 Events
- 36 Webinars
- 7.3K Forum Archives