Capital One Statement to Excel: Download and Convert

How to download a Capital One statement, and convert it from PDF or CSV to Excel, QuickBooks or Xero in your browser.

PDFQBO

insytesBI provides estimates for informational purposes only, not financial, tax or accounting advice.

Capital One statements

What Capital One gives you
CSV (QuickBooks and Quicken formats on some accounts)
How far back
The download covers recent activity only (about 90 days is commonly reported).
How we read it
Capital One card files have Transaction Date and Posted Date plus separate Debit and Credit columns. insytesBI uses the transaction date and combines Debit and Credit into one amount.

Download your Capital One transactions

  1. Sign in at capitalone.com on a computer.
  2. Open the 360 Checking, 360 Savings or credit card account you want.
  3. Select Download Transactions above the transaction list.
  4. Choose the date range and CSV as the file type, then download.

Frequently asked questions

Can I convert a Capital One PDF statement to Excel?

Yes, if the PDF has real text, as statements downloaded from Capital One online do. Scanned paper statements cannot be read.

What does Capital One let me download?

CSV (QuickBooks and Quicken formats on some accounts)

How far back can I download Capital One transactions?

The download covers recent activity only (about 90 days is commonly reported).

Does insytesBI need my bank login?

No. You only upload the file you downloaded, and it stays in your browser.