Capital One Statement PDF to Excel-Ready CSV

Step 1: Download your Capital One statement as a PDF

Capital One statements can usually be downloaded from the website or the mobile app:

• Online. Sign in, open the card or account, and look for the statements area, usually under Statements or View Statements. Choose the month and download the PDF.
• Mobile app. The app usually lets you open statements for each account and save the PDF.

If a label doesn't match, Capital One's help pages will have the current steps. Upload the original PDF rather than a scan.

Step 2: Upload the PDF

Upload a PDF to start; you'll sign in first. You can choose several PDFs at once, for example several months, and they're processed two at a time. Each page uses one credit. Password-protected PDFs work: enter the password in your browser, and it's never stored.

Step 3: Review every row

After upload, the AI reads the PDF and drafts a ledger: one row per transaction with the date, description, debit or credit, a type (expense, income or transfer) and a suggested category. Treat it as a first draft.

Review means three things: check each row against your statement, fix categories and types, and exclude rows you don't want. With the Capital One PDF open next to the ledger, look at:

• Beginning and ending balance. If the statement gives a summary of deposits and withdrawals, compare those totals with the ledger.
• Deposits vs withdrawals. Check that each one shows as a credit or debit the same way the statement shows it.
• Dates. US statements often print month/day without a year. Confirm the year is right, especially on statements that cross December into January.
• Descriptions. Card purchases, ACH and Zelle lines can be long or wrap. Check that a transaction wasn't split into two rows or merged with the next one.
• Page breaks and section breaks. Statements often group deposits, withdrawals, checks and fees in separate sections. Make sure nothing was skipped between sections.
• Types and categories. Set each row's type to expense, income or transfer, and fix any suggested category that doesn't match your books, one row at a time or in bulk.
• Rows you don't want. Exclude duplicates, rows that don't match the statement, or anything you don't want in the export.

In the ledger you can change categories and types and exclude rows. If a date, description or amount doesn't match the statement, exclude that row, or correct it in your spreadsheet after export with the PDF as your reference.

Step 4: Export a CSV that opens in Excel

When you have finished the review, export it. You get a CSV that opens in Microsoft Excel or Google Sheets, and that you can bring into other tools that accept CSV imports. Steps for Excel are below.

What the reviewed rows look like

Synthetic example, not customer data

A fictional Capital One-style card statement with a $450.00 payment, a $52.30 purchase and a $15.99 subscription could become these reviewed rows. Card statements often don't show a running balance, so that column can be empty. It shows the format only; it says nothing about extraction accuracy on your statement.

The CSV has ten columns, in this order: Date, Description, Amount, Currency, Category, Account Number, Source File, Debit, Credit, Balance. Debit and Credit hold the amount without a sign, so you can read each row the way it appears on your statement. Amount combines both in one column: debits are positive and credits are negative. Source File tells you which statement each row came from. Check account identifiers before you share an export.

Open your CSV in Excel

1. Finish the review first: check each row against your statement, fix categories and types, and exclude rows you don't want.
2. Open the CSV in Microsoft Excel. If columns run together or characters look wrong, use Data → From Text/CSV, choose UTF-8 and the comma delimiter.
3. Import the account number column as Text so leading zeros stay put. Check that dates and amounts came through the way you expect.
4. Need an .xlsx workbook? Use File → Save As in Excel. Statements AI itself exports CSV, not XLSX.

Before you upload

• Upload a bank or credit-card statement PDF that you are authorized to process. Image files and spreadsheets are not accepted in this workflow.
• Password-protected PDFs work: enter the password in your browser, and it's never stored. Don't share it in chat or a support message.
• Scanned pages, blurry text and statement layout changes can lower extraction quality. That's why every row goes through review; results are not guaranteed.

Credits

New accounts get 25 free starter credits. 1 credit = 1 page. See /pricing for more.