Import Multiple Excel Sheets Dynamically with Header Only on First Sheet in Alteryx

Question

Hi everyone, I am new to Alteryx and I am trying to import multiple sheets from a single Excel file dynamically, instead of using a separate Input Data tool for each sheet.

There is one complication in my file structure. The first sheet contains a header row in row 1 and the data begins from row 2. All the following sheets contain only data with no header, and the data begins from row 1.

I tried adapting the solution from this community post:
https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Import-Multiple-Excel-Sheet-from-same-File/td-p/1239124
but I was not able to get it working.

Has anyone handled a similar scenario or can suggest an approach for combining these sheets dynamically while applying the correct header only once?

Thank you in advance for your help.

Yoshiro_Fujimori · Accepted Answer

Hi @Red-01 ,

I would read the first sheet and the rest separately.

When input with Dynamic Input Tool, set "First Row Contains Data" to off for the first sheet, and to ON for the rest of the sheets.

Then Union the records with "Auto Config by Position" mode.

Here is a sample workflow.

I hope this helps. Good luck.

WirkKarl · Accepted Answer

Hi Red-01, welcome to Alteryx! For this scenario, a common approach is to use the Dynamic Input tool along with a Control Parameter to iterate over all sheets. You can read the first sheet with headers normally, then read the remaining sheets without headers and union them together, applying the first sheet’s headers. Sometimes a Dynamic Rename after the union helps make sure all columns align correctly. This usually works well for combining multiple sheets while keeping the header from just the first one.