To turn a card statement into CSV, open the PDF, copy the transaction table into Excel or Google Sheets, split it into columns, convert the dates and amounts from text into real values, and check the total against the statement before saving as CSV. Card statements add two small traps: dates written day first, and credits marked with Cr. The formulas below handle both, but check your own statement layout, since it can differ.
First, check whether a download exists
Some banks let you download transaction history as CSV or Excel for the same period. If yours does, use that and skip the cleaning. If the only option is PDF, continue with the steps below. Do not use online converters that need you to upload the file; the document holds your purchases and card details.
How do you get the table out of the PDF?
- Open the PDF and select just the transaction rows.
- Paste into a blank sheet.
- If each row is in one cell, split it: Data then Text to Columns in Excel, or Data then Split text to columns in Google Sheets.
- Keep columns for date, description and amount. Delete page headers, repeated column titles and subtotals.
- Keep one row per transaction, even when a description wraps onto a second line.
How do you fix dates written day first?
A date like 05/03/2026 means 5 March in India, but a US-set spreadsheet may read it as 3 May. If the dates arrived as text in column A, build real dates in column D with =DATE(RIGHT(A2,4),MID(A2,4,2),LEFT(A2,2)), then format the column as a date. This assumes the text is exactly DD/MM/YYYY with two digits for day and month. Check a few rows by eye.
How do you handle Cr and commas in amounts?
Card statements often show amounts like 1,245.50 for spends and 3,000.00 Cr for credits. With the amount text in column C, this formula makes spends positive and credits negative: =IF(RIGHT(TRIM(C2),2)="Cr",-1,1)*VALUE(TRIM(SUBSTITUTE(SUBSTITUTE(C2,"Cr",""),",",""))). Fill it down column E. If your statement uses another marker, adjust the text in the formula. Currency symbols inside the cell must also be removed first.
| Pasted text | Date result | Amount result |
|---|---|---|
| 05/03/2026 | Fuel station | 2,100.00 | 5 March 2026 | 2100 |
| 09/03/2026 | Online store | 1,450.50 | 9 March 2026 | 1450.5 |
| 14/03/2026 | Refund | 600.00 Cr | 14 March 2026 | -600 |
What is the total check?
Add the Amount column with =SUM(E2:E4). For the three example rows that is 2,100 plus 1,450.50 minus 600, which is ₹2,950.50. The statement's purchases minus credits for those lines should be the same figure. A mismatch usually means a deleted row at a page break, a fee line you cut, or a text amount the formula skipped. VALUE returns an error for unexpected characters, so scan the column for errors before trusting the total.
What about descriptions that wrap or repeat?
Card descriptions often include a city, a reference number or a payment gateway name, which makes the same shop look different every time. Before totalling by merchant, add a clean-name column and type the short merchant name beside each row, for example Fuel station instead of the long line. Once that column is filled, a pivot table or SUMIF by the clean name gives a tidy summary. If a description wrapped onto a second line, join the two cells with =A2&" "&A3 and then delete the extra row, so each transaction stays one row.
Saving and importing
Save the sheet as CSV with the headers in row one. SpendixAI takes CSV, Excel and PDF statements, so you may also try the original file first, review the rows and fall back to your cleaned CSV if the layout does not parse. Choose the card as the account before importing.
Checklist
- Prefer a bank CSV or Excel download when one exists.
- One row per transaction.
- Real dates in one column and numbers in another.
- Cr entries as negative.
- Total matches the statement.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

