How to Convert Bank of America Statement to Excel or CSV (2026)

Bank of America provides some export tools through online banking, but they have date range limits and format issues that make them impractical for many use cases. If you need a full statement in spreadsheet form, particularly older ones, you will likely need to work with the PDF.

This guide covers every way to get your Bank of America transactions into Excel or CSV.

1. Export from Bank of America Online Banking

Bank of America lets you download transaction activity from the Activity page on their website.

Sign in at bankofamerica.com, go to your account, and look for the download option near recent transactions. Formats available include CSV and sometimes XLS.

Limitations:

Checking and savings: Up to about 18 months of transaction history.
Credit cards: Limited to approximately 12 months.
Transaction cap: Up to 3,000 transactions per download.
The CSV does not include running balances. If you need the balance column, you must use the statement PDF.
No transaction IDs are included in the CSV, which makes duplicate detection difficult if you download overlapping date ranges.
QFX/Quicken integration has been discontinued by Bank of America. Manual OFX download may still work on the website, but it is no longer officially supported.
Up to 7 years of monthly statement PDFs are available under Statements and Documents.

If the 18-month window and missing balance column are acceptable, the CSV export is the easiest route.

2. Copy-Paste from the PDF

Bank of America statement PDFs are text-based, so you can select and copy transaction data. The layout is relatively clean compared to some banks, but there are specific issues to watch for.

Common issues with Bank of America PDFs:

Separate debit and credit columns. BofA checking statements use distinct Withdrawals and Deposits columns rather than a single signed-amount column. When pasting into a spreadsheet, these often misalign.
Daily Balance Summary. At the end of each statement, Bank of America includes a section listing the account balance for every calendar day of the statement period. Generic copy-paste or PDF-to-Excel tools pull these as extra transaction rows, inflating the data.
Business account formatting uses separate debit and credit columns as well, with additional detail fields that complicate extraction.
Credit card statements organize transactions into multiple sections (Purchases, Cash Advances, Payments, Fees, Interest), each with its own sub-header. Copying the entire statement mixes section headers with transaction data.

For a single, short checking statement, copy-paste is doable. For credit card statements or anything with the Daily Balance Summary, it creates more cleanup work than it is worth.

3. Use a Converter Tool

A converter tool reads the PDF layout intelligently, distinguishing actual transactions from summary sections, headers, and daily balances.

Bankonomic converts Bank of America checking and credit card statement PDFs to Excel or CSV in seconds. It correctly separates withdrawals and deposits, ignores the Daily Balance Summary, and handles credit card section headers automatically.

How to Convert a Bank of America Statement

Go to bankonomic.com
Upload your Bank of America statement PDF
Bankonomic extracts all transactions automatically
Review the results in the built-in editor
Export to Excel or CSV

No signup is required. The free tier includes 5 pages per month.

If Bank of America has split your debit and credit amounts into separate columns, Bankonomic preserves this structure in the output, with each transaction showing either a debit or credit amount, ready for accounting software.

Which Option to Use

Situation	Best Option
Recent checking transactions (under 18 months)	BofA CSV export
Recent credit card transactions (under 12 months)	BofA CSV export
Older statements or full statement with balances	Converter tool (Bankonomic)
Statements with Daily Balance Summary	Converter tool (ignores summary rows)
Multiple months of data	Converter tool (batch upload)

FAQ

Can I export Bank of America transactions to Quicken?

Bank of America has discontinued their Quicken (QFX) integration. You can still download CSVs and import them manually, or convert PDF statements to a compatible format using a converter tool.

Why does my Bank of America spreadsheet have extra rows?

The Daily Balance Summary at the end of each statement lists a balance for every day of the period. If you copy-pasted or used a basic PDF tool, those daily balances are included as transaction rows. Use a converter like Bankonomic that filters these out automatically.

Does Bankonomic handle Bank of America business accounts?

Yes. Business accounts with separate debit and credit columns are supported. The output preserves the debit/credit structure.