Bank statements

Card statement PDF to Excel: three methods and a clean-up

Capital One statement PDF to Excel: three ways to get the rows into a sheet, then formulas to fix dates and amounts so your totals match the statement.

Editorial illustration for Card statement PDF to Excel: three methods and a clean-up

There are three ways to get a card statement PDF into Excel: ask the issuer for a CSV or Excel download instead, use Excel's own PDF import, or copy and paste the table and clean it up. Whichever you choose, the real work is the clean-up afterwards, so that dates are dates, amounts are numbers, and your total matches the statement. This applies to a Capital One statement or any other; check how yours is laid out.

Method 1: look for a download that is not a PDF

Many issuers offer transactions as CSV or Excel on the account's transaction page, separate from the monthly PDF. we cannot say whether yours does, so check the site or app. If it does, you can skip most of the work below.

Method 2: Excel's PDF import

Recent versions of Excel 365 and Excel 2021 have a Get Data option that can read a PDF from the Data tab. It shows the tables it found; pick the one with transactions and load it. Older versions may not have it. If your PDF is protected with a password, open it in a PDF reader first with the password the issuer tells you, and keep the password to yourself.

Method 3: copy and paste

Select the transaction table in your PDF reader, copy, and paste into a blank sheet. Rows may land in one column. Use the Data tab, Text to Columns, and choose delimited or fixed width.

Clean-up formulas

  • Amount stored as text with commas, such as 1,250.00 in A2: =VALUE(SUBSTITUTE(A2, ",", "")) returns 1250.
  • Debit marked with a DR suffix in B2: =IF(RIGHT(B2,2)="DR", -VALUE(SUBSTITUTE(LEFT(B2,LEN(B2)-2), ",", "")), VALUE(SUBSTITUTE(B2, ",", ""))) returns negative for DR and positive otherwise.
  • Date as 05/11/2026 text in C2: =DATE(RIGHT(C2,4), MID(C2,4,2), LEFT(C2,2)) builds a real date from day, month and year.

Check the totals

Add the amount column with =SUM(D2:D200) and compare with the statement's total. Say your sheet shows ₹18,430 but the statement says ₹18,940. The gap of ₹510 means a row is missing or misread. Look for a row that wrapped onto two lines in the PDF, so its amount ended up in a different row.

CheckFormulaWhat to look for
Row count=COUNTA(A2:A200)Matches the number of transactions
Sum=SUM(D2:D200)Matches statement total
Dates=COUNT(C2:C200)Equals row count if all are real dates

What if the PDF is a scan, not text?

Try selecting a line of text in the PDF. If you cannot, the file is an image and neither copy and paste nor Excel's PDF import will work well. Ask the issuer for a text-based statement or a CSV instead. Optical character recognition tools exist, but they make mistakes with digits, and a wrong digit in an amount is exactly the type of error that is hard to spot later. If you use one, check every amount against the PDF.

Whenever you convert, keep a column called Source row so you can trace any figure back to a page of the PDF.

How do I stop doing this by hand every month?

Save your clean-up formulas in a template workbook. Keep one sheet called Paste, where you drop the raw rows, and a second called Clean, which reads from Paste with the formulas already filled down to row 500. Each month you clear Paste, drop in the new rows and check the totals row. A template turns a forty-minute job into a ten-minute one, and the checks stay the same every time.

Name each month's file with the statement month, for example card-2026-10, and keep the original PDF in the same folder.

When a sheet stops being enough

If you do this every month for several cards, SpendixAI can take the PDF, CSV or Excel statement directly, show the rows for review, and save them against the account you pick. Layouts differ, so check the preview.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports