Power Query troubleshooting
Why Won't Excel Import My PDF Bank Statement?
Reviewed 12 September 2026
Short answer
Short answer
Excel may fail to import a bank statement because your version does not include the Power Query PDF connector, the PDF contains scanned images rather than selectable text, the file is password protected, or the statement layout is not exposed as a consistent table. Check connector availability first, then test whether you can select text in the PDF. If Excel detects no useful transaction table, use the bank's CSV export or a converter built for that statement layout.
An import failure does not always mean the PDF is damaged. Excel and the statement may simply disagree about where the table begins and ends.
Work out which kind of failure you have
Microsoft documents different Power Query data-source support across Excel versions and platforms. If From PDF is missing from Data, Get Data, confirm the installed version before changing the document.
If the connector exists but Navigator shows no useful tables, inspect the PDF itself. A scan needs OCR, while a text PDF can still use positioned words instead of a true table. Repeated headings, wrapped descriptions and multiple account sections can also fragment the detected result.
Step by step
- 01
Check the connector
Confirm that From PDF is available in your Excel version and platform.
- 02
Check the document
Open the PDF and test whether transaction text can be selected. A page image will need OCR.
- 03
Inspect every detected table
Navigator may split one statement across several tables or surface only summary data.
- 04
Choose another source
Use the bank's CSV export where available, or convert the original Australian bank PDF with a dedicated parser.
Checks before you rely on the spreadsheet
- The installed Excel version supports From PDF.
- The PDF is not locked and contains usable text.
- Every statement page appears in Navigator.
- Any extracted amount direction is checked against balances.
Excel documentation used in this guide
Microsoft documentation checked 12 September 2026.
Questions people ask
Why is From PDF missing in Excel?
Power Query connector availability varies by Excel version and platform. Check Microsoft's current data-source table for the version you use.
Why does Navigator show no tables?
The PDF may be a scan or may store positioned text without a table structure Excel can detect.
Can AussieBankStatements read a scanned statement?
Use the original digital statement wherever possible. A screenshot or scan may not contain the reliable text layer needed for accurate extraction.