How to Convert a Capital One Statement to Excel

Capital One customers often have more than one kind of statement: a credit card such as Venture, Quicksilver or Savor, and a 360 Checking or 360 Performance Savings account alongside it. Both arrive as PDFs. This guide shows how to turn a Capital One PDF statement into Excel (or CSV, JSON or XML), where to find the PDFs, and what to expect from each layout.

The quick way

1. Download your Capital One statement as a PDF (where to find it is below).
2. Upload it to statementconvert.ai: drag and drop the PDF.
3. Preview the extracted transactions and check whether the result agreed with the balances printed on the statement.
4. Download as Excel, CSV, JSON or XML.

No account is needed to preview: without one, the preview shows the first rows in full and the rest as date and amount. Signing in free with Google shows every row and unlocks the download, and the free plan covers up to 5 statement pages a month.

Where to download your Capital One statement as a PDF

You need the PDF of the statement. In Capital One online banking or the Capital One Mobile app, open the account's statements area and download the PDF for the period. Labels vary by account and change over time, so this is the general flow rather than exact menu names:

1. Sign in to online banking or the app and choose the account, card or 360.
2. Open the account's statements area.
3. Pick the statement period.
4. Download the PDF, or share it from the app.

Online banking may also offer downloads of recent transactions in other formats. The PDF route is the one that works for older periods, statements you only have as PDFs, and statements someone else sent you.

What a Capital One statement looks like

Layouts differ by product and change over time, so this is a general guide, not an exact specification.

Capital One credit card statements usually include:

• An account summary: previous balance, payments, other credits, transactions, cash advances, fees charged, interest charged and the new balance.
• A payment information area with the minimum payment and due date.
• A transactions list with a transaction date, often a post date, a description and an amount.
• Transactions that may be grouped by card or cardholder, with separate subtotals when there are authorized users.
• Separate lines or sections for fees and interest charged.

Capital One 360 Checking and Savings statements usually include:

• A header with the statement period and a masked account number.
• A summary with the opening balance, money in, money out and the closing balance.
• A transaction table with a date, a description and an amount. Columns vary, and a running balance appears on some versions.

Subtotals per cardholder, summary boxes and descriptions that wrap onto a second line are what make these statements tricky to extract.

What you get in the Excel file

Each transaction becomes one row with these columns:

Points worth knowing for Capital One:

• Credit card signs. Purchases, fees and interest come out positive; payments and credits come out negative. When every row was read correctly, the Amount column totals to the change from the previous balance to the new balance.
• 360 signs. Deposits are positive and withdrawals negative. The Balance column is filled when the statement prints a balance.
• Cardholder subtotals are not transactions. Subtotal lines per card belong to the statement summary, not to your rows; check in the preview that none slipped in.
• Dates without a year. Statements often print dates as month and day only. For a statement that runs across a year end, check that December and January rows carry the right years.

Converting your Capital One statement with statementconvert.ai

statementconvert.ai reads Capital One credit card and 360 statements, from digital PDFs and, often, from scans.

1. Upload your Capital One PDF. On a paid plan you can upload up to 12 statements at once, for example a year of card statements.
2. Preview the rows. Transactions are read by AI, which can make mistakes, so each result is checked against the balances and totals printed on the statement, where there are any, and tells you whether they matched.
3. Download:
   • Excel (.xlsx) for sorting, filtering, pivot tables and charts.
   • CSV for Google Sheets or for importing into accounting software yourself. There is no direct integration with QuickBooks or Xero; the CSV import guide for QuickBooks and Xero walks through the mapping.
   • JSON or XML for scripts and systems.

On privacy: we never store your statement. It travels over HTTPS, is processed in memory, its pages are read by our AI providers (OpenAI, and Anthropic for a second reading), and it is then discarded. The providers do not train on it and may keep request logs for up to 30 days; the privacy page has the details. There is no bank login and no link to your Capital One account. (More on this: Is it safe to upload your bank statement online?)

A quick check before you use the data

• Balance result. Did the result say the rows agreed with the printed balances? A match means the extracted figures agree with the balances that were checked; it does not prove every row is right, because errors can offset. A mismatch means comparing the rows with the statement to find where they differ.
• Row count. Close to the number of transactions on the statement, with no subtotal lines.
• Fees and interest. If the statement shows interest charged or a fee, check that it appears as a row in the file.
• Wrapped descriptions. Each transaction sits on one row, even when the merchant name wrapped on the page.

Seeing what repeats on your card

A credit card statement is where streaming, app-store and membership charges tend to collect. statementconvert.ai also lists recurring charges it finds in the statements you upload. For a manual method, see how to find all your subscriptions from a bank statement, or how to read a credit card statement for recurring charges.

Prefer to do it manually?

For a digital Capital One PDF, Excel's Power Query may help: availability depends on the Excel version and platform, and where the From PDF connector exists it can extract the tables, which usually need cleanup afterwards for subtotals and split lines. The methods are compared in how to convert a PDF bank statement to Excel. For paper statements, see converting a scanned bank statement to Excel.

Banking elsewhere too? There are walkthroughs for Citi, U.S. Bank and Chase.

Convert your Capital One statement now

Convert a bank statement to Excel: upload your Capital One PDF, preview the transactions, then sign in free to see every row and download Excel, CSV, JSON or XML. Free for up to 5 statement pages a month; paid plans start at $7.99 a month. No account needed to preview.

Frequently asked questions

How do I convert a Capital One statement to Excel? Download the statement as a PDF from Capital One online banking or the Capital One Mobile app, upload it to statementconvert.ai, preview the extracted transactions, and download as Excel, CSV, JSON or XML. It reads Capital One credit card statements and 360 Checking and Savings statements, and we never store your statement.

Where do I download a Capital One statement as a PDF? In Capital One online banking or the Capital One Mobile app, open the account's statements area and download the PDF for the period. Labels vary by account and change over time, so the exact wording on screen may differ.

Does it handle cards with authorized users? Capital One card statements can group transactions by card or cardholder. The converter reads the transactions from each group into one table. The Page column shows where each row came from, which helps if you want to split purchases by cardholder afterwards.

Can I convert Capital One 360 Checking and Savings statements? Yes. The columns on 360 statements vary, but each transaction has a date, a description and an amount. In the converted file, deposits come out positive and withdrawals negative, and the Balance column is filled when the statement prints a balance.

Is it safe to upload my Capital One statement? We never store your statement. It travels over HTTPS, is processed in memory, its pages are read by our AI providers (OpenAI, and Anthropic for a second reading) and it is then discarded. The providers do not train on it and may keep request logs for up to 30 days; the privacy page has the details.