How to write a lot of sheets from one excel file to multiple files?

[jonnyrask]

Hi,

I have one excel file with multiple sheets. How can I take each sheet and output it to its own .xslx file. I would want to keep the same sheet name as the file name.

Thanks!

[fmvizcaino · Accepted solution]

Hi @jonnyrask ,

Here is a suggestion showing how to do it.

1. Input - option 'List of sheet names' to get all sheets available

2. Formula - create the filename for the dynamic input

3. Dynamic input - read all sheets from the file - all sheets must have the same structure of columns to work

4. Formula - create the filename for the output.

Best,

Fernando Vizcaino

[jonnyrask]

How do i set it to a file path?

[fmvizcaino]

Hi @jonnyrask ,

I inserted the path in the second formula. Please find attached.

Best,

Fernando Vizcaino

[jonnyrask]

Hi, I think you uploaded the wrong file, because nothing has changed. Thanks!