You can import an existing Microsoft Excel file, Microsoft Project project, Google Spreadsheet, or Atlassian Trello board to create a new sheet in Smartsheet. Import will always create a new sheet. To bring data from other programs into an existing sheet, use copy and paste.
Import the workbook into Smartsheet once to create a new sheet, as described above. Go back to the Excel file and move a different tab into the left-most position by clicking on it and dragging it to the left. Save the Excel file, and import it to Smartsheet again. This will create a new sheet based on the information in the tab you just moved into the left-most position. Repeat the process until you’ve created a sheet for each tab in the workbook. In Smartsheet, consider moving all of the sheets into a folder or workspace for organizational purposes.
Import Files to Create New Sheets You can import an existing Microsoft Excel file, Microsoft Project project, Google Spreadsheet, or Atlassian Trello board to create a new sheet in Smartsheet. Import will always create a new sheet. To bring data from other programs into an existing sheet, use copy and paste.
What is the Smartsheet Excel add-in?
The Smartsheet Excel Add-In is a powerful tool that allows you to connect with live data from Smartsheet, directly from Microsoft Excel . Use Excel to connect to Smartsheet Sheets, Contacts, Folders, Groups, Users, etc. Perfect for Excel based data analysis, data cleansing & de-duplication, and more!
Look at the very bottom of your Excel workbook to see if you have multiple tabs . Import the workbook into Smartsheet once to create a new sheet, as described above. Go back to the Excel file and move a different tab into the left-most position by clicking on it and dragging it to the left.
How to export all the tabs in a Smartsheet?
In Smartsheet, consider moving all of the sheets into a folder or workspace for organizational purposes. I solved this (on my Mac) by creating an Apple. Script that takes a given Excel workbook and exports each tab as a file using the name of the tab as the filename.