Excel tab name in workflow

[ppatane]

Is there a way to get the sheet name from the inputted Excel file into a field?

[alexnajm · Accepted solution]

There’s an option in your input data tool to “output file name as a field” - select Full path and it’ll have the sheet name!

you can parse it from there if needed using a formula, there are solutions online for that if you need

[abacon]

To add on to what @alexnajm posted, the sheet name will always be last after ||| characters, that’ll make it easier to parse and find.

Bacon

[stevemarkovick]

I've dealt with this in Alteryx by using the “Dynamic Input” tool. You can bring in sheet names with a batch macro or list them via an input data tool pointing at the Excel file. Just make sure your sheet structure is consistent. It’s a bit finicky at first, but once set up, it's a powerful way to automate multi-sheet processing.