how to Combine excel files

[Amardeep100115]

Hi there, I wish to connect various excel file in one table which has different name of sheet and excel file as well. but the data column has same headings and data is in separate folder. Please guide! 🙂

[v-yulgu-msft · Accepted solution]

Hi @Amardeep100115,

Why not place all excel files into the same Folder? That case, you can connect to multiple excel files via Folder connector.

Alternatively, if you load excel files one by one, multiple queries will be loaded into desktop, then, you can combine these tables into a single one with "Append" function.

Best regards,

Yuliana Gu

[Amardeep100115]

Yeah it will help me lot but we have maintained data in year wise folder and we cannot make in one place. for that year we have at least 12-15 files that's why looking for any other way to knock out this puzzle. Thanks for your help hope i will hear more from your and others on my query. Thanks once again.