Downloading the statement as CSV from the issuer, if it offers one, gets you a CSV of your card statement. If it only gives a PDF, you have to convert it, and the result needs checking. we will not describe Capital One's screens or password rules, because they differ by issuer and change; follow the issuer's own instructions for both the download and the password.
Why does the statement PDF ask for a password?
Issuers often protect a statement so that only you can open it. The email or the issuer's help page usually says how the password is formed. Check there. Do not hand the password to a website or a stranger offering to convert your file; use a tool you trust, or do it on your own computer.
Converting the PDF
- Open the PDF with the password.
- Look for a transactions table with date, description and amount.
- Copy the table into a spreadsheet, or use a spreadsheet's PDF import if it has one.
- Clean the cells until each row is date, description, amount.
- Save the sheet as CSV.
Save as CSV without surprises
- Pick CSV UTF-8 if offered, so that symbols like the rupee sign survive
- Make sure the amount column has plain numbers, no currency signs
- Put dates in one format such as 2026-11-05
- Remove any totals or balance rows
How do I check the CSV?
Open it in a plain text editor. You should see lines like this: 2026-11-05,Grocery store,-1250.00. If a description contains a comma, it must be inside quotes, for example 2026-11-06,"Cafe, Indiranagar",-420.00. Without quotes, the comma splits the description and shifts the amount into another column.
| Problem | How it looks | Fix |
|---|---|---|
| Comma in description | Amount in wrong column | Wrap description in quotes |
| Text amounts | Sum shows 0 | Convert to numbers |
| Day and month swapped | Dates in the future | Rebuild the date |
| Garbled symbols | Strange characters | Save as UTF-8 |
A tie-out example
Say the statement lists 12 transactions with a total of ₹23,640. Your CSV has 12 lines and sums to ₹23,640: it ties out. If it has 11 lines and sums to ₹22,100, a row of ₹1,540 is missing, and 23,640 minus 22,100 is 1,540.
Which columns should my CSV have?
Keep it simple: Date, Description, Amount, and optionally Account. Use one amount column with debits negative and credits positive, or two columns, Debit and Credit, but not both styles in the same file. Mixed styles are the number one reason imported totals come out wrong. Put a header row in the first line with plain names and no merged cells.
If your statement has several currencies, add a Currency column rather than mixing figures. Never sum amounts in different currencies without converting them.
Does the CSV need to match the PDF exactly?
The CSV only needs the same transactions and totals, not the same layout. Check three things: the number of rows, the sum of amounts, and the first and last transaction dates. If all three match the statement, the file is faithful enough to use for a tracker or a spreadsheet. If one differs, find the row before you go further.
Store the CSV beside the original PDF so you can always go back to the source.
Import instead of converting
SpendixAI accepts PDF, CSV or Excel statements, so you can skip the conversion and review the rows before saving. If a layout is unfamiliar, check the preview line by line.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
