Skip to main content

Guide

Download Capital One transactions as a CSV

Capital One lets you download credit card transactions as a CSV file from capitalone.com. Here are the steps, and the columns the file carries.

Download the file

  1. 1

    Sign in at capitalone.com and open the credit card.

  2. 2

    Select Download Transactions, under the statements menu or above the transaction list.

  3. 3

    Choose CSV as the file format and pick a date range.

  4. 4

    Select Download. Statements on their own are PDF files, so start from the transactions.

What the file carries

Columns: Transaction Date, Posted Date, Card No., Description, Category, Debit, Credit.

Sheetful reads Transaction Date as the date, Description as the description and the Debit and Credit pair as the amount.

The amount sits in a Debit and Credit pair, both written as positive numbers.

Sheetful reads Debit as money out and Credit as money in.

See your file on /try

The preview shows up to 100 rows, newest first, with the name and category Sheetful gives each one.

On /try the file is read in your browser tab, with no account.

Try it with your Capital One CSV

To sync a bank account into a sheet instead, see the Google Sheets sync guide or the Microsoft Excel sync guide.