How to convert a credit card statement to Excel
- Choose the PDF statement you downloaded from your card account, up to 50 MB.
- Pick Excel or CSV, and how amounts go in: Charges and credits, One column, as on the statement, or One column, charges negative.
- Select Convert statement. If the statement has a password, enter it and select Convert statement again.
- Read the summary, then download the file. Adds up means the previous balance plus charges, minus credits, comes to the new balance.
How the credit card statement converter reads charges and credits
Card statements group transactions by kind rather than by date. Payments and credits often come first, then purchases, then fees and interest, sometimes in a separate list for each card on the account. This credit card statement parser reads the headings of these sections when you convert a credit card statement to Excel or export a credit card statement to CSV, so a payment printed without a minus sign is still a credit, and a refund with a minus sign or CR in the purchases list is a credit too. Whether you need credit card PDF to Excel or credit card transactions to Excel for an expense report from a credit card statement, lines such as foreign currency details are joined to the transaction above them, and interest charges that some statements print without a date still count.
Statements often give two dates for each transaction: the day you used the card and the day the card company posted it. Both are kept when turning a card statement to a spreadsheet, in Date and Posted columns. When dates have no year, it comes from the statement period, so a January statement puts December’s purchases in the year before.
Verifying the previous and new card balances
The summary shows the number of transactions, the total charges, the total payments and credits, and whether the previous balance plus charges, minus credits, comes to the new balance. When it adds up, every amount was read with the right sign. When it doesn’t, compare the totals with the statement’s own summary box, which usually shows payments, purchases, fees and interest separately.
For bank account statements, use Bank statement to Excel, which checks every running balance, or create client billing documents with the invoice generator. To share a statement with someone after converting it, black out the card number and other details with Redact PDF. Tables in other PDFs, such as reports and price lists, go through PDF to Excel.
Frequently asked questions
Which credit card statements does it work with?
It doesn’t rely on templates for particular card companies. It reads what most statements share: a date for each transaction, often with a posting date beside it, and the amount lined up on the right. Payments can be printed with a minus sign, in brackets or with CR after them, and sections such as Payments and other credits, Purchases, Fees charged and Interest charged give each amount its sign. Dates such as 01/31, 31/01/2026, 31 Jan and Jan 31 all work, and so do decimal commas and Indian lakh grouping.
How do I know every transaction was read?
Most card statements print a previous balance and a new balance. The previous balance plus all charges, minus all payments and credits, should come to the new balance. The tool works this out from the rows it read, and the summary says whether it adds up. If it doesn’t, the balances it found are shown, so you can compare the totals with the statement’s summary box.
My statement has a password. Can I still convert it?
Yes. Many card companies send statements that need a password to open. When the tool finds one, it asks for the password, which is used only to open the file in your browser. It isn’t saved, and it isn’t sent anywhere.
Which way round are the amounts?
Charges and credits puts purchases, fees and interest in a Charges column and payments and refunds in a Credits column, both as positive numbers. One column, as on the statement, keeps charges positive and credits negative. One column, charges negative, turns that round, which is what most budgeting and accounting apps expect for money spent.
Can I import the file into budgeting or accounting software?
Yes. The CSV is UTF-8 with commas between fields, ISO dates such as 2026-01-31 and plain numbers. The Excel file has real dates and numbers, so you can sort, filter and add up spending by merchant straight away.
Does it work with scanned statements?
No. A scanned statement is a picture of each page, and reading it would need text recognition, which this tool doesn’t have. Statements downloaded from your card account almost always have text you can select, and those work.
Is my statement uploaded?
No. The PDF is read in your browser and the spreadsheet is made on your device. Card numbers, balances and purchases are never sent to this website or anyone else.
Last updated November 8, 2026