7. Data Cleaning A–Z in Power Query
7.20 Combine Files from a Folder (Quick Version)
When the same export arrives every month (Blinkit_Orders_2025_01.csv, Blinkit_Orders_2025_02.csv …), put all files in one folder and use Home › Get data › More… › Folder. Then filter the file list (Extension, no ~$ temp files) and click Combine Files on the Content column. Power Query creates helper queries and a combined table with a Source.Name column. Steps that must run on each file (removing title rows, renaming headers) go into Transform Sample File.
Module 9 is a full step-by-step walkthrough of this process, using monthly bank statements. It covers the helper queries, deriving the month from the file name, files with an extra column and auto-refresh.
Practice task
Lakshat theva, combine three monthly Amazon Now CSVs from a folder. After reading Module 9, add a File Month column extracted from Source.Name.
Ravindra Bagale's Tip
Sagalyat common folder chuk mhanje not filtering out hidden and temporary files (such as ~$Jan.xlsx), which breaks Combine Files. Filter the file list on Extension and Attributes before combining. The full walkthrough is in Module 9. Punha ekda karun bagha, mag pudhe jaa.