Capital One bank statement to Excel
Drop a Capital One PDF below and get a spreadsheet with the columns split the way the statement prints them. The file stays in your browser.
Drop your Capital One PDF statement here
or click to choose a file · nothing is uploaded
Import straight into accounting software
A CSV leaves you at the door of QuickBooks or Quicken; these formats walk in, with each transaction carrying an id so a re-import can't duplicate it. The plain .ofx is the same file without the Intuit tag, for GnuCash, Moneydance and anything else that reads a bank feed.
QuickBooks (.qbo)Quicken (.qfx)Plain .ofxWhat a Capital One statement looks like
| Columns | Date · Description · Amount · Balance |
|---|---|
| Amounts | one amount column carries both, with money out negative |
| Date format | MMM D |
Capital One writes dates as an abbreviated month and day rather than digits, so a spreadsheet may read the column as text. Setting the column format after import, rather than relying on autodetection, avoids losing the year.
How Capital One writes its transaction lines
Capital One writes short, clean descriptions, usually just the merchant and location with none of the ACH boilerplate Chase or Wells Fargo carry. That makes the text side of the conversion easy. The date is the hard part, because it is written as an abbreviated month and day with no year at all.
What to check afterwards
Dates arrive as an abbreviated month and day with no year, so a spreadsheet may read them as text or guess the wrong year. A January statement converted in December is the case that bites. Set the date column format yourself after importing.
How the conversion works, why scans are refused, and how to confirm for yourself that nothing is uploaded: read the details.
Where to download your Capital One statement PDF
For 360 Checking, the Statements link on the account page. Capital One names its files by cycle end date and keeps them well past the point most people need, but the PDF is the only format offered for older cycles.
Got several cycles to combine? Merge the converted files into one sheet, then check for duplicate rows where the cycles overlap.
Capital One statement questions
Why did my dates come out as text in Excel?
Capital One writes dates as an abbreviated month and day, with no year. Excel cannot parse that reliably and often leaves it as text, or guesses the current year. Set the column format yourself after importing, and add the year from the statement's cycle dates.
A January statement converted in December got the wrong year. Is that fixable?
Yes, and it is the case worth checking every time. The year is nowhere in the transaction rows, only in the statement header. Fill the year in from the cycle end date rather than trusting whatever the spreadsheet assumed.