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
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives