DIY Excel method
Use Power Query to Import a Bank Statement PDF
Reviewed 12 September 2026
Short answer
Short answer
In a supported version of Excel, choose Data, Get Data, From File, From PDF. Select the statement, inspect each detected table in Navigator, then choose Transform Data. Remove repeated headings and blank rows, fill or merge wrapped descriptions, set the date and amount column types, and load the cleaned table into Excel.
Power Query is the best built-in Excel option when the PDF contains tables it can recognise. It is honest DIY, but it still needs careful review.
Where Power Query works and where it struggles
Microsoft describes Power Query as a connect, transform, combine and load workflow. The PDF connector exposes tables it detects inside a document. The folder connector can combine files with a similar schema, which is useful when twelve statements truly share the same layout.
Bank PDFs often look consistent to a person while their internal text structure changes between pages or statement versions. If each month produces different detected tables or transaction descriptions split unpredictably, the query can take longer to maintain than the data is worth.
Step by step
- 01
Confirm your Excel version
Microsoft's version table shows that PDF connector availability varies, with the clearest support in Microsoft 365 for Windows.
- 02
Open the PDF connector
Choose Data, Get Data, From File, From PDF and select the statement.
- 03
Inspect Navigator
Preview every candidate table. Pick transaction tables, not account summaries or page furniture.
- 04
Transform the data
Remove headings and blanks, repair descriptions, rename columns and assign correct data types.
- 05
Load and reconcile
Load the result to a table and compare transaction movement with the printed balances.
Checks before you rely on the spreadsheet
- The PDF connector exists in the installed Excel version.
- All statement pages are represented.
- Transformations still work on the next month's layout.
- Amounts reconcile before the query is reused.
Excel documentation used in this guide
Microsoft documentation checked 12 September 2026.
Questions people ask
Is the Excel PDF connector available on every platform?
No. Microsoft documents different Power Query connector availability by Excel version and platform. Check its current compatibility table before relying on the workflow.
Can Power Query combine monthly bank statements?
Yes, its folder connector can combine files with a similar schema. Bank PDF tables must be detected consistently for that to stay reliable.
When should I stop fixing the query?
If every statement month needs a different set of cleanup rules, compare that maintenance time with using a parser already built for the bank.