Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Export individual tabs in 1 excel file into it's own separate excel file

chokwoo
6 - Meteoroid

Hello, so I have 1 excel file with 10 different tabs with unique names. I'd like to use alteryx to export each tab as a separate excel file and name the file according to the names of the tabs. Any help is appreciated!

4 REPLIES 4
Felipe_Ribeir0
16 - Nebula

Hi @chokwoo 

 

Try the attached workflow, just point the input tool to your main file and run.

 

Felipe_Ribeir0_0-1670373540505.png

 

chokwoo
6 - Meteoroid

Hello @Felipe_Ribeir0 , thank you for your response!

I imported the file and ran the workflow but getting a Parse Error at the Formula tool. could you please advise?

Also, when I import the file, should I just import under "Select a Sheet"?

 

Much appreciated.

chokwoo_0-1670653626028.png

 

Armon24
Alteryx
Alteryx

Hi @chokwoo 

When you import the file, select import only the list of sheet names. This should get the formula tool to work.

PanPP
Alteryx Alumni (Retired)

This is how the Input tool should be configured. 

 

Import only the sheet names.

 

Sheet Input.png

 

 

Hope this helps.

Labels