Convert Bank Statement to Excel
Upload your PDF bank statement and download a clean Excel-ready CSV in seconds. Every transaction extracted, dated, and automatically sorted into spending categories.
Upload your bank statements
PDF, JPG or PNG · multiple files supported
Free·No signup·PDF deleted after analysis
See the difference
From messy PDF to clean spreadsheet
Before
bankstatement.pdf
After
bankstatement.xlsx
What your Excel export looks like
A clean 4-column CSV you can open in Excel, Google Sheets, or Numbers instantly.
What to do with your Excel file
Once you have your CSV, here are the four most useful things to do with it.
1
Sum spending by category
=SUMIF(D:D,"Groceries",C:C)Paste into any empty cell — swap "Groceries" for any other category. Returns the total spent in that category for the month.
2
Build a pivot table breakdown
Insert → Pivot Table → Category to Rows, Amount to ValuesThe fastest way to see your full monthly spending breakdown. Takes under 30 seconds and updates automatically if you add more rows.
3
Import into accounting software
QuickBooks: Banking → Import Transactions → CSVWorks with QuickBooks, Xero, Wave, and FreshBooks. Our 4-column format maps directly to the standard import fields these tools expect.
4
Chart your spending
Select data → Insert → Chart → Pie or BarA category pie chart gives you an instant visual of where your money went. Useful for presentations, budget reviews, or just understanding your own habits.
Why convert your bank statement to Excel?
✓ Budget tracking
Import into your own spreadsheet budget and track spending without manual entry.
✓ Tax preparation
Quickly find deductible expenses — business costs, charitable donations, medical.
✓ Loan applications
Many lenders now accept CSV bank statements as proof of income and cash flow.
✓ Accounting software
Import into QuickBooks, Xero, Wave, or any accounting tool that accepts CSV.
vs. copying transactions manually
Manual copy-paste
✗Hours of tedious work
✗Typos and errors
✗No categories
✗No insights or charts
✗Still need to format columns
This converter
✓Done in under 30 seconds
✓AI-accurate extraction
✓Auto-categorized (19 categories)
✓Sankey chart + savings insights
✓Ready-to-use CSV format
Frequently asked questions
What columns does the Excel file contain?+−
Four columns: Date (MM/DD format), Description (the merchant name exactly as printed on your statement), Amount (positive for deposits, negative for withdrawals), and Category (AI-assigned spending category). All 19 categories are used: Groceries, Dining, Transport, Shopping, Housing, Utilities, Subscriptions, Healthcare, Entertainment, Travel, Business, Income, Transfers, ATM, Fees, Insurance, Education, Personal Care, and Other.
How do I calculate total spending by category in Excel?+−
Use a SUMIF formula: =SUMIF(D:D,"Groceries",C:C) — replace "Groceries" with any category name to get that category's total. Or create a Pivot Table in 30 seconds: select all rows, go to Insert → Pivot Table, drag Category to Rows and Amount to Values. This instantly shows your full monthly spending breakdown.
Can I import the CSV into QuickBooks, Xero, or Wave?+−
Yes. In QuickBooks: Banking → Import Transactions → CSV, then map Date, Description, and Amount columns. In Xero: Accounts → Bank Accounts → Import Statement. In Wave: Banking → Connect Account → Upload Statement. Our column names are standard so most accounting tools accept the file with minimal mapping.
Does the export include opening and closing balance?+−
The CSV focuses on individual transactions. Opening and closing balances are not included as rows. To verify: sum the Amount column — the difference between your statement's opening and closing balance should match the net total of all transactions.
Can I combine multiple months into one Excel file?+−
Yes. Each PDF generates a separate CSV. To combine: open both files in Excel, copy all transaction rows from the second file, and paste below the first file's rows. Both use the same 4-column format so they align perfectly. Sort by the Date column afterward to get chronological order across months.
Which banks are supported?+−
Any bank worldwide that provides PDF statements — Chase, Barclays, HSBC, Deutsche Bank, BNP Paribas, ING, Santander, HDFC Bank, Commonwealth Bank, and 10,000+ more. Every bank formats their PDF differently, but our AI normalizes all of them into the same clean 4-column Excel format regardless of which bank issued the statement.
Convert your bank statement to Excel — free
Upload your PDF and download a clean CSV in under 30 seconds.
Convert Bank Statement Free →