How to convert a bank statement to Excel
Updated 2026-08-19
There are three realistic ways to get a bank statement into Excel, and they differ mostly in how much cleanup you do afterwards. It is worth knowing which one you are choosing, because the fastest-looking option is usually the slowest.
Option 1: copy and paste
Select the transaction table in the PDF, copy, paste into Excel. It takes ten seconds and produces a single column of jumbled text. PDF text carries position, not structure, so the paste follows the layout engine's reading order rather than the visual grid. Wrapped descriptions become their own rows and amounts land wherever they happen to fall.
Option 2: Excel's Get Data from PDF
Excel for Microsoft 365 can import PDF tables through Data then Get Data then From File then From PDF. On a simple one-table statement it works. On a real statement with separate deposit, withdrawal and check sections it returns several disconnected tables, and it cannot read a scanned statement at all.
Option 3: convert to CSV first
Convert the statement to a clean four-column CSV, then open it in Excel. This is the only route that handles multi-section layouts, separate paid in and paid out columns, wrapped descriptions and scanned pages in one pass.
The check that matters
Whichever route you take, verify before you use the data. Add the opening balance to the sum of the amount column. If it equals the closing balance printed on the statement, the export is complete. If not, you are missing rows or carrying a sign error.
Fixing text that will not sum
If SUM returns zero, Excel is treating the amounts as text. The usual causes are worth knowing:
- Currency symbols left in the cell
- Thousands separators that do not match your locale
- A trailing minus sign rather than a leading one
- Non-breaking spaces copied out of the PDF