Convert a bank statement PDF to Excel
Banks hand out statements as PDFs, but budgeting, tax returns, expense checks and bookkeeping all need the transactions in a spreadsheet. Retyping them is slow and error-prone. Converting the PDF gets every row into Excel in seconds.
Why convert statements to a spreadsheet
In a spreadsheet you can sort by amount, filter by shop, total a category, spot duplicate payments and paste figures into a self-assessment tax return or a mortgage affordability check. Accountants and bookkeeping tools like Xero and QuickBooks import CSV directly.
Bank statements are among the most sensitive files you have, with your account number, salary, spending and address. Most PDF-to-Excel websites upload them to a server. Think Pages reads the PDF inside your browser, so the statement never leaves your device.
Key benefits
- Real numbers, not textAmounts like £1,234.50, (12.00) and 15% become numbers you can add up, with their formats kept.
- Columns found for youDate, description, paid out, paid in and balance line up in their own columns, even on statements with no grid lines.
- Wrapped descriptions joinedWhen a description runs onto a second line, it's put back together in one cell.
- Excel or CSVGet an .xlsx with each page on its own sheet, or one CSV ready to import into accounting software.
How to convert a bank statement to Excel
- Download the statement from online banking as a PDF (not a scan or photo).
- Open PDF to Excel and add the statement. Add several months to combine them.
- Remove pages without transactions, such as terms and conditions.
- Press Export Excel file, or choose CSV to import into accounting software. Check the totals against the PDF.
Tips
- Statements downloaded from online banking work best. Scanned paper statements need text recognition (OCR), which is coming soon.
- Untick 'Each page on its own sheet' to get every transaction in one long list.
- Always compare the closing balance with the PDF before relying on the figures.
Questions
Can I convert a PDF bank statement to Excel for free?
Yes. Open PDF to Excel in Think Pages, add the statement and export. There's no sign-up, and the file stays on your device.
Is it safe to convert bank statements online?
With most sites, your statement is uploaded to their server. Think Pages converts it inside your browser, so it's never sent anywhere.
Will it work with my bank?
It works with most statements downloaded as PDFs from online banking, from UK high-street banks to card providers. Layouts vary, so check the result.
Tools for this job
More guides
- Work and adminCombine receipts into one PDF for your expense claimTurn receipt photos, PDF invoices and screenshots into one tidy PDF for your expense claim. Free, private and done in your browser, with no upload.
- Work and adminMake a PDF small enough to email or uploadReduce PDF file size so it fits email attachment limits (often 10 to 25 MB) and upload portals. Compress PDFs free in your browser without uploading them.
- Work and adminTurn your CV and cover letter into one PDFConvert a Word CV to PDF and combine it with your cover letter and certificates in one file for job applications. Free, private, in your browser.