In Excel, choose Data > Get Data > From File > From PDF, pick the statement, select the table for each page in the Navigator, and load or transform it. It works on PDFs with selectable text, not scans. Not every Excel version has it, so look for the option in your Data menu first.
Does your Excel have the PDF connector?
Open Data > Get Data > From File and look for From PDF. Recent Microsoft 365 and newer perpetual versions of Excel for Windows usually have it. Older versions, and some other editions, do not. If the entry is missing, use another method, such as opening the PDF in Word or a paste-and-split approach, rather than hunting for a download. Also check that the PDF has real text: try selecting a line of it in a PDF viewer. If you cannot, it is a scan. If the file is password protected and will not load, make an unprotected working copy with your PDF viewer's print-to-PDF option, convert it, and delete the copy afterwards.
How do you use the Navigator step by step?
- Choose Data > Get Data > From File > From PDF and select the statement file.
- The Navigator lists items such as Table001 (Page 1) and Page001. Click one to see a preview on the right.
- Prefer the Table items when the preview looks like rows and columns. Use the Page items if no table is detected.
- Tick Select multiple items to choose each page's table, then click Transform Data, not Load.
How do you combine pages into one table?
In Power Query, each page arrives as its own query. Choose Home > Append Queries > Append Queries as New, pick Three or more tables, and add every page table. The result is one long table. If your statement has fifteen pages, this is far quicker than copying page by page.
What cleaning is usually needed?
| Problem in the result | Fix in Power Query |
|---|---|
| Header row repeated on every page | Filter the Date column to remove rows equal to Date |
| Blank rows and page footers | Home > Remove Rows > Remove Blank Rows, then filter out footer text |
| Column names show as Column1, Column2 | Transform > Use First Row as Headers |
| Dates read as text | Change Type > Using Locale > Date, English (India) |
| Amounts with commas read as text | Change Type > Using Locale > Decimal Number, English (India) |
| Narration split across two rows | Fix by hand after loading, then re-check the totals |
When you are happy, choose Home > Close & Load. The steps are saved, and a new month's PDF with the same layout can reuse them if you change the source file in the query.
A quick reconciliation example
Say the statement shows an opening balance of ₹30,000 and a closing balance of ₹36,400. After loading, your credits total ₹50,000 and your debits ₹43,600. The check is 30,000 + 50,000 - 43,600 = 36,400, which matches. If the answer were 36,100, some ₹300 debit is missing or counted in the wrong column, so go back to the page where the layout looked unusual.
A table that runs across several pages arrives as separate items, one per page. Keep the page order when you append, since the running balance check only works if the pages are in sequence. If a page's table is missing from the list, pick the matching Page item instead and clean it by hand.
When the connector does not fit
Layouts that mix several tables on one page, scanned documents and very small print all trip it up. For regular uploads, SpendixAI accepts statement PDFs directly and shows the rows for review before saving, which can save the cleaning. Layouts vary between banks, so check the preview.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


