How to Export Capital One Transactions and Download Your Transaction History as a CSV
Capital One offers CSV exports for both its credit cards and its 360 checking and savings accounts. Like Citi, Capital One separates money out and money in into Debit and Credit columns rather than using a single signed amount.
How to export Capital One transactions as a CSV
- Sign in at capitalone.comUse a desktop browser, because the mobile app shows statements as PDFs only.
- Open the account you want to exportChoose the credit card or 360 account from your account list.
- Click "Download Transactions"The link sits above your transaction list. On credit cards it may appear under a "View Statements" or download icon area.
- Choose CSV as the formatCapital One also offers Quicken, QuickBooks, and Excel formats. Select CSV (sometimes shown as "Comma delimited").
- Select your date range and downloadPick a statement period or custom range, then download the file.
What is inside a Capital One CSV file
A Capital One export contains these columns:
Capital One includes its own Category column, which is useful context but often broad. Fynnap re-categorises transactions using the merchant name so the results line up with your other accounts.
Capital One CSV column format explained
A Capital One export has seven columns, more than most banks, and two of them are unusual. Here is a real-shaped example:
| Column | Example | What it means |
|---|---|---|
Transaction Date | 2026-06-04 | When you made the purchase. Capital One commonly uses YYYY-MM-DD, unlike most US banks. |
Posted Date | 2026-06-05 | When it cleared. Usually a day or two later. |
Card No. | 1847 | Last four digits only. Useful when several cards share one account. |
Description | WHOLE FOODS MKT | The merchant. Capital One cleans these up more than most banks do. |
Category | Grocery | Capital One's own guess. Broad, and inconsistent with other banks' schemes. |
Debit | 112.47 | Money out. Always positive, never signed. |
Credit | 43.20 | Money in: refunds and payments. Also always positive. |
The two things that trip people up. First, the split amount columns: like Citi, Capital One never uses a minus sign, so the column tells you the direction, not the number. Software that grabs whichever value it finds adds your $850 payment straight onto your spending total.
To merge them in a spreadsheet, add a column with:
where F is Debit and G is Credit.
Second, that built-in Category column is more tempting than it is useful. It is genuinely convenient, but Capital One's categories do not match Chase's, which do not match your bank's, so the moment you are budgeting across more than one account the categories stop lining up. Most budgeting tools ignore it and re-categorise from the merchant name so every account follows one consistent scheme. Fynnap does this, which is why a Capital One import may show different categories than Capital One's own site.
Capital One credit card versus 360 checking exports
Capital One runs credit cards and 360 banking as separate products, and the exports differ in ways that matter.
Credit card exports use the full seven columns above, including Card No. and Category. There is no running balance, since a card balance is what you owe rather than what you hold.
360 checking and savings exports follow the same Download Transactions flow but produce a simpler file, typically without the Card No. column and sometimes with a balance column instead. The Debit and Credit split is the constant across both, and that is the part that matters for importing.
Because the exact wording varies between products, open the file and read the first line rather than assuming. Tools that match columns by name instead of fixed position handle the variation without complaint.
If you have both a 360 account and a Capital One card, watch the autopay. It appears as a Debit on the 360 export and a Credit on the card export. One movement of money between two accounts you own, showing up twice. Treating it as spending on one side and income on the other is the most reliable way to make a month's numbers nonsense.
Opening a Capital One CSV in Excel or Google Sheets
Capital One's YYYY-MM-DD date format is the one to watch. Excel usually reads it correctly, but depending on your regional settings it can decide the column is text, which means you cannot sort chronologically and any date formula silently returns nothing.
In Excel: open a blank workbook first, go to the Data tab, choose From Text/CSV, and select the file. In the preview set both date columns explicitly to a date type and Debit and Credit to Decimal Number. Leave Card No. as Text, or Excel will strip a leading zero from a card ending in something like 0847. Then click Load.
In Google Sheets: File, then Import, separator set to comma. Sheets handles ISO dates well. If you want the card number preserved exactly, turn off "Convert text to numbers, dates, and formulas", though note this also leaves your amounts as text.
A quick check once loaded: sum Debit and sum Credit separately. Debit is your gross spending for the period. Credit will usually be dominated by one large autopay figure, which is your payment, not income.
None of this is necessary if you are importing into a budgeting tool. Reading the file directly avoids every one of these conversion problems.
The mobile app, and printing your transaction history
The Capital One mobile app has no CSV export. It will show statements and save them as PDFs, which looks equivalent and is not: a PDF is a picture of a document, and pulling reliable figures back out of one is rarely worth the effort. There is no setting to turn this on. If a computer is not available, open capitalone.com in your phone browser and request the desktop site from the browser menu. Download Transactions reappears and the file lands in your phone's Downloads folder, where you can upload it from.
To print your Capital One transaction history, open the account activity, set the date range, and press Ctrl+P, or Cmd+P on a Mac. Check the preview first: with seven columns this table is wide, and the Debit and Credit columns on the right are the first to be clipped. Landscape orientation usually solves it. Printing makes sense when someone else needs the record.
If you want to understand your own spending rather than file a copy, export the CSV instead.
When the Capital One download option is missing
Work through these in order.
You are on the app or mobile site. The usual cause. Use a desktop browser or request the desktop version.
You are in View Statements rather than account activity. Statements are PDFs. Download Transactions sits with the live transaction list.
Your date range is empty. No transactions in the selected period means no file, or a file with only headers.
You chose the wrong format. Capital One offers Quicken, QuickBooks and Excel alongside CSV. Pick CSV, sometimes shown as "Comma delimited". An .xlsx is a different format that most budgeting tools will not read.
The account is new. With very few transactions the export option is sometimes omitted entirely. Widening the date range usually brings it back.
An extension is interfering. Ad blockers and privacy extensions occasionally hide banking controls. Try an incognito window with extensions disabled.
How much Capital One history you can export
Capital One credit cards typically allow exports covering the past 12 to 24 months, and 360 accounts generally offer a comparable window. The exact figure varies by product and Capital One does not publish a guarantee, so request a wide custom range and see what comes back rather than assuming.
Older records mean archived statements, which arrive as PDFs. Useful as proof of payment, not useful for budgeting, since the data has to be re-entered by hand.
The habit worth forming: export once a month just after the statement closes and keep the files. It takes under a minute and means the size of your bank's window stops mattering. A year from now, when you actually want to compare this year to last, you will either have the data or you will not.
How far back can you export?
Capital One credit cards typically allow exports covering the past 12-24 months; 360 bank accounts often provide a similar window.
Common questions about Capital One CSV exports
Does Capital One include the card number in the export?
Capital One includes a masked "Card No." column showing only the last four digits, which is helpful if you have several cards on one account. Full numbers are never included.
Should I use Capital One's built-in categories?
They provide a rough starting point, but they are broad and inconsistent across banks. Most budgeting tools re-categorise using the merchant description so all your accounts follow one scheme.
Why are my Capital One amounts all positive?
Capital One uses separate Debit and Credit columns, both containing positive numbers. The column determines direction rather than the sign of the number.
Can I export Capital One 360 savings the same way?
Yes. The 360 checking and savings accounts follow the same Download Transactions flow as credit cards.
How do I convert the Capital One Debit and Credit columns into one amount?
In a spreadsheet, add a column with =IF(ISBLANK(F2), G2, -F2) where F is Debit and G is Credit. Purchases become negative and payments positive, matching the convention other banks use. Tools built to read Capital One exports do this automatically, so no formula is needed.
Can I export transactions from the Capital One mobile app?
No. The Capital One app shows statements as PDFs but has no CSV export. Sign in at capitalone.com in a browser. On a phone, open the site and use your browser menu to request the desktop version, which restores Download Transactions.
How do I print my Capital One transaction history?
Open your account activity, set the date range, and use your browser print command (Ctrl+P on Windows, Cmd+P on Mac). Printing produces a readable record rather than workable data. Export the CSV if you want to analyse the numbers.
How do I open a Capital One CSV in Excel?
Open Excel first, go to Data then "From Text/CSV", select the file, and in the preview set the two date columns to a date type and Debit and Credit to Decimal Number. Double-clicking often works but Excel sometimes reformats dates and can misread the blank cells in the Debit and Credit columns.
Which date should I use, Transaction Date or Posted Date?
Transaction Date is when you made the purchase; Posted Date is when it cleared. For budgeting, Transaction Date usually reflects your actual behaviour better, since a purchase made on the last day of the month can post in the next one. Most tools read Transaction Date because it appears first in the file.
Why does my Capital One payment look like income?
Payments to your card sit in the Credit column as a positive number, which software can mistake for income if it does not understand the two-column layout. A card payment is a transfer between two accounts you own, not income and not spending. Counting it either way distorts your totals.
Does the export include my full card number?
No. Capital One includes a masked Card No. column with only the last four digits, which is useful for separating multiple cards on one account. Full numbers and credentials are never included.
Guides for other banks
Fynnap is an independent budgeting tool and is not affiliated with, endorsed by, or connected to Capital One. Bank websites change; if a menu has moved, look for any option labelled “Download”, “Export”, or “Account activity”.