How to convert a bank statement to Excel
Pick the method that fits what your bank gave you. If all you have is a PDF, convert it below in about a minute.
No statement to hand? Try a sample: ·
Method 1: export a CSV from online banking
Most banks let you download recent transactions as CSV, which Excel opens directly. It is the cleanest route when it exists, but the window is often limited (commonly a few months to about a year and a half, depending on the bank and account), and the export has no opening or closing balance, so you cannot prove it is complete.
Method 2: copy and paste from the PDF
Selecting a table in a PDF and pasting it into Excel usually puts each line in one cell or splits descriptions across columns. Amounts with trailing minus signs or CR/DR suffixes arrive as text, so SUM returns 0. It works for a handful of rows and is not worth it for a full statement.
Method 3: convert the PDF
A converter reads the position of each word on the page, rebuilds the columns, joins descriptions that wrap and writes real dates and numbers. RowBalance does this in your browser, then compares opening balance plus transactions with the closing balance so that a missing row is visible before you rely on the sheet.
Check before you trust it
Whichever method you use, add up the money in and money out and compare with the totals printed on the statement. If your converter does not do this for you, do it by hand: one missed row is enough to make a reconciliation fail.
How to do it
- Download your statements as PDF from online banking (Statements and documents, or similar).
- Drop them into the converter above.
- Look for the green "Balanced" badge on each statement and fix any red row.
- Download Excel (.xlsx).
Excel and CSV are free for up to 5 pages a day. QuickBooks, Xero and OFX files and batch conversion are on paid plans, from a $9 one-off pass: see pricing or go back to the converter.
Questions
What is the easiest way to convert a bank statement to Excel?
If your bank offers a CSV download for the dates you need, use it. If you only have a PDF statement, use a converter that checks the balances, so you know nothing was dropped.
Why do my numbers paste as text?
PDFs store amounts as drawn text. Trailing minus signs, currency symbols and thousands separators stop Excel treating them as numbers. A converter normalises them to real numeric cells.
Can I convert a scanned statement?
RowBalance reads text-based PDFs. A scan or photo is an image and needs OCR first, which RowBalance does not do yet.