How to Download Your Capital One Statement as a CSV File

Capital One offers CSV exports for both its credit cards and its 360 checking and savings accounts. Like Citi, Capital One separates money out and money in into Debit and Credit columns rather than using a single signed amount.

On this page Step-by-step instructions What the file looks like How far back you can export Common questions

How to export Capital One transactions as a CSV

  1. Sign in at capitalone.comUse a desktop browser — the mobile app shows statements as PDFs only.
  2. Open the account you want to exportChoose the credit card or 360 account from your account list.
  3. Click "Download Transactions"The link sits above your transaction list. On credit cards it may appear under a "View Statements" or download icon area.
  4. Choose CSV as the formatCapital One also offers Quicken, QuickBooks, and Excel formats. Select CSV (sometimes shown as "Comma delimited").
  5. Select your date range and downloadPick a statement period or custom range, then download the file.
Got your CSV? See what it actually says.
Upload it to Fynnap and every transaction is categorised automatically — spending by category, budgets, and a plain-English answer to “can I afford this?”. Free, no credit card, and your data stays in your browser.
Import your CSV free →

What is inside a Capital One CSV file

A Capital One export contains these columns:

Transaction Date, Posted Date, Card No., Description, Category, Debit, Credit

Capital One includes its own Category column, which is useful context but often broad. Fynnap re-categorises transactions using the merchant name so the results line up with your other accounts.

How far back can you export?

Capital One credit cards typically allow exports covering the past 12–24 months; 360 bank accounts often provide a similar window.

Common questions about Capital One CSV exports

Does Capital One include the card number in the export?

Capital One includes a masked "Card No." column showing only the last four digits, which is helpful if you have several cards on one account. Full numbers are never included.

Should I use Capital One's built-in categories?

They provide a rough starting point, but they are broad and inconsistent across banks. Most budgeting tools re-categorise using the merchant description so all your accounts follow one scheme.

Why are my Capital One amounts all positive?

Capital One uses separate Debit and Credit columns, both containing positive numbers. The column determines direction rather than the sign of the number.

Can I export Capital One 360 savings the same way?

Yes. The 360 checking and savings accounts follow the same Download Transactions flow as credit cards.

Guides for other banks

Chase → Bank of America → Wells Fargo → Citi → USAA →

Fynnap is an independent budgeting tool and is not affiliated with, endorsed by, or connected to Capital One. Bank websites change; if a menu has moved, look for any option labelled “Download”, “Export”, or “Account activity”.