topic Re: Excel file with multiple sheets - Alteryx connection in Alteryx Designer Desktop Discussions

Excel file with multiple sheets - Alteryx connection

Narresh4ut — Wed, 23 Jul 2025 08:32:30 GMT

On monthly i receive excel files which has multiple sheets. I would like to connect through Alteryx. could you please provide sample workflow

i have shared sample excel file as well.

Re: Excel file with multiple sheets - Alteryx connection

Pilsner — Wed, 23 Jul 2025 08:53:05 GMT

Hello @Narresh4ut

To load in all the data from all your excel sheets, I would recommend using a batch macro.

Firstly, load in your sheet names using the data input tool and append these names to the end of your file path with a formula:

Next, select your new field as the control parameter within the batch macro configuration window.

Inside the batch macro itself, you will need to use an action tool to allow the control parameter to overwrite the data input full path:

I believe this should then achieve the result your after. I have created a sample workflow and attached it below, please let me know if you have any questions.

Regards - Pilsner

Re: Excel file with multiple sheets - Alteryx connection

aatalai — Wed, 23 Jul 2025 13:19:14 GMT

@Narresh4ut if it is the same fomrat you could use the directory tool and the dyanmic input

Re: Excel file with multiple sheets - Alteryx connection

Narresh4ut — Thu, 24 Jul 2025 08:11:49 GMT

@Pilsner @aatalai Thank you both for the help. It worked

Re: Excel file with multiple sheets - Alteryx connection

Pilsner — Thu, 24 Jul 2025 08:16:08 GMT

Always good to hear! Thanks @Narresh4ut

Re: Excel file with multiple sheets - Alteryx connection

Narresh4ut — Fri, 08 Aug 2025 11:35:48 GMT

Hi @Pilsner currently i am able to read only one file in workflow but moving forward i will get files on monthly which the current workflow is not picking of those file. I have saved copy of test file in same folder but its not picking up. Can you provide some information here

Re: Excel file with multiple sheets - Alteryx connection

Pilsner — Fri, 08 Aug 2025 13:22:45 GMT

Hello @Narresh4ut ,

If you are trying to read in all files from a specific folder you should be able to do so as follows:

In the data input tool of the main workflow, change the file path so that it ends with the FolderName/*.xlsx.

In the screenshoot below, it tells the data input tool to look in the "_externals folder", then folder "1". As I want all excel files from folder "1", I have then used the "*" followed by ".xlsx".

I hope this adjustment makes sence, feel free to ask any questions.

Regards - Pilsner

Re: Excel file with multiple sheets - Alteryx connection

Narresh4ut — Fri, 08 Aug 2025 13:41:51 GMT

@Pilsner it worked now. Thank you for your help.

Re: Excel file with multiple sheets - Alteryx connection

Pilsner — Fri, 08 Aug 2025 13:54:35 GMT

Brilliant! Thank you @Narresh4ut

Re: Excel file with multiple sheets - Alteryx connection

jdobbins — Thu, 23 Oct 2025 15:51:46 GMT

@Pilsner hello, is there a way to use this if I am wanting to pull in the list of sheet names, but the name changes each month to reflect the current month we are in, for example sheet two is renamed every month to August 2025, September 2025, October 2025, etc.. ?

Re: Excel file with multiple sheets - Alteryx connection

Pilsner — Thu, 23 Oct 2025 16:13:48 GMT

Hello @jdobbins,

I believe the workflow above should already work for this. If you point the initial input data tool at your Excel file, it will dynamically read in all sheet names, even if they have changed from last month. The sheet names are fed into the batch macro, which then reads in the data from that sheet. If you're getting an error or the workflow still isn't working as expected, please let me know, and I can try to assist further.

Regards - Pilsner