How to Convert Credit Card Statements to Excel or CSV

You have a credit card statement PDF and need the transactions in a spreadsheet. Maybe you are tracking expenses, preparing for tax season, or reconciling charges against receipts. Whatever the reason, credit card statements are not designed to be easy to work with outside the PDF itself.

This guide covers four ways to get your credit card transactions into Excel or CSV, starting with the simplest option.

1. Download Directly from Your Credit Card Provider

Before converting anything, check whether your card issuer already lets you download transactions in a spreadsheet format. Most major providers offer CSV or Excel exports through their online banking portal.

Here is where to find this option for the largest U.S. issuers:

Chase: Log in at chase.com, go to your credit card account, and look for "Download account activity" near your transaction list. You can choose CSV or Excel format and set a custom date range. Chase also offers QFX and QBO formats for Quicken and QuickBooks users.

American Express: Log in, go to "Statements & Activity," and click on "Custom Date Range." Enter your dates, click Search, then click Download. Select CSV and check the box to include additional transaction details. Amex lets you download up to two years of transaction history.

Capital One: Log in at capitalone.com, select your credit card account, and click "Download Transactions" near the top of the transaction list. Set your date range and choose CSV as the format.

Bank of America: On your credit card page, find the "Download" link above the transaction list. Select your date range, choose "Microsoft Excel Format," and click "Download Transactions." Note that Bank of America may limit downloads to shorter date ranges, so you might need to download in chunks for a full year of data.

Citi: Log in and navigate to your credit card's Transactions or Activity page. Look for a "Download" or "Export" option. Citi supports CSV exports from the desktop site.

Discover: Log in and go to your account activity. Look for the download or export option. Be careful to select the transaction export rather than the PDF statement download, as Discover places both options in the same area.

Limitations of direct downloads

These exports give you transaction activity, not the complete statement. You will typically get dates, descriptions, and amounts, but not things like interest charges, fee breakdowns, reward summaries, or opening and closing balances. If you need those details, you will need to work with the PDF statement itself.

Also, most providers limit how far back you can download. Amex offers about two years. Others may offer 12 to 18 months. For older statements, the PDF is often your only option.

If your provider offers a direct download that covers the period you need, use it. It is the most reliable method since the data comes straight from the source.

2. Use a Converter Tool

When you need data from a PDF statement, whether because the direct download does not go back far enough or because you need the full statement details, a converter tool can extract the transactions for you.

These tools read the PDF and pull out the structured transaction data. You upload the file, the tool processes it, and you download the result as Excel or CSV. Some use OCR (optical character recognition) for scanned documents, while others use AI to interpret the document layout.

Bankonomic is one option. Upload a credit card statement PDF, and it extracts the transactions into a spreadsheet. It handles both digital and scanned PDFs and includes an editor for reviewing transactions before export.

If you have already read our guide to converting bank statements, the process is essentially the same. Credit card statements follow similar structures, with a list of transactions that include dates, descriptions, and amounts.

When choosing a converter tool, there are a few things to keep in mind:

Accuracy. Financial data needs to be correct. Look for tools that let you review and edit results before exporting.
Format support. Make sure the tool handles your file type. Most credit card statements are PDF, but some people work with scanned paper statements (images).
Security. You are uploading financial documents. Check whether the service uses encrypted connections and what their data retention policy is.
Cost. Some tools offer free tiers for low volume. Compare pricing if you process statements regularly.

3. Use Excel Power Query

If you prefer to work locally without uploading files to a third-party service, Power Query can import tables directly from PDF files. This is a good option for technical users who prefer to keep everything within Excel.

Requirements

Power Query's PDF connector is available in Excel for Microsoft 365, Excel 2019, and Excel 2016 (Professional Plus editions) on Windows. It is not available in Excel for Mac.

Step-by-step instructions

Open Excel and go to the Data tab on the ribbon.
Click Get Data, then From File, then From PDF.
Browse to your credit card statement PDF and click Import.
The Navigator window will appear, showing tables and pages that Power Query detected in the document. Click through each one to preview the data.
Select the table that contains your transactions. If you need data from multiple tables, check "Select multiple items" first.
Click Transform Data to open the Power Query Editor.
Clean up the data:
- Click the table icon in the top-left of the first column and select "Use First Row as Headers" if your column headers were imported as a data row.
- Remove unnecessary columns by right-clicking the column header and selecting "Remove."
- Fix any data types by clicking the icon next to each column header (for example, change text columns containing amounts to a decimal number type).
Click Close & Load to import the cleaned data into your Excel worksheet.

When this works well

Power Query does a good job with credit card statements that have clean, consistent table layouts. If the PDF was generated digitally (not scanned), the tables are usually detected accurately.

When it does not

Power Query struggles with scanned PDFs, statements that span multiple pages with repeated headers, and documents where the table structure is inconsistent. It also cannot handle image-based PDFs at all since it relies on embedded text, not OCR.

If Power Query does not detect your transaction table, or the result is too messy to fix with the editor, try one of the other methods instead.

4. Manual Entry

When nothing else works, or when you only have a few transactions to record, manual entry is a legitimate option.

Open your credit card statement side by side with a blank spreadsheet. Set up columns for Date, Description, Category (if listed), and Amount. Then type in each transaction.

Tips for faster manual entry

Set up your spreadsheet first. Create column headers and format the date and currency columns before you start entering data. This avoids reformatting later.
Use a consistent amount convention. Decide whether credits (payments and refunds) will be negative numbers or a separate column. Stick with one approach.
Work in batches. If you have a long statement, enter 10 to 15 transactions at a time and then check your running total against the statement. Catching errors early is much faster than auditing everything at the end.
Use keyboard shortcuts. Tab to move between cells, Enter to move down, and Ctrl+D (Cmd+D on Mac) to copy the cell above. These save significant time over clicking.
Verify your totals. When you finish, sum the amount column and compare it to the statement total. If they do not match, the difference will help you locate the error.

Manual entry is slow but accurate when done carefully. For a typical monthly statement with 30 to 50 transactions, expect about 15 to 20 minutes.

Tips for Organizing Credit Card Data

Once your transactions are in a spreadsheet, a little organization makes the data much more useful.

Add a category column. Group transactions by type: groceries, dining, travel, subscriptions, utilities, and so on. This is essential for budgeting and for identifying deductible expenses at tax time. Most credit card statements do not include categories, so this is something you will need to add yourself.

Use SUMIF to total by category. Once you have categories assigned, a formula like =SUMIF(C:C, "Dining", D:D) will total all dining expenses instantly. This is one of the most useful things you can do with credit card data in a spreadsheet.

Flag business vs. personal expenses. If you use a card for both business and personal spending, add a column to tag each transaction. This makes tax preparation and expense reporting straightforward, since you can filter to show only business charges.

Reconcile against your statement total. After importing or entering data, always compare your spreadsheet total to the statement's total charges and total credits. A mismatch means something was missed or entered incorrectly. Catching this early prevents problems downstream.

Keep a consistent format across months. If you plan to track expenses over time, use the same column layout and category names every month. This lets you combine multiple months into a single sheet or pivot table for year-over-year comparisons.

If you encounter unfamiliar codes or abbreviations in your transaction descriptions, our guide to bank statement abbreviations covers over 150 common codes used by banks and credit card issuers.