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.

Importing of Multiple tabs excel sheet

Ashok Poojary
edited 12/09/19 in Archived 2016 Posts



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,



  • Tim Meeks
    Tim Meeks ✭✭✭✭✭✭



    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.



  • I am following with high interest :)

  • joechap
    joechap ✭✭
    edited 01/18/18

    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:


    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"


        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å
    Andrée Starå ✭✭✭✭✭✭


    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.


    I hope this helps you!


    Andrée Starå

    Workflow Consultant @ Get Done Consulting


    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.

This discussion has been closed.