Extract sheets to separate excel workbook

Question

Hi -

I am trying to extract the sheets as separate excel workbook from one excel file. Any help is appreciated.

Ex:  I have sheets of US, UK, Africa & India in one excel file. I have to make these sheets as separate excel files/workbooks.

natalia_wysocka12 · Answer

Can you please share your workflow?

mceleavey · Answer

Hi @VMR ,

I've attached a couple of tools and a working example for you.

The first tool reads in all the tab names from your selected folder location, adds them to a filepath, then the second loads them in dynamically and unions them together.

You can filter the ones you want, and you can isolate each like for like sheet.

Hope this helps.

M.

Dynamic Multi File Sheet Names.yxmc

Import Multiple Schema Flat Files.yxmc

Multi Sheet Import Example.yxmd

VMR · Answer

Hi YEM -

Thanks but, I have 20+ sheet in the input. Creating output for every sheet is kind of thinkable. I tried to create a Batch macro which helps me. Thanks again!