Bank statement to Excel
Turn a PDF bank statement into a working Excel spreadsheet. Every transaction is split into Date, Description, Amount and Balance columns, with amounts as real numbers you can sum. Processed in your browser, never uploaded.
Drop your PDF bank statement here
or click to choose a file, converts to Excel in seconds
100% private · never uploadedWorks with statements from
Convert a bank statement to Excel in three steps
No install, no upload, no waiting on a server — the whole thing happens in this tab.
- 1
Drop in your PDF
Drag a PDF bank statement onto the converter, or click to choose one.
- 2
We extract the transactions
Dates, descriptions, amounts and balances are detected in your browser.
- 3
Download Excel or CSV
Preview the table, then export a clean spreadsheet in one click.
| Date | Description | Amount | Balance |
|---|---|---|---|
| 03/04 | Payroll — ACME CORP | +2,450.00 | 8,912.36 |
| 03/06 | Whole Foods Market | −84.19 | 8,828.17 |
| 03/09 | Transfer to Savings | −500.00 | 8,328.17 |
| 03/12 | Shell Gas Station | −52.40 | 8,275.77 |
A real four-column export — the same layout for every bank.
Built around one idea: your statement is yours
A converter that treats your most sensitive document with the privacy it deserves.
Private by design
Your PDF is parsed entirely in your browser with JavaScript. It is never uploaded to a server — your financial data never leaves your device.
Clean Excel & CSV
Get a tidy table of date, description, amount and balance, ready for Excel, Google Sheets, or import into accounting software.
No signup to start
Drop a file and download the result. No account, no email, no watermark on your first conversions.
Works with most banks
Layout-based extraction handles the common statement formats used by Chase, Bank of America, Wells Fargo, Capital One, and hundreds more.
Pick the output your workflow expects
The same private, in-browser conversion every time.
Convert bank statement to Excel
Export a clean .xlsx workbook with numeric amounts, ready for pivots and formulas.
Bank statement to Excel
See how transactions map into Date, Description, Amount and Balance columns.
Convert bank statement to CSV
Import-ready CSV for QuickBooks, Xero and Wave bookkeeping.
What a bank statement CSV contains
See the CSV columns and delimiter, then open it in Excel or Sheets.
Bank statement to OFX
The open banking format Xero, Wave, Quicken and GnuCash import directly.
Bank statement to QIF
For Quicken, GnuCash, Moneydance, MoneyMoney and Banktivity.
From a locked PDF to a spreadsheet that works
A bank statement in Excel is a completely different thing from a bank statement in PDF. The PDF is a picture of a page: the numbers are placed by position, not stored in columns, so the moment you try to use them, they fall apart. An Excel file holds the same transactions as real rows and columns, where a date is a date, an amount is a number, and a total is one formula away. This page takes you from the first to the second.
ConvertFin reads the transactions out of your PDF and writes them into a native Excel workbook (.xlsx). You do not get a flattened image or a wall of text, you get a table you can sort, filter, total and pivot. And because the amounts come through as numeric values rather than text, a SUM just works, instead of Excel refusing to add cells it thinks are words.
The columns you get in the Excel file
Every statement is written to the same predictable four-column structure, one row per transaction.
- Date. One column, so you can sort chronologically or filter to a single month.
- Description. The merchant or payee text as it appears on the statement, kept on one row.
- Amount. The debit or credit as a real number, ready for formulas.
- Balance. The running balance where your bank prints one. Card statements such as American Express carry no balance, so that column may be empty for those.
What you can do once it is in Excel
This is the whole reason to convert. With the transactions in a real spreadsheet, the analysis is trivial:
- Drop a
SUMat the bottom of the Amount column to total spending or check the statement footings. - Build a pivot table to group spending by month or by merchant in a few clicks.
- Use
SUMIFto add up everything from one payee, or filter the Description column to isolate business charges. - Add conditional formatting or a chart to see where the money actually goes.
Because the export is a standard .xlsx workbook, all of this works the same in Microsoft Excel, Google Sheets, Apple Numbers and LibreOffice.
Excel or CSV — which should you export?
Pick Excel when a human is going to read and analyse the file: amounts stay numeric, dates stay dates, and everything is ready to sort and total. Pick CSV when a program is going to read it — most accounting tools import CSV cleanly. If you are importing into QuickBooks, Xero or Wave, use convert bank statement to CSV, and if you want to see exactly what a statement CSV contains first, read bank statement to CSV.
Ready to run one? The converter above handles the extraction privately in your browser. For the action-first version with troubleshooting see convert bank statement to Excel, or follow the step-by-step guide screen by screen.
Frequently asked questions
Why can I not just copy and paste my PDF statement into Excel?
A PDF has no real columns. The text is placed on the page by position, not stored as a table, so when you paste it the dates, descriptions and amounts collapse into the wrong cells. Converting rebuilds the actual table instead of copying the layout.
What does each column in the exported spreadsheet hold?
Date holds the transaction date, Description holds the merchant or payee text, Amount holds the debit or credit, and Balance holds the running balance where your bank prints one. One row per transaction, four columns.
Is the export a real .xlsx workbook or a renamed CSV?
A genuine .xlsx workbook. Because it is a native Excel file rather than plain text, it keeps real cell types, so dates stay dates and amounts stay numbers rather than being re-parsed on open.
Will dates stay as dates and amounts stay as numbers?
Yes. Amounts and balances are written as numeric values and dates as date values, each in its own column, so Excel, Google Sheets and Numbers treat them correctly with no reformatting.
Can I build pivot tables and use SUMIF on the result?
Yes. Since the amounts are real numbers in a single column, a pivot table, SUMIF, conditional formatting or a chart all work straight away, the same as any spreadsheet you built by hand.
Should I export Excel or CSV?
Export Excel when a person will read and analyse the file, since numbers and dates keep their types. Export CSV when you are importing into accounting software such as QuickBooks, Xero or Wave.
Is my statement uploaded anywhere?
No. The PDF is parsed locally in your browser with pdf.js, so your statement never leaves your device and nothing is stored on a server.
Need to convert statements in bulk?
Upgrade to Pro for unlimited conversions and batch processing.
See pricing