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.
QuickBooks (.qbo)Quicken (.qfx)What 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.
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.