Skip to main content

Bank CSV Guide

How to Download Your Bank Transactions as a CSV (2026)

A CSV is a simple spreadsheet file that any tax tool or accountant can work with. Most banks let you export one in under a minute. Here's exactly how to do it at every major bank, plus what to do with it once you have it.

Agnė, founder of Categorize My Expenses
Written by Agnė

Key Takeaways

  • Every major bank allows you to export transactions as a CSV file from their website, typically found under Account Activity or Transactions (not the Statements PDF section).
  • Chase defaults to QFX format, so you must manually change the file type dropdown to CSV. Bank of America limits exports to 60 days per download.
  • The CSV export option is often a small text link or icon near the transaction list, not a prominent button. It is easier to find on the desktop website than in the mobile app.
  • If a CSV looks garbled in Excel, use File > Open (not double-click), select Delimited, and choose Comma as the delimiter.

Banks update their interfaces regularly. These steps were accurate as of early 2026, but button names or menu locations may shift slightly.

Chase

  1. Log in at chase.com and select your checking or credit card account.
  2. Click “Download account activity” (the downward arrow icon near your transaction list). Not the statement PDF link.
  3. Set your date range. Chase allows up to 12 months at a time.
  4. Change the File Type dropdown to CSV. Chase defaults to QFX/Quicken format, so don't skip this step.
  5. Click Download.

Gotcha: If you only see “Statements,” you're in the wrong section. Look for “Account activity” or “Transactions” first.

Bank of America

  1. Log in at bankofamerica.com and go to your account.
  2. Click “Download Transactions” in the top-right area of the transaction list.
  3. Select your date range.
  4. Under File Type, choose Microsoft Excel or CSV.
  5. Click Download.

Gotcha: Bank of America limits exports to 60 days per download. For a full year, download in chunks.

Wells Fargo

  1. Log in at wellsfargo.com and open your account.
  2. Click the “Download Account Activity” link above your transactions.
  3. Choose your date range (up to 18 months available).
  4. Set the format to Comma Delimited (.csv).
  5. Click Download.

Gotcha: Wells Fargo calls it “Comma Delimited” instead of CSV. Same thing.

Capital One

  1. Log in at capitalone.com and select your account.
  2. Click “Download Transactions” near the top of the transaction list.
  3. Set your date range.
  4. Choose CSV as the file format.
  5. Click Download.

Gotcha: For Capital One credit cards, make sure you're looking at “Transactions,” not “Statements.” The statements section only gives you PDFs.

Citi

  1. Log in at citibankonline.com and go to your account.
  2. Click “View Transactions” or navigate to your transaction history.
  3. Look for the “Export” or “Download” link. It's usually a small text link, not a big button.
  4. Select CSV and your date range.
  5. Click Export.

Gotcha: Citi's export link is easy to miss. It's typically a small text link near the top-right of the transaction table, not a prominent button.

US Bank

  1. Log in at usbank.com and select your account.
  2. Click “Transaction History” if you're not already viewing it.
  3. Click the “Export” or “Download” icon near the search/filter options.
  4. Choose CSV and set your date range.
  5. Click Download.

Gotcha: US Bank may default to a short date range (30 days). Expand it manually to cover the full period you need.

PNC

  1. Log in at pnc.com and open your account.
  2. Go to “Transaction Activity.”
  3. Click the “Export” button near the top of the transaction list.
  4. Select CSV from the format options and set your dates.
  5. Click Export.

Gotcha: PNC's export option may only appear after you've loaded transactions with a date filter. If you don't see it, try adjusting the date range first.

Discover

  1. Log in at discover.com and select your card account.
  2. Go to “Statements” and then look for “Download Activity” or “Export.”
  3. Choose your date range.
  4. Select CSV format.
  5. Click Download.

Gotcha: Discover mixes statements and transaction exports in the same section. You want the activity/transaction export, not the PDF statement download.

What If My Bank Isn't Listed?

The process is nearly identical at every bank. Follow this general pattern:

  1. Log in to your bank's website (the full site, not the mobile app, since exports are easier to find on desktop).
  2. Go to your account and find Transaction History or Account Activity.
  3. Look for a “Download,” “Export,” or arrow icon near the transaction list. It's often a small link, not a big button.
  4. Choose CSV from the format dropdown. You may also see it called “Comma Delimited,” “Spreadsheet,” or “Excel/CSV.”
  5. Set your date range to cover the tax year (January 1 – December 31).
  6. Click Download.

If you can't find an export option on the website, try the desktop version of your bank's app, or search your bank's help center for “download transactions CSV.”

Common Issues

“I can only see PDF statements, not a CSV download”

PDF statements and transaction exports are different features. PDFs live in the “Statements” section. The CSV export is usually in “Transactions” or “Account Activity.” If your bank truly only offers PDFs, check if they have a separate “Download activity” option elsewhere, or contact their support.

“My date range is limited”

Some banks cap exports at 30, 60, or 90 days. If you need a full year, download in chunks (e.g., Jan–Mar, Apr–Jun, etc.) and upload each file separately.

“The CSV opens and looks weird in Excel”

This is normal. Excel sometimes mashes columns together or mangles dates. The data is still structured correctly, and any tool that reads CSVs will parse it just fine. For more tips on fixing formatting issues, see our guide on how to clean bank CSV transactions. If you want it to look right in Excel, use File → Open (not double-click), choose “Delimited,” and select “Comma” as the delimiter.

“I have multiple accounts”

Download a separate CSV from each account, including your credit card transactions. Most categorization tools can handle multiple files.

Now You Have Your CSV. What Next?

If you're downloading bank CSVs, you're probably doing it for taxes. The next step is sorting each transaction into IRS categories (Schedule C lines like advertising, supplies, or office expenses). That's the part that takes most people hours in a spreadsheet.

Here's the typical path:

  1. Download your CSV (you just did this).
  2. Categorize every transaction into the right Schedule C line. For 300+ transactions, this is where the time goes.
  3. Generate a report to hand to your accountant or plug into TurboTax/FreeTaxUSA.

You can do step 2 manually, or you can upload your CSV to Categorize My Expenses and let AI sort them in a fraction of the time. It costs $39, and you review every category before anything is final.

Stop sorting transactions by hand.

Upload your bank CSV and get every transaction categorized into Schedule C lines. You review the results, download a report, and hand it to your accountant (or file yourself). AI does the sorting. You review. $39.

Disclaimer: This article is for educational purposes only and does not constitute tax, legal, or financial advice. Bank interfaces change frequently. If these steps don't match exactly what you see, look for similar options or check your bank's help center. Categorize My Expenses is a financial data organization tool. It is not a tax preparer and does not provide tax advice.

Related Guides