Extract sheets to separate excel workbook

[VMR]

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.

[YEM]

You have a lot, like dozens, of options to accomplish this.

Easy Option 1:

Use 4 output tools

Easy Option 2:

Union the 4 inputs, create a field with the desired output file name.  Use a single output tool with "take file name from field".

[VMR]

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!

[mceleavey]

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.

[natalia_wysocka12]

Can you please share your workflow?