Import multiple Excel worksheets at once

Idea created by harrisde on Jan 29, 2014
    New
    Score80
    • harrisde
    • lygismav
    • dcaldwell
    • dan_odonohue
    • cjackman
    • rchasan
    • dgo777au
    • mping
    Let's have a tool that either imports all worksheets (tabs) from an Excel spreadsheet into a workspace, not just individual sheets.

    I'm working with spreadsheets that have mutliple worksheets (tabs) and have to import each separately (or build a model that selects each separate worksheet). A tool that imports all the worksheets in one go would make my life a lot easier!

    I love the excel to spreadsheet tool as I've found other tools such as table to table do not import thedata correctly. I have tried to do this using table to table tools, submodels with collect values, different iteraters etc... but with no luck.