Bank Statement to Excel Converter
Turn a bank statement file (CSV, text-based PDF, QBO, QFX, OFX or QIF) into a clean Excel workbook with real dates and numbers.
Drop your bank file here or choose a file
CSV, Excel, PDF, QBO, QFX, OFX or QIF · stays on your device
No signup. Your file never leaves your computer. Works in your browser.
How to convert a bank statement to Excel
- Download your statement file From your bank's website, download the transactions as CSV, Excel, QBO (QuickBooks), QFX (Quicken), OFX or QIF, or use the statement PDF.
- Drop it into the converter The file is read in your browser. For CSV and Excel files, the columns are matched for you, and known bank layouts are recognized.
- Check the transactions Fix or delete rows, search, and limit the dates if you only need part of the statement.
- Choose Excel and the amount layout One Amount column (minus for money out), or separate Money out and Money in columns.
- Download the workbook You get an .xlsx file with dates as real date cells and amounts as numbers, ready to sort, filter and total.
How to use the workbook
Microsoft Excel
- Open the file Double-click the .xlsx file. The header row already has filters, so you can sort or filter any column.
- Total the amounts Select the Amount column to see the sum in the status bar, or filter by description first to total one payee.
Google Sheets
- Import the file Choose File › Import › Upload, pick the .xlsx file and choose to create a new spreadsheet.
- Check the columns Dates and amounts come in as dates and numbers, so sorting and sums work right away.
Apple Numbers
- Open the file Open the .xlsx file in Numbers; each column keeps its name and type.
What you get in the workbook
One sheet named Transactions with the columns Date, Description, Amount (or Money out and Money in), Memo and Check number, plus Category when the file has categories. Dates are real date cells shown as MM/DD/YYYY, amounts are numbers with two decimals and a minus sign for money out, and the header row has filters turned on. The Description and Memo columns are wide enough to read without resizing.
Why not open the bank’s file in Excel directly
You can open a bank CSV in Excel, but the result depends on the bank’s layout: summary lines above the table, dates
Excel reads as text, amounts written as (12.50) or 12.50-, and long reference numbers Excel turns into
scientific notation or strips of leading zeros. QBO, QFX, OFX and QIF files don’t open as a table at all.
The converter reads each format properly first. It finds the header row, skips summary lines, reads every common date and amount style, and then writes a workbook where every cell has the right type. It is also a quick way to look inside a QuickBooks or Quicken file without either program.
Statement files from any bank
- CSV and Excel exports from any bank: the columns are matched by their names and contents. Layouts from Chase, Bank of America, Wells Fargo, Citi, Capital One, American Express, Discover, PayPal, Stripe and Venmo are recognized automatically, including the right signs for card files.
- QBO and QFX files (QuickBooks and Quicken downloads) and OFX files, in both the older SGML form and the newer XML form.
- QIF files from Quicken and other money apps, including Quicken’s own date styles.
- Text-based PDF statements, read line by line; you compare the result with the statement before downloading. Scanned statements can’t be read.
Supported banks and file layouts
Any bank's CSV or Excel file
The converter finds the header row (even below bank names and account summaries), matches columns by name and by content, and handles one signed amount column, separate debit and credit columns, or an amount with a DR/CR column. Dates like 01/05/2026, 2026-01-05 and Jan 5, 2026 and amounts like (1,234.56) or 1234.56- are all read.
Known layouts, picked automatically
- American Express card · Date, Description, Card Member, Account #, Amount, … 8 more
- Apple Card · Transaction Date, Clearing Date, Description, Merchant, Category, … 3 more
- Bank of America checking or savings · Date, Description, Amount, Running Bal.
- Bank of America credit card · Posted Date, Reference Number, Payee, Address, Amount
- Barclays credit card · Transaction Date, Description, Category, Amount
- Capital One 360 checking or savings · Account Number, Transaction Description, Transaction Date, Transaction Type, Transaction Amount, Balance
- Capital One credit card · Transaction Date, Posted Date, Card No., Description, Category, … 2 more
- Charles Schwab Bank checking · Date, Status, Type, CheckNumber, Description, … 3 more
- Charles Schwab Bank checking (older layout) · Date, Type, Check #, Description, Withdrawal (-), … 2 more
- Chase checking · Details, Posting Date, Description, Amount, Type, … 2 more
- Chase credit card · Transaction Date, Post Date, Description, Category, Type, … 2 more
- Citi credit card · Status, Date, Description, Debit, Credit
- Discover card · Trans. Date, Post Date, Description, Amount, Category
- Mercury transactions · Date (UTC), Description, Amount, Status, Source Account, … 9 more
- PayPal activity · Date, Time, TimeZone, Name, Type, … 11 more
- PNC checking or savings · Transaction Date, Transaction Description, Amount, Balance
- SoFi checking or savings · Date, Description, Type, Amount, Current balance, Status
- Square transactions · Date, Time, Time Zone, Gross Sales, Discounts, … 44 more
- Stripe balance report · balance_transaction_id, created_utc, available_on_utc, currency, gross, … 4 more
- USAA checking or savings · Date, Description, Original Description, Category, Amount, Status
- Venmo statement · ID, Datetime, Type, Status, Note, … 16 more
- Wells Fargo · 5 columns, no header row
Each layout was checked against the bank's own help pages or real sample files. If your bank changes its layout, the converter still reads the file by its column names.
Common problems and fixes
- My statement is a PDF
- Drop it in: text-based PDF statements are read line by line, and you tick a box to confirm you compared the transactions with the statement before downloading. Scanned statements can't be read. A CSV or Excel download from your bank is more reliable; see how to download a CSV from your bank.
- Amounts show as text in Excel
- Use the Excel download rather than CSV; its amounts are number cells with two decimals.
- Dates show as
- The column is too narrow for the date. Widen the column; the date itself is fine.
- Months and days are swapped
- Your bank's file may write dates day first. Choose Day first under the date format in the converter (it asks when a file could be read both ways), then download again.
- Opening balance and total lines are missing
- The converter leaves out summary lines, such as opening balances and totals, because they aren't transactions. Show skipped rows lists them.
- The file has several accounts
- QBO, QFX, OFX and QIF files can hold more than one account. The converter lists them; choose one, download it, then choose the next.
Excel workbook vs CSV
| Excel (.xlsx) | CSV | |
|---|---|---|
| Dates | Real date cells | Text that the spreadsheet app has to read |
| Amounts | Number cells with two decimals | Text with a dot for cents |
| Filters on the header row | Yes | No |
| Opens in | Excel, Google Sheets, Numbers | Any spreadsheet or text editor, and most apps |
| Best for | Reviewing, sorting and totals | Importing into another program |
Frequently asked questions
How do I convert a bank statement to Excel?
Drop the statement file into the converter above, check the transactions, keep Excel selected and download.
Which files work?
CSV, TSV and TXT exports, Excel (.xlsx, .xls), text-based PDF statements, and QBO, QFX, OFX and QIF files from any bank.
Can I keep money out and money in in separate columns?
Yes. Under Amount columns, choose Money out and Money in columns before you download.
Does the workbook keep categories?
Yes, when the file has them (QIF files and CSV files with a category column). They go in a Category column.
Can I convert a QBO file to Excel?
Yes. Drop the QBO file in; it is read the same way as a QFX or OFX file. The QBO to CSV converter does the same with more QBO-specific help.
Is my statement uploaded?
No. The file is read and converted in your browser and never leaves your computer.
Related tools
Last updated · EmproIT