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
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives