Put all your statement files in one folder, then in Excel choose Data, Get Data, From File, From Folder, point at it, and pick Combine, then Combine & Transform Data. Power Query stacks every file into one table and adds a column with the file name, so a new month is just another file dropped into the folder.
How do you prepare the folder?
- One folder, one kind of file: only statement CSVs, or only statement workbooks. Mixed types make the sample step unreliable.
- Keep names meaningful, such as savings-2025-04.csv, because the file name becomes a column you can use later.
- Close the files in Excel before refreshing. An open workbook leaves a hidden temporary file beginning with a tilde in the folder, and that stray file can cause an error when combining.
- Keep the folder path stable. The query remembers it, and moving the folder means editing the Source step.
What do you click, step by step?
- Data, Get Data, From File, From Folder. Browse to the folder and press Open.
- The preview lists every file with its name, extension and dates. If you see anything that is not a statement, press Transform Data and filter the Extension column to the type you want, say .csv.
- Choose Combine, then Combine & Transform Data. In the dialog, pick the sample file (the first file is fine) and check that the preview looks like a statement.
- Press OK. Power Query creates helper items on the left (a sample file, a parameter and a function) and a main query holding the combined rows.
The helper query named Transform Sample File is where your cleaning belongs. Any step you add there, such as removing top rows, applies to every file in the folder. Steps added only to the final combined query run once, on the whole stack.
How do you deal with header rows repeated in every file?
If each file begins with account details and a header, strip them inside Transform Sample File: Remove Top Rows, then Use First Row as Headers. Do not promote headers in the combined query, or you will promote only the first file's heading and leave the others as data.
If a repeated heading still sneaks in as data, for example a row where the Date cell reads Date, add a filter on the Date column in the combined query to exclude that text. A typed date column will also turn such rows into errors you can remove with Remove Errors.
Can you keep the source file name?
Yes, and you should. The combined query starts with a Source.Name column holding the file name. Rename it to Source File. To pull the month out of a name like savings-2025-04.csv, use Add Column, Extract, Text Between Delimiters, or Split Column by Delimiter and keep the part you need. That column lets you compare row counts per file against what each file really has.
What should you watch for after combining?
- Files with a different column order or heading: Power Query matches by name, so a renamed column shows as an extra column with nulls.
- Dates: set the type once, with the right locale, rather than trusting the automatic step.
- Balance continuity between files, since a missing month is easy to overlook in a big stack.
- Duplicates where two files cover overlapping dates.
When is this approach the right one?
When you have many files and will keep adding to them, and especially when all of them share one layout. For a single one-off, the copy-paste method may be quicker. For files from different banks with different layouts, first map their headings to a common set of names, and only then combine them.
Finish with this short routine
- Drop the new statement in the folder.
- Choose Data, Refresh All.
- Check the per-file counts and the latest date.
If you would rather not maintain queries at all, SpendixAI takes batch uploads of PDF, CSV or Excel statements, with an import history showing the status of each.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


