How to merge multiple '.xlsx' files saved within a folder with only 1 of 3 sheets?

[Nikhil8087]

Hi all,

I have 100 '.xlsx' files saved in a folder and every Excel file has 3 sheets within it. I want to merge all 100 files with only 1 sheet out of those 3 sheets. Is it possible to do? if yes, how can I do it?

[DavidP · Accepted solution]

If the files are all identical in structure, you can just use a wildcard in the filepath of the input data tool, i.e. select one of the files with the sheet you want loaded and replace the file name (or part of it) with a *.

If the files have different structures (schemas), you'll have to write a batch macro.

[Nikhil8087]

Thank you so much, David. It really worked !!! :)

[aahana]

Thank you