Home › Guides › PDF Bank Statement to Excel Manually
PDF Bank Statement to Excel Manually
On Excel for Windows, Microsoft documents importing PDF tables with Data > Get Data > From File > From PDF, then Load or Transform Data in Power Query. Bank statements often split across pages, mix headers with totals, and break when copied as text — so check opening + credits − debits against the printed closing balance before you trust the sheet. Excel for Mac's Get Data list does not include a PDF connector in Microsoft's published Mac sources table (checked November 7, 2026).
Updated November 7, 2026
First choice: download a real data file from the bank
Before converting a PDF, check whether the bank already offers CSV, Quicken (QFX) or QuickBooks (QBO) downloads. Those files usually keep dates and amounts as data, not as a picture of a printed page. See the US bank statement format guide for sourced notes on common US banks.
Excel for Windows: Data → Get Data → From File → From PDF
Microsoft documents this path in Import data from data sources (Power Query) (Windows section). Steps, checked November 7, 2026:
- Open Excel for Windows (Excel 2016 or later / Microsoft 365).
- Select Data > Get Data > From File > From PDF.
- Choose the statement PDF and Open. The Navigator lists tables Excel detected.
- Select the transaction table(s). Choose Load to put them on a sheet, or Transform Data to clean columns in Power Query first.
Microsoft notes that the PDF connector may require .NET Framework 4.5 or higher. If Excel shows a missing-components message for the PDF connector, install a current .NET Framework build from Microsoft before retrying.
Power Query’s PDF connector (Pdf.Tables) can combine similar tables across consecutive pages (MultiPageTables, default true) and lets you limit page ranges with StartPage / EndPage. That helps multi-page statements, but it does not remove statement headers, footers or “Totals” rows for you.
Excel for Mac and Excel on the web
Microsoft’s Power Query data sources in Excel versions page (checked November 7, 2026) lists the PDF connector under Excel 2016 or later for Windows and Microsoft 365. The Excel for Microsoft 365 for Mac table on the same page lists Text/CSV, Excel workbook, XML, JSON and other sources — not PDF. Excel for the web can reach PDF files stored in SharePoint/OneDrive for work or school according to that article; a local bank PDF on disk is outside that path. If From PDF is missing, convert or export to CSV/Excel elsewhere, then use Data > Get Data > From Text/CSV (or the Mac equivalent) rather than inventing a PDF menu that is not documented for your build.
Copy-paste and “Open with Excel” pitfalls
- Selecting text in a PDF viewer often collapses columns into one cell or splits a description across rows. Amounts can become text (“$1,234.56”) that will not SUM until cleaned.
- Page tables break: each PDF page may restart headers; pasting page 2 under page 1 duplicates column titles mid-sheet.
- Image-only (scanned) PDFs have no selectable text. Get Data From PDF will not invent transactions from a photograph of a statement — you need OCR first (Excel’s connector is for tables found in the PDF, not a guarantee for every scan).
- Date ambiguity: 03/04/2026 may be 4 March or 3 April. Confirm against the statement period before sorting.
Clean the sheet, then reconcile (fictional example)
Suppose a one-page checking statement shows opening balance 2,450.00, closing balance 2,785.40, and these fictional rows after cleanup:
| Date | Description | Amount |
|---|---|---|
| 2026-10-03 | ACME PAYROLL | 1,200.00 |
| 2026-10-05 | CITY UTILITIES | -84.60 |
| 2026-10-12 | OFFICE SUPPLIES | -45.00 |
| 2026-10-18 | CLIENT TRANSFER | 265.00 |
Check: 2,450.00 + 1,200.00 − 84.60 − 45.00 + 265.00 = 2,785.40, which matches the printed closing balance. If your sheet is off by 45.00, look for a missing supplies row or a sign that flipped. Matching totals does not prove every description character is perfect — still spot-check payees.
In Power Query, typical cleanup includes promoting the right header row, removing blank and “Total” rows, splitting debit/credit into one signed Amount column, and setting Date / Decimal number types before Close & Load.
When a browser converter helps
Disclosure: I built CSVLedger. It converts text and clear English scanned bank statement PDFs to Excel in your browser (no upload), with an automatic balance check. Use it when Power Query’s table detection is messy, you need OCR for a scan, or you want .xlsx / CSV / QBO / Xero layouts without rebuilding columns by hand.
Open PDF to Excel → · Scanned statements (OCR) · How we check accuracy · Plans and limits
Conversion runs in your browser; statement files are not uploaded to CSVLedger. A balance check helps spot extraction issues; it does not replace your review or accounting reconciliation. No fake testimonials — try a short statement you already understand.
Frequently asked questions
Does Excel for Windows include Get Data From PDF?
Yes. Microsoft's Import data from data sources (Power Query) article documents Data > Get Data > From File > From PDF on Windows Excel. The Navigator lists tables found in the PDF; you can Load them or open Transform Data. The PDF connector requires .NET Framework 4.5 or higher.
Does Excel for Mac support From PDF?
Microsoft's Power Query data sources by Excel version page lists PDF under Excel 2016 or later for Windows and Microsoft 365, and does not list PDF among Excel for Microsoft 365 for Mac data sources (checked November 7, 2026). On Mac, export or convert the statement to CSV/Excel first, then use Get Data From Text/CSV or open the file.
Why do bank statement tables break across pages?
Power Query's PDF connector can combine similar tables on consecutive pages (MultiPageTables, default true in Pdf.Tables). Statement pages still often insert running headers, section titles, or daily subtotals that become extra rows. Always remove summary lines and verify the balance equation before importing into bookkeeping software.
When should I use a converter instead?
Use Excel's built-in path when the PDF has clean selectable tables and you are comfortable cleaning columns in Power Query. A browser converter helps when you need signed amounts, QuickBooks/Xero layouts, scanned-page OCR, or an automatic opening/closing balance check without uploading the file.
Related guides
- Convert a bank statement PDF to Excel in your browser
- Scanned bank statement OCR
- How CSVLedger checks accuracy
- QuickBooks Online CSV format
Sources and scope
Based on official Microsoft documentation fetched and checked on November 7, 2026. Menus, regional builds and connector availability can change; if your ribbon differs, follow the current Microsoft article for your Excel edition. Examples are fictional. This page is documentation-based guidance, not a claim that every PDF layout was tested live in every Excel SKU.