How to export your bank statement as a CSV file
Nearly every bank can export your transactions as a CSV file — a plain spreadsheet of dates, descriptions, and amounts that budgeting tools can read. The option is rarely where you would expect it, and each bank names it differently. These guides show exactly where to click, what the file looks like, and how to fix the problems people run into most.
What is a CSV file, and why do budgeting tools want one?
CSV stands for comma-separated values. It is the plainest possible spreadsheet: one row per transaction, with columns for the date, the merchant, and the amount. Because it contains no formatting or passwords, any tool can read it — which is why it has become the standard way to move your own financial data between services.
A PDF statement, by contrast, is a picture of a document. It looks right to a human but requires error-prone text extraction for software to read, which is why most budgeting tools ask for CSV instead.
Why export a CSV instead of linking your bank account?
Most budgeting apps ask you to hand over your online banking username and password, or connect through an aggregator that stores an ongoing link to your account. A CSV export avoids that entirely: you download a file of transactions that already happened, and nothing gains standing access to your account. Nothing can move money, and revoking access is as simple as not uploading another file.
The trade-off is honest — CSV means updating manually rather than syncing automatically. For people who would rather not share bank credentials with a third party, most consider that a fair exchange.
Common problems with bank CSV exports
The download gave me a PDF instead of a CSV
You most likely chose “Statements” rather than “Activity” or “Transactions”. Statements are fixed monthly documents published as PDFs; activity is the live transaction list, which is what exports as CSV.
My bank offers .qbo, .qfx, or .ofx — are those the same?
No. Those are Quicken and QuickBooks formats. They contain similar data in a different structure, and most budgeting tools cannot read them. Always choose the option that says CSV or “comma separated”.
The file looks like nonsense when I open it
That is expected — a CSV is raw text. Open it in a spreadsheet program to see it as a table, or simply upload it to a budgeting tool, which reads the underlying format directly.
I cannot find the export option in my banking app
Almost no mobile banking app supports CSV export. Sign in from a desktop browser instead, where the option is usually near the transaction list rather than in the main menu.
My export is missing recent transactions
Pending transactions often do not appear in exports until they clear, which typically takes one to three business days. Wait for them to post, then export again.
Fynnap is an independent budgeting tool and is not affiliated with, endorsed by, or connected to any bank listed on this page. Bank websites change over time; if a menu has moved, look for any option labelled “Download”, “Export”, or “Account activity”.