Welcome to the Power Users community on Codidact!
Power Users is a Q&A site for questions about the usage of computer software and hardware. We are still a small site and would like to grow, so please consider joining our community. We are looking forward to your questions and answers; they are the building blocks of a repository of knowledge we are building together.
How can I use Power Query to import many monthly Excel files, into 1 Excel file with many sheets, with each month on its own sheet? [duplicate] [closed]
Closed as unclear by samcarter on Jun 14, 2025 at 10:41
This question cannot be answered in its current form, because critical information is missing.
This question was closed; new answers can no longer be added. Users with the Vote on Holds ability may vote to reopen this question if it has been improved or closed incorrectly.
i am facing the same difficulty as https://superuser.com/questions/1896861/how-can-i-use-power-query-to-import-many-monthly-excel-files-into-1-excel-file?noredirect=1&lq=1. as it got wrongly closed as duplicate, i repost it here. thanks!
I watched this YouTube video in which the user (Kenji) united all 3 Excel files into 1 Excel file, on the same sheet:
Which is nice but not quite what I'm after. I'm wondering how I can tweak this to unite 3 Excel files into 1 Excel file, but on 3 DIFFERENT sheets? i.e. I want a separate sheet on each month.
It's unproductive to manually insert hundreds of separate Excel files as sheets one at a time - for every month of securities transactions for past decades.
I'd like to avoid solutions involving Python or VBA if possible.
1 comment thread