How to export your transaction history from your bank

What file formats can I download my bank transactions in?

Banks usually offer one to three of these, and they carry different amounts of information.

Should I download my transactions as CSV or PDF?

Take the CSV whenever it is offered. You can open it, see exactly what you have, fix it by hand, and almost anything that imports transactions accepts it. Its weakness is that there is no agreed set of columns, so you usually have to say which column is the date, which is the amount, and which way the signs run.

Take the PDF statement when there is no export button, which happens more often than it should. It is the universal fallback, because every bank produces statements, but its data is laid out for reading rather than for machines, so getting it into a spreadsheet means copying and tidying.

If your tool asks for OFX or QFX by name, use that instead, since a unique ID per transaction means fewer duplicates when date ranges overlap.

Where is the download or export button in online banking?

Almost always in one of two places: the account's own transaction list, near the date filter or search box, as a small download icon or short link; or a separate documents area, often called statements and documents, which usually holds PDFs rather than spreadsheet files.

The wording differs by bank and there is no convention. Look for Export, Download, Download transactions, Export data, Save, or a menu of three dots beside the transaction list.

Two things catch people out. Many banks export only what is currently filtered or on screen, so set the date range before you click. And the mobile app often has no export at all, so sign in on a computer before deciding your bank has none.

How far back do bank transaction exports go?

It varies a lot, and there is no rule to rely on. Downloadable transaction files are often limited to a short window, anything from a few months to a couple of years being common. The statement archive in the same online banking usually reaches back further, because statements are a record the bank has to keep available.

An automatic bank feed, the live connection an app or a spreadsheet makes to your account, normally goes back less far than either. The bank's interface exposes only a limited window of history to outside tools, and in some countries the permission you grant is time-limited and has to be renewed. A feed showing ninety days is not hiding anything; it is showing everything it was given.

Export in chunks if there is a cap, and export what you care about before you close an account, since online access normally ends with it.

What can I do if my bank has no export option at all?

Start with the PDF statements, which exist even where an export button does not. In most countries a bank holding a payment account has to give you a periodic statement of its transactions, though the exact obligation and how long old statements stay available differ by country and by bank.

Then test whether the PDF holds real text: try to select a line with your cursor. If it highlights, you can copy a page into a spreadsheet and split it into columns. If nothing highlights, it is a scan, with no text to extract without text recognition.

Screenshots are a last resort, worth taking if the alternative is losing the data, but you will be retyping from them anyway. Typing one month by hand is more realistic than it sounds: you need only the date, the amount and enough description to recognize it. A year is not worth typing.

What do the columns in a bank CSV file actually mean?

There is no standard, but the same fields turn up under different names.

• Date, usually the posting date, the day the bank settled the item rather than the day you paid. Some files also carry a value date.
• Description, also called Narrative, Details, Payee or Merchant: one messy string holding a merchant name, a city, a reference and a card's last four digits.
• Amount, either one signed column where money out is negative, or two columns, often debit and credit, both positive, with the column giving the direction.
• Balance, the running balance after each transaction. The most useful column in the file, because it lets you prove nothing is missing.
• Type, a short code such as card, transfer, direct debit or fee, plus Reference, Currency, and for foreign purchases the original amount.
• Category, a guess the bank made, often wrong and rarely worth importing.

No two banks agree because CSV is a container, not a standard: it says values are separated by commas and nothing about which values, in what order, or in what format. If your totals come out backwards, a sign convention is almost always why.

Why does my bank's CSV look wrong when I open it in a spreadsheet?

Usually because it was written for a different regional convention than your spreadsheet expects. In much of continental Europe the decimal separator is a comma and the thousands separator a period, so 1.234,56 means the same number an American or British bank would write as 1,234.56.

Because the comma is busy inside the numbers, a file called a CSV from a European bank is very often separated by semicolons instead. A spreadsheet set to the American convention then reads 1.234,56 as text, or silently as 1.234. In a genuinely comma-separated file, a comma inside a number splits it across two cells and shifts every column after it.

The fix is to import rather than double-click: use your spreadsheet's text-import option and set the delimiter and decimal separator explicitly. Repairing by hand, remove the thousands separators first and only then turn the decimal comma into a period. Check dates too, since 03/04/2026 is March 4 under one convention and April 3 under another.

How do I check that an export is complete before I rely on it?

Compare it with the statement covering the same dates, because an export quietly missing a week looks completely normal.

The strongest check uses the balance column. Take the balance on the first row and on the last row, then add up every amount in between; the total should equal the difference exactly. If it does not, rows are missing or signs are inverted. With no balance column, total the money in and out and compare both with the statement's own summary.

Then look at the edges. Exports often include the start date but not the end date, or the reverse, leaving a one-day hole when you stitch files together. Some banks cap the rows in one file and stop without saying so, so confirm the oldest row is as old as the range you asked for.

Some budgeting apps run this check at import and flag a running balance that does not line up; Tally is one way to do it. A spreadsheet does the same job.

Is it safe to download and keep a file of my transactions?

Creating the file is harmless to the account: it does not change anything or affect your credit, though some banks will send you a security alert that a download happened. What deserves care is what happens to it afterward, because a year of transactions is a record of where you live, where you shop, who you pay, what you earn and which weeks you were away from home. Treat it as a document, not as junk.

Download it on a device you control, not a shared or work computer. Do not email it to yourself, where it will sit for years, and do not upload it to an unknown website offering to convert or tidy it. When done, delete it from your downloads folder and empty the trash, because the forgotten second copy is the usual problem.

Importing it into a budgeting app on your phone and then clearing the download off the computer is one way to handle it; Tally is one of those, though the habit matters more than the tool.

This guide explains how the export works. It is not financial advice.