Capital One statement to Excel
Put the transactions of a Capital One credit card or 360 account statement into a spreadsheet, with a check that the balances add up.
Check the table. If a column is wrong, change its type in the header: the spreadsheet is made from what you see.
Statement not read correctly, or something broke? Tell us
Your statement never leaves your device
How to do it
- Sign in at capitalone.com or in the app, open the account and choose View statements. Download the month you need as a PDF.
- Choose the PDF here. Every page is read, including descriptions that run over two lines.
- Look at the check line: if the balances add up, no transaction is missing or extra.
- Click "Download Excel" or "Download CSV".
Tips
- Capital One card statements list payments and credits apart from purchases. All of them end up in one list: purchases and fees negative, payments and credits positive.
- Amounts with a trailing minus ("45.00-") and Debit or Credit written next to the amount are both understood.
- Checked on sample statements laid out like Capital One 360 checking statements and on sample card statements: purchases, payments and refunds were read with the right signs and the balances added up.
Questions
Are interest charges included?
Yes, interest and fees listed as transactions come out as money out. Interest rate tables at the end of the statement are not taken as transactions.
Is my statement uploaded anywhere?
No. Your browser reads the PDF and makes the Excel file on your device. Nothing is sent to a server, there is no account to create and no page limit.
What if the balance check fails?
The table marks the rows where the balance chain breaks. Usually one column was read the wrong way: change its type in the table header, or the Amounts setting for a card, and the check runs again.
Does it work with a scanned or photographed Capital One statement?
No. It needs the digital PDF you download from online banking, which has the text inside. A scan or a photo is only a picture.