Excel which has multiple sheets needs to generated as seperate excel file for each sheet

[Manomon]

Hi All,

Could you please tell me how to split the multiple sheets in a excel to separate excel file for each sheet ?

[Carolyn]

Hi @Manomon, 

You'll want to create a column with the tab name, if you don't already have one. 

Then in the output tool, in the bottom left, check "Take Field/Table Name" box, select "Change File/Table Name", and select your column with the tab name (mine is called "Tab"). Optionally, you can check or uncheck the box to keep the field in the output file

Then, when you run the workflow, the data will split based on the column you specify

[Manomon]

Hi Carolyn, Many thanks for the guidance  however it gave me only one excel file with the split of sheets in the same excel , i wanted separate excel for each sheet

[Carolyn]

Apologies! I misunderstood your request!

In that case, what you'll want to do is have a column with the file and tab name - "OutputA.xlsx|||Tab1", etc. Then you'll set it to "Change Entire File Path", select the column with the file and tab name, and then it will write the various Excel output files. 

This will write to the same location where the workflow is saved. If you want to save in a folder "near" the workflow, you can use relative paths. If you want it go to a completely different location, you can also put in the full file path (e.g. G:\\My Drive\Folder\Folder\File Name.xlsx|||Tab) and use that as well

[MelGibson]

You will need to identify those locations using a formula that identifies the file name and then your output would have the take file/table name from field checked and then choose the dropdown that will work for you and select the field that has the file name formula. 

[binuacs]

@Manomon another option is to use bath macro

[Manomon]

It is showing me an error saying , specify the sheet name

[Carolyn]

@Manomon - In your column where you identify the file name, make sure it also has the sheet name

I think yours is something like

FileName.xlsx

and it needs to be:

FileName.xlsx|||TabName

If that doesn't work/help, are you able to send a screenshot showing the column that you're using for the file name?

[Manomon]

Hi Binuacs, Is this bath macro available in 2022 alteryx version ?

[ChrisTX]

@Manomon see attached file 

Adjusting Alteryx Files for Different Versions.docx