Downloading your transactions is simpler than it sounds. You log in, find your account activity, look for a download or export button, choose a date range and file format, and save the file. The whole thing takes about three minutes once you know where to look.

The catch is that every bank labels things differently, puts the button in a different place, and has its own quirks about date ranges and formats. Below is a step-by-step breakdown for the most common banks, followed by an explanation of what the file actually contains and how to use it.

Step-by-Step by Bank

Chase Checking and Credit Cards
  1. 1Log in at chase.com and select the account you want to export.
  2. 2Scroll to your transaction list and look for the download icon, it sits near the top right of the transaction table.
  3. 3A panel will open. Change the File Type dropdown from the default QFX/Quicken format to CSV or Spreadsheet. This step is easy to miss and will save you trouble.
  4. 4Select your date range and click Download.
Watch out: Chase defaults to QFX format, which is designed for Quicken software and won't open cleanly in Excel. Always switch to CSV before downloading. Credit card exports and checking account exports are separate files, so if you have both, download each account individually.
Bank of America Checking and Credit Cards
  1. 1Log in at bankofamerica.com and open your account.
  2. 2In the transaction list, look for a Download Transactions link near the top right. It's labeled differently from most banks, so if you're looking for "Export" you won't find it.
  3. 3Select your date range and choose Microsoft Excel Format or CSV from the dropdown.
  4. 4Click Download Transactions.
Watch out: Bank of America limits exports to 60 days at a time. If you need a full year of history, you'll need to download in chunks and combine the files. Plan for two or three downloads depending on your date range.
Wells Fargo Checking and Savings
  1. 1Log in at wellsfargo.com and open your account.
  2. 2Click the Download Account Activity link above your transaction list.
  3. 3Set your date range. Wells Fargo allows up to 18 months of history in a single export, which is more generous than most banks.
  4. 4Set the format to Comma Delimited (.csv) and click Download.
Watch out: Wells Fargo calls it "Comma Delimited" rather than CSV. Same file, different label. The exported file also includes a check number column that will be empty for most transactions, which is normal.
Capital One Checking and Credit Cards
  1. 1Log in at capitalone.com and go to your account.
  2. 2Open the transaction list and look for a Download button or link, usually near the transaction filter area.
  3. 3Choose your date range and select CSV as the format.
  4. 4Click Download.
Watch out: Capital One's interface varies between checking and credit card accounts. If you don't see a download button on the transactions page, try going to the account details or statements section and looking there.
Citibank Checking and Credit Cards
  1. 1Log in at citi.com and select your account.
  2. 2Navigate to your transaction history and look for a Download or Export option near the transaction list.
  3. 3Select your date range and choose CSV format.
  4. 4Click Download.
Watch out: Citi's online interface has changed several times in recent years, so the exact location of the export button may differ from what you see here. If you can't find it under transactions, check the account summary page or the statements section.
Credit Unions and Smaller Banks Varies by Institution
  1. 1Log in and navigate to your account's transaction history.
  2. 2Look for a Download, Export, or Save button near the transaction list. The label varies widely.
  3. 3If CSV isn't available, look for OFX or QFX options. These can often be converted to CSV, though the process adds a step.
  4. 4If you only see a PDF option, you're downloading a statement rather than a transaction export. That's a different format and requires different handling.
Watch out: Smaller institutions sometimes only offer PDF statements rather than CSV exports. If that's the case for your bank, you'll need to contact them directly to ask about transaction export options, which are sometimes available on request even if not prominently advertised.

What's Actually in the File

Once you open the CSV in Excel or a similar app, you'll see a spreadsheet with columns. The exact column names vary by bank but the data is essentially the same across all of them.

Column What It Contains Notes
Date The date the transaction posted to your account This is the posting date, not always the date you made the purchase. They can differ by a day or two.
Description The merchant name or transaction label These are often abbreviated or contain reference codes. "SQ *COFFEE HOUSE" is a Square payment at a coffee shop. They take some getting used to.
Amount How much was spent or received Banks handle this differently. Some use a single column with negative numbers for spending. Others use separate Debit and Credit columns. Check which format your bank uses before importing anywhere.
Category How the bank classified the transaction Not all banks include this. When they do, the categories are broad and inconsistent. Don't rely on them for anything detailed.
Balance Your account balance after that transaction Usually only present in checking account exports, not credit cards.
Check Number Check number if applicable Usually empty for most transactions. You can ignore this column.

Reading Your Transactions Like a Financial Picture

A CSV file full of raw bank data can look overwhelming at first. A few hundred rows of abbreviations and amounts isn't immediately meaningful. But once you understand the structure, it tells you quite a lot.

The description column is where most of the useful information lives. Banks abbreviate merchant names because of character limits, but patterns emerge quickly. Anything with "AMZN" is Amazon. "SQ *" followed by a name is a Square payment at a small business. "ACH" transactions are electronic transfers. "POS" means a point-of-sale purchase. Once you recognize the shorthand your own bank uses, the file becomes easy to read.

The amount column structure matters more than people realize. If your bank uses a single column where debits are negative numbers and credits are positive, that's straightforward. If it uses separate Debit and Credit columns, you'll have blank cells wherever the opposite transaction type applies. Knowing which format you're working with before you try to add things up saves confusion.

Sorting by amount is one of the fastest ways to understand your spending. Sort largest to smallest and your biggest single purchases surface immediately. Filter by description to find all transactions from a specific merchant and see exactly how often you shop there and how much you've spent in total. Most people are surprised by at least one thing they find.

A Few Things to Watch For

Pending transactions won't appear in your export. The file only includes transactions that have fully posted to your account. If you made a purchase yesterday, it may not be in today's export.

If you export overlapping date ranges across multiple downloads, you'll end up with duplicate transactions. When combining files, always check for rows that appear twice, particularly around the date boundaries.

Some banks include a header row with account information before the actual column headers. When you open the file in Excel, this can cause formatting issues. If your columns don't line up correctly, scroll to the top of the file and check whether there are rows above the actual headers that need to be deleted.

Transfers between your own accounts will appear as both a debit from one account and a credit in another. If you're combining exports from multiple accounts, you'll want to exclude these to avoid double-counting your income.

What to Do With the File

Once you have a clean CSV, you have a few options. You can work with it directly in Excel or Google Sheets, building your own categories and summaries. For people comfortable with spreadsheets, this works well and gives you complete control.

Alternatively, you can import it into a budgeting app that accepts CSV files. This gives you the visualization and tracking features of an app without needing to connect your bank account or share your credentials with anyone.

Lumio is built specifically for this workflow. You download your transactions from your bank the way this guide describes, import the file into Lumio, and your spending picture comes together automatically: categories, trends, debt tracking, savings goals. Your data stays on your device. No bank login required, no third party involved.

Available now for desktop

Import your transactions. Keep your data.

Download your transactions from your bank and import them into Lumio. No bank login. No third-party access. Everything stays on your device.

Try Lumio free