Skip to content

Guide · Export CSV · Capital One

Export a Capital One CSV — the 90-day cap and how to work around it.

Capital One has one of the more restrictive native CSV exports of any major US issuer. The window is short — about 90 days — and the export only lives on the desktop site. If you've been a Capital One customer for years and you're trying to migrate full history into a new budgeting app, this guide covers the working flow plus what to do for the months that fall outside the 90-day window.

Step-by-step: export from Capital One

  1. Sign in at capitalone.com on a desktop browser. The mobile app and the mobile-web site do not expose the CSV export — you need the full desktop site.
  2. Click into the account you want — 360 Checking, 360 Savings, or a Capital One credit card.
  3. On the Activity or Transactions tab, look near the top of the transaction table for Download Transactions (sometimes labelled as a downward-arrow icon).
  4. Set your date range. The selector caps at roughly 90 days of recent activity.
  5. Under File type, pick CSV. Capital One also offers QFX and OFX in the same dialog; Arden ingests CSV.
  6. Click Download. File lands in your downloads folder.

For older transactions (anything before the 90-day window), Capital One keeps a 7-year archive of PDF statements under Statements & Documents. Download those PDFs, but note that Arden ingests CSV — you'll need to convert the PDF first (open-source tools exist, or a paid statement-converter).

What you'll get

  • Format: CSV with columns like Transaction Date, Posted Date, Card No. (last four), Description, Category, Debit, Credit. Note the split debit/credit columns — Capital One uses two columns rather than one signed amount.
  • Date range: ~90 days only. This is the export's hardest constraint.
  • No running balance: the CSV omits Balance — values are per-transaction only.
  • Sign convention: Capital One uses split columns ( Debit / Credit) instead of one signed Amount. One column is populated per row; the other is blank.

Importing into Arden

Drop the file onto /import. Arden detects Capital One's split-column format (Dr/Cr mode) automatically — no manual toggle. The parser reads whichever column has a value, applies the right sign, and writes a single signed amount into your transaction record. Categories from Capital One's export are informational; Arden's own categorization learns from how you tag the first few transactions.

Quirks specific to Capital One

  • The 90-day window is the headline constraint. No way around it on the live export. If you opened your account 3 years ago and want full history, you're downloading PDF statements for everything older than 90 days.
  • Split debit/credit columns, not signed amounts. Most banks export Amount = -45.23. Capital One exports Debit = 45.23, Credit = (blank). Arden's parser handles this; raw-CSV viewers in Excel can look confusing.
  • No CSV export on mobile, full stop. Tried to do this from your phone? It's not you — the option doesn't exist. Get to a desktop browser.
  • Category column is Capital One's guess. Don't rely on it for your budget; their categorization is generic and ignores how you actually spend.

FAQ

  • Can I download older Capital One transactions as CSV?

    Not natively. The live export is capped at 90 days. For older history, download PDF statements (7-year archive) and convert them with a separate tool before importing.

  • Does Capital One offer OFX or QFX?

    Yes — both are in the same download dialog. Arden ingests CSV; pick CSV.

  • Why does my Capital One export look different from my Chase export?

    Different schema. Capital One uses split Debit and Credit columns. Chase uses a single signed Amount column. Both are common conventions; Arden's parser handles both.

Exporting from other banks?

Or just drop any CSV, XLSX, OFX, or QFX onto /import and Arden handles the rest.