How to Export Chase Bank Statements to CSV and Excel

Chase gives you two ways to get your transaction data out of its online banking portal. The first is a direct download of your transaction activity as CSV, OFX, or QuickBooks format. The second is downloading monthly statement PDFs, which you then convert to CSV using a parser. Which one you need depends on how old the data is and what format your accounting tool requires.

Option 1: Native CSV download (fastest for recent data)

Chase's transaction download covers recent activity and is the easiest path when you need data from the past few months.

Log in at chase.com and select the checking, savings, or credit card account you want.
On the account page, scroll down to your transaction history. Look for a Download link or icon near the transaction list.
Choose your date range and select a format:
- CSV (labeled "Activity" or "Spreadsheet") works for Excel and Google Sheets
- QuickBooks (QBO) imports directly into QuickBooks Online without column mapping
- OFX works with Xero and Quicken
Click Download and save the file.

The CSV from Chase includes Date, Description, Amount, and Running Balance columns. Amounts are negative for debits and positive for credits.

Option 2: Statement PDF download (for monthly records and older data)

Chase provides up to 7 years of monthly PDF statements through its online portal. These are the official statement documents, useful for loan applications, audits, and any situation where you need a formal record rather than just the transaction data.

Log in to chase.com and select the account.
Click Statements (or look for "Statements and Documents" in the account menu).
Find the month you want and click the PDF icon to download it.

Converting Chase PDF statements to CSV

Chase PDF statements have a consistent format with Date, Description, Amount, and Balance columns. A dedicated parser handles this format well. Convert a Chase statement by uploading the PDF and downloading clean CSV output.

Generic PDF tools like Adobe Acrobat can export the text, but the Balance column sometimes gets merged with the Amount column, and multi-page statements require manual reassembly. A bank-specific parser avoids those issues.

Importing Chase data into Excel

If you downloaded the native CSV from Chase, open Excel and use Data > From Text/CSV rather than double-clicking the file. In the import wizard, set the delimiter to comma. Chase dates are formatted as MM/DD/YYYY, so make sure Excel recognizes the Date column correctly.

A couple of things to check after importing:

The Running Balance column can cause confusion if you are trying to total all transactions. Use the Amount column for summing, not the Balance column.
Chase credit card statements use positive amounts for charges and negative for payments. Checking account statements use the reverse. Confirm which convention applies before setting up any formulas.

Importing into QuickBooks Online

If you downloaded the QBO format from Chase, go to Transactions > Bank Transactions > File Upload in QuickBooks and upload it directly. QuickBooks recognizes the QBO format without any column mapping.

If you are using the CSV format, you will need to map the columns: Date to Date, Description to Payee/Description, and Amount to Amount. QuickBooks will prompt you for this during the upload.

Importing into Xero

Use the OFX file from Chase for the cleanest import into Xero. Go to Accounting > Bank Accounts, select your account, and click Import a Statement. Xero reads OFX without any manual column mapping.

If you are using the CSV instead, Xero will ask you to map columns during the import. Map Date to Date, Description to Description, and Amount to Amount.

Tips for large date ranges

Chase's transaction download works well for periods up to about 6 months. For longer periods, you may need to download multiple files and combine them. If you are working with a full year of data, it is usually faster to download the 12 monthly statement PDFs and convert them all at once. Statement Pro's batch upload lets you upload multiple PDFs at once and download a combined CSV.

For instructions on converting statements from other major banks, see the guides for Bank of America, Capital One, and Citibank.