Importing of Multiple tabs excel sheet

Hello,

I am looking out for a way to import multiple tabbed excel sheet to my smartsheet workspace. I see it doesnt pick all tabs. Is there a different way of doing so?

Or I have to import all as a different sheet?

Kind Regards,

Ashok

Find more posts tagged with

IT & Operations

Comments

Tim Meeks

http://help.smartsheet.com/articles/504553-importing-files-to-create-new-sheets

Importing Multiple Sheets from a Microsoft Excel Workbook

Only the first (left-most) worksheet tab of an Excel workbook will be imported. Look at the very bottom of your Excel workbook to see if you have multiple tabs.

If you have multiple tabs you'd like to import to Smartsheet:

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.

Antonella De Spuches

I am following with high interest

joechap

I solved this (on my Mac) by creating an AppleScript that takes a given Excel workbook and exports each tab as a file using the name of the tab as the filename. You can then follow the aforementioned instructions to import each file. Tedious to import but, it works.

We had a team using a workbook with well over 300 tabs and my script was able to churn through it over a coffee break. I had to actually build in a delay and slow it down or Excel (for Mac) effectively died after the first 40 or 50 tabs.

I can't upload the script but here's the text below of the AppleScript:

Excel-SaveSheet.scpt

set f to (choose file)

set posixF to POSIX path of f

tell application "Finder" to set filesDir to container of f as alias as text

tell application "Finder" to set fName to name of f as text

set posixDir to POSIX path of filesDir

{f, fName, posixF, filesDir, posixDir}

tell application "Microsoft Excel"

   launch

   open posixF

   set wkbkSrc to workbook fName

   set theSheets to every sheet

   repeat with i from 1 to number of items in theSheets

       set srcSheet to sheet i of wkbkSrc



       set wkbkTarg to make new workbook

       set lastTargSheet to sheet (count of sheets) of wkbkTarg



       copy worksheet srcSheet before lastTargSheet



       tell wkbkTarg

           set srcSheetName to name of srcSheet

           set fullTargFile to (posixDir & (srcSheetName & ".xlsx")) as text

           save workbook as filename fullTargFile overwrite yes

       end tell

       delay 3

       close active window

       delay 3

   end repeat

end tell

Andrée Starå

Hi,

Smartsheet just released a new add-on called Data Uploader that could be an option for you.

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