Convert a bank statement to Excel
Upload the PDF statement, check the extracted rows, and download an .xlsx file where every transaction is a row with the statement's own columns: date, description, amount and balance. Then sort, filter and total it like any spreadsheet.
How to convert a PDF bank statement to Excel
- 1.Download the statement as a PDF from your online banking.
- 2.Drop the PDF into the converter on this page. Enter the password if the PDF asks for one.
- 3.Check the rows in the preview. The first 5 pages are free.
- 4.Choose Excel and download the .xlsx file.
What the Excel file looks like
The same sample statement in each format. Switch to compare.
Excel
A standard .xlsx workbook with one row per transaction.
Best for: Analysis, pivot tables, loan and tax paperwork.
Bank statement to Excelharbor-pine-sep-2026.xlsx
Sample
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Date | Description | Amount | Balance |
| 2 | 2026-09-01 | Card purchase · Adobe Creative Cloud | −59.99 | 8,352.38 |
| 3 | 2026-09-02 | Stripe transfer · ST-7Q2KX | 2,486.50 | 10,838.88 |
| 4 | 2026-09-03 | ACH debit · Gusto payroll | −4,120.00 | 6,718.88 |
| 5 | 2026-09-05 | Check 1043 | −1,850.00 | 4,868.88 |
| 6 | 2026-09-09 | Card purchase · AWS EMEA | −218.77 | 4,650.11 |
| 7 | 2026-09-12 | Deposit · Mobile check | 1,200.00 | 5,850.11 |
CSV
Plain comma-separated rows any tool can import.
Best for: Importing into accounting software, budgeting apps and databases.
Bank statement to CSVharbor-pine-sep-2026.csv
Sample
Date,Description,Amount,Balance
2026-09-01,Card purchase · Adobe Creative Cloud,-59.99,8352.38
2026-09-02,Stripe transfer · ST-7Q2KX,2486.50,10838.88
2026-09-03,ACH debit · Gusto payroll,-4120.00,6718.88
2026-09-05,Check 1043,-1850.00,4868.88
2026-09-09,Card purchase · AWS EMEA,-218.77,4650.11
2026-09-12,Deposit · Mobile check,1200.00,5850.11Google Sheets
Sent straight to a sheet in your Google Drive.
Best for: Sharing with a bookkeeper or working from any browser.
Bank statement to Google SheetsHarbor & Pine · Sep 2026 (Google Sheets)
Sample
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Date | Description | Amount | Balance |
| 2 | 2026-09-01 | Card purchase · Adobe Creative Cloud | −59.99 | 8,352.38 |
| 3 | 2026-09-02 | Stripe transfer · ST-7Q2KX | 2,486.50 | 10,838.88 |
| 4 | 2026-09-03 | ACH debit · Gusto payroll | −4,120.00 | 6,718.88 |
| 5 | 2026-09-05 | Check 1043 | −1,850.00 | 4,868.88 |
| 6 | 2026-09-09 | Card purchase · AWS EMEA | −218.77 | 4,650.11 |
| 7 | 2026-09-12 | Deposit · Mobile check | 1,200.00 | 5,850.11 |
OFX
Open Financial Exchange, the bank-feed format.
Best for: QuickBooks, Xero, Sage and most accounting software.
Bank statement to OFXharbor-pine-sep-2026.ofx
Sample
OFXHEADER:100
DATA:OFXSGML
VERSION:102
…
<OFX>
<BANKTRANLIST>
<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20260901
<TRNAMT>-59.99
<FITID>02d4e626…
<NAME>Card purchase · Adobe Creative C
</STMTTRN>
<STMTTRN>
<TRNTYPE>CREDIT
<DTPOSTED>20260902
<TRNAMT>2486.50
<FITID>755d799c…
<NAME>Stripe transfer · ST-7Q2KX
</STMTTRN>
<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20260903
<TRNAMT>-4120.00
<FITID>c277c427…
<NAME>ACH debit · Gusto payroll
</STMTTRN>
</BANKTRANLIST>
<LEDGERBAL><BALAMT>5850.11
</OFX>harbor-pine-sep-2026.qfx
Sample
OFXHEADER:100
DATA:OFXSGML
VERSION:102
…
<OFX>
<SIGNONMSGSRSV1> … <INTU.BID>3000 …
<BANKTRANLIST>
<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20260901
<TRNAMT>-59.99
<FITID>02d4e626…
<NAME>Card purchase · Adobe Creative C
</STMTTRN>
<STMTTRN>
<TRNTYPE>CREDIT
<DTPOSTED>20260902
<TRNAMT>2486.50
<FITID>755d799c…
<NAME>Stripe transfer · ST-7Q2KX
</STMTTRN>
<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20260903
<TRNAMT>-4120.00
<FITID>c277c427…
<NAME>ACH debit · Gusto payroll
</STMTTRN>
</BANKTRANLIST>
<LEDGERBAL><BALAMT>5850.11
</OFX>Why convert to Excel
- Opens anywhere
- A standard .xlsx workbook that opens in Excel for Windows and Mac, Excel Online, Numbers, Google Sheets and LibreOffice.
- Check before you pay
- The first 5 pages convert free, so you can compare the rows against the PDF first.
- Several statements at once
- Convert up to 10 PDFs in one go, for example a year of monthly statements.
Five things to do with a bank statement in Excel
Once the rows are in a workbook, these are the jobs people usually do next.
- 1Turn the range into a table (Ctrl+T) so filters and totals follow new rows.
- 2Dates keep the format the bank printed. If Excel treats them as text, select the column and use Data → Text to Columns → Date (DMY or MDY) to turn them into real dates.
- 3Build a pivot table: Insert → PivotTable, Description in Rows, Amount in Values (Sum), then sort to see your biggest payees. Add a Month column with =TEXT(A2,"yyyy-mm") to split it by month.
- 4Use SUMIFS on the amount column to split money in and money out for a tax return.
- 5To combine a year of statements from the same bank, save each converted file in one folder and use Data → Get Data → From File → From Folder to stack them into one table.
Popular banks
All banksOther formats
- Bank statement to CSV · Importing into accounting software, budgeting apps and databases.
- Bank statement to Google Sheets · Sharing with a bookkeeper or working from any browser.
- Bank statement to OFX · QuickBooks, Xero, Sage and most accounting software.
- Bank statement to QFX · Quicken for Windows and Mac.
Excel questions
Can I open the file in Excel for Mac or Excel Online?
Yes. The download is a standard .xlsx workbook that opens in Excel for Windows, Excel for Mac, Excel Online, Numbers and LibreOffice.
Can I convert a bank statement to Excel for free?
Yes, for short statements. The first 5 pages convert free with no signup and no card. A free account lets you download the .xlsx and adds 5 free pages a day. Longer statements cost from $2.99 each ($2.99 for up to 10 pages, then $0.20 a page), or from $19.00 a month on a yearly plan.
Will it work with my bank?
BankConv works with statements from 1,000+ banks. It reads the table on the page, so most text-based and scanned PDF statements convert.
Does BankConv change the transaction descriptions?
No. Each description is kept as the statement prints it, so you can match it against invoices, receipts or your own payee list.
Can I convert a password-protected statement to Excel?
Yes. Enter the PDF password when the converter asks for it; it is used to open the file.
Your statement's data
Deleted after 24 hours
Your PDF and its converted files are deleted automatically. Account owners can choose 48 or 72 hours instead.
Read only to extract transactions
Your statement is read (with OCR for scans) to pull out the transaction rows you download.
Encrypted in transit
Uploads and downloads use HTTPS (TLS).
Passwords never stored
The password of a protected PDF is used once to open the file.
No bank login
BankConv works from the PDF you download, never from a connection to your bank.