Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Import multiple excel sheets into one Smartsheet

Does anyone know how or if you can import multiple excel sheets into one smartsheet?
Comments
-
Hi Stephanie,
There isn't functionality to import multiple excel worksheets or excel files in as one sheet in Smartsheet.
Currently, only the first page of one excel file can be imported at a time to create a sheet. To get all of your excel worksheets in, you'll need to import your excel file multiple times, moving the excel worksheet to the first page before each import.
-
Stephanie,
If this were done often, I would write VBA code to export each worksheet within a workbook to a single Excel sheet (or csv).
If your scenario is one workbook-many worksheets or many workbooks-single sheets, I would write API code to consolidate into a single sheet on import.
Craig
-
Hi Stephanie,
Smartsheet just released a new add-on called Data Uploader that might help.
Please see the attached link/screenshot for more information.
https://www.smartsheet.com/datauploader
I hope this helps you!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
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
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives