How to Convert a Chase Bank Statement to CSV
Chase provides bank statements as PDFs, with limited structured-data export for recent transactions only. To get your full transaction history into a spreadsheet, you have four practical options. This guide walks through each, with step-by-step instructions and an honest assessment of where each method falls short.
The four methods to convert a Chase bank statement to CSV are: (1) Chase's native Activity download (free, recent transactions only), (2) Excel Power Query Get Data from PDF (free, Windows only, struggles with multi-page statements), (3) Adobe Acrobat Pro export (paid, manual cleanup required), and (4) dedicated bank statement converters (free tier available, handles Chase quirks automatically). Dedicated converters are the most accurate for older PDFs, credit card statements, and multi-account combined PDFs.
Why converting Chase statements is harder than it should be
Chase delivers most of its statements as PDFs, which look fine on screen but were never designed for data extraction. Three Chase-specific quirks make conversion harder than for a typical PDF table:
Limited native export. Chase offers CSV, QFX, and QBO downloads on the Activity page, but the time window is limited and varies by account. Anything older than the recent activity window (including most older monthly statements) is available only as PDF.
Year-stripped credit card dates. Chase credit card statements typically show transaction dates as MM/DD without the year, because each statement covers one billing cycle. The year appears only in the statement period header. Any tool that converts the PDF without reading the period header produces ambiguous dates.
Multi-account combined PDFs. Chase often combines linked accounts (checking + savings, or business + personal) into a single PDF. Each account has its own header, transaction table, and balance summary. Tools that aren't account-aware merge everything into one block or pick up only the first account.
The rest of this guide walks through the four practical methods to handle these challenges, with step-by-step instructions for each.
Chase's native Activity download
Chase's online banking portal includes a direct CSV/QFX/QBO download on the Activity page for recent transactions. This is the fastest method when the data you need is still in the active activity window.
- Chase online banking login
- Transactions within the available activity window (varies by account)
- Log into chase.com on a desktop browser.
- Select the account you want to export from your accounts list.
- Scroll down to the Account Activity section. On the far right of the section header, find the download icon (it looks like an arrow pointing down into a tray).
- Click the download icon. A dialog appears.
- Select the file type:
CSVfor spreadsheet use,QFXfor Quicken, orQBOfor QuickBooks Web Connect. - Choose your date range: select from the dropdown options, or use Choose a date range to specify exact start and end dates.
- Click Download. The file saves to your computer.
- Open the CSV file in Excel, Google Sheets, or your accounting software.
- Free and fast, no third-party tools
- Data comes from Chase directly, so it's authoritative
- Multiple format options (CSV, QFX, QBO)
- Only covers the active activity window (varies by account type, anywhere from ~90 days to ~24 months)
- Cannot reach older statements (Chase keeps PDFs for up to 7 years, but the Activity export does not)
- Live transaction feed, not the official monthly statement; formatting and categorization may differ
- Single account at a time; doesn't handle multi-account combined statements
- Bookkeepers receiving PDF statements from clients can't use this method
Use this method when your transactions are still in the activity window and you want the fastest path. Skip ahead to methods 2-4 for older statements or PDF-only data.
Excel Power Query (Get Data from PDF)
Microsoft Excel includes a PDF data import feature called Power Query (also called "Get Data from PDF"). This method works on Windows versions of Microsoft 365 and Excel 2019+. It's free if you already have Excel.
- Excel 2019 or later, or Microsoft 365, on Windows
- The Chase statement saved as a PDF on your computer
- A digital (text-based) PDF, not a scanned image
- Open a blank Excel workbook.
- Go to the
Datatab in the ribbon. - Click
Get Data > From File > From PDF. - Browse to your Chase PDF and click
Import. - The Navigator window opens, showing tables Power Query detected. Chase statements typically appear as separate tables per page. Click each one to preview.
- Select the transaction table you want (or multiple, via Ctrl-click).
- Click
Transform Datato open the Power Query Editor for cleanup. - In the editor: rename column headers, remove header/footer rows, filter out balance summary rows, and adjust column data types (Date, Currency, Text).
- Click
Close & Loadto push the cleaned data into a new Excel sheet. - Save the file as
.csvviaFile > Save Asif you need CSV format.
- Free if you already have Excel
- Refreshable: load a new statement to the same folder and Power Query applies the same cleanup steps
- Full control over data transformations
- Often picks up only page 1 of multi-page Chase statements (a documented Power Query behavior)
- Cannot infer the year on credit card statements where Chase shows dates as MM/DD
- Multi-account combined PDFs merge into one mess or only the first account appears
- No balance reconciliation, so errors pass through silently
- Not available on Mac (Power Query for PDF is Windows-only)
- Each new statement requires going through the cleanup steps unless you build a reusable query
Best for: technically comfortable users on Windows with single-account, single-month Chase checking statements. Skip if you have credit card PDFs, multi-account statements, or batch processing needs.
Adobe Acrobat Pro export to Excel
Adobe Acrobat Pro (part of the Adobe Acrobat subscription) includes PDF-to-Excel export. This is convenient if you already pay for Adobe but the output usually requires manual cleanup before it's usable.
- Adobe Acrobat Pro subscription (currently ~$23/month standalone, included in Creative Cloud)
- The Chase statement PDF
- Excel or Google Sheets to open and clean the output
- Open the Chase PDF in Adobe Acrobat Pro.
- Click
All Toolsin the left sidebar. - Select
Export a PDF. - Choose
Microsoft Excelas the export format. - From the dropdown, select
Excel Workbook (.xlsx). - Click
Convert to XLSX. - Choose a save location and click
Save. - Open the resulting Excel file. Expect to clean up extra columns, merged cells, and misaligned rows.
- If you need CSV, save the cleaned Excel file as CSV via
File > Save As.
- Works on both Mac and Windows
- Handles scanned PDFs via OCR (using
Enhance Scans > Recognize Textfirst) - Familiar workflow if you already use Adobe
- Often produces 20+ columns from layout artifacts (extensively documented in Adobe's user forums)
- Doesn't understand bank statement structure; treats it as generic PDF data
- No year inference on credit card statements
- No balance reconciliation or duplicate detection
- Multi-account combined PDFs merge together
- Manual cleanup time often equals or exceeds the conversion time itself
- Requires paid Adobe subscription
Best for: occasional one-off conversions when you already pay for Adobe and have time for cleanup. Avoid for recurring bookkeeping work or batch processing.
Dedicated bank statement converters
Several tools are purpose-built for bank statement extraction. They understand the structure of statements (transactions vs. summaries, account boundaries, balance reconciliation) and handle Chase's specific quirks automatically. The category includes SendItSheets, DocuClipper, CapyParse, Bankstatemently, LedgerBox, and others. Most offer free tiers for trial.
- Your Chase PDF statement (or several, for batch processing)
- A free account on whichever converter you choose
- Choose a converter. Most offer free tiers (typically 5-10 pages per month) so you can test before committing.
- Sign up for a free account. No credit card is usually required for the free tier. Try SendItSheets here if you want to start with a Chase PDF now.
- Upload your Chase PDF via drag-and-drop or file picker.
- Wait for processing (typically 6-30 seconds per statement depending on length).
- Review the extracted data on screen. Most tools show a side-by-side comparison with the original PDF.
- If the tool offers it, check the balance validation: beginning balance + transactions = ending balance.
- Export to your preferred format: CSV, Excel (XLSX), or QBO for QuickBooks.
- Import into Excel, Google Sheets, QuickBooks, Xero, or your accounting software.
- Designed specifically for bank statements: understands transactions vs summaries
- Year inference on Chase credit card date formats
- Multi-account combined PDFs split into separate accounts automatically
- Balance reconciliation built in: catches errors before export
- Batch upload for multiple statements
- Works on Mac and Windows (browser-based)
- Handles scanned PDFs via OCR
- Requires creating an account (most are free for low volume)
- Higher volume usually requires a paid plan
- Cloud-based, so uploads leave your computer (most use encryption in transit)
- Different tools handle Chase quirks with varying accuracy. Test on the free tier first
Best for: bookkeepers handling multiple client statements, anyone reconciling year-end records from older PDFs, users with multi-account combined statements, and credit card PDF conversions. SendItSheets falls in this category and is designed for bulk bookkeeper workflows. See the comparison below for when it's the right fit.
Which method should I use?
The right method depends on your situation. Use this table to match your use case to the best method.
| If you... | Use this method | Why |
|---|---|---|
| Need recent transactions (within Chase's activity window) for a single account | Method 1: Chase Activity download | Fastest path. Data comes from Chase directly, no third-party tool needed. |
| Have a single-month, single-account Chase checking statement PDF and use Windows Excel | Method 2: Power Query | Free, works well on simple cases. Skip for credit cards or multi-page statements. |
| Convert one or two statements occasionally and already pay for Adobe | Method 3: Adobe Acrobat | Convenient if Adobe is already in your stack. Expect cleanup time. |
| Need to convert older PDF statements (beyond Chase's activity window) | Method 4: Dedicated converter | Only method that works for older PDFs. Chase keeps 7 years of PDFs but Activity export covers a smaller window. |
| Have Chase credit card statements with year-stripped dates | Method 4: Dedicated converter | Year inference from statement period is built in. Generic methods produce ambiguous dates. |
| Have multi-account combined Chase PDFs (checking + savings + credit) | Method 4: Dedicated converter | Account-aware extraction splits accounts automatically. Generic methods merge or drop accounts. |
| Are a bookkeeper processing many client statements monthly | Method 4: Dedicated converter | Batch uploads and validation save hours per client. SendItSheets, DocuClipper, and similar tools are built for this workflow. |
| Doing year-end catch-up across 12+ monthly statements | Method 4: Dedicated converter | Batch processing handles the volume. Manual methods don't scale to 12+ statements. |
| Need to import directly into QuickBooks | Method 1 (recent) or Method 4 (older) | Both can produce QBO format. Activity export is direct from Chase; converters work on PDFs. |
| Need to import into Xero, FreshBooks, or Wave | Method 1, 2, or 4 โ CSV export | Any method producing clean CSV works. Skip Method 3 unless you enjoy cleanup. |
Chase-specific quirks every method has to handle
Regardless of which method you choose, three Chase-specific issues will affect your output. Knowing about them upfront lets you verify the conversion handled them correctly.
Year-stripped credit card dates
Chase credit card statements show transaction dates as "03/15" without the year. The year appears only in the statement period header. After conversion, check that your dates include the year. If not, you'll need to add it manually or use a method that infers it automatically.
Multi-account combined PDFs
Chase combines linked accounts into a single PDF with checking, savings, and credit transactions stacked sequentially. Each account has its own header and balance summary. Check that your output preserves account boundaries. If all transactions appear in one mass, the account information is lost.
Balance reconciliation
Chase statements include a beginning balance, transactions, and an ending balance. After conversion, verify: beginning + transactions = ending. If not, your conversion missed something (a fee, an interest charge, a transaction split across pages). Methods with built-in balance validation catch this automatically.
Need this for banks beyond Chase?
The methods above work for any US bank's PDF statements with bank-specific quirks. For Bank of America, Wells Fargo, Citi, Capital One, and other major banks, see our general bank statement converter guide with supported institutions, security details, and bulk processing workflows.
Frequently asked questions
All Tools > Export a PDF. Results on bank statements are inconsistent. Adobe often creates many extra columns from layout artifacts, requires manual cleanup, and lacks bank-specific features like balance reconciliation or year inference. It's acceptable for occasional one-off conversions if you already pay for Adobe, but not ideal for recurring bookkeeping work.Enhance Scans > Recognize Text, then export.Need a dedicated converter? Try SendItSheets free
If Method 4 fits your situation, SendItSheets is built for bookkeepers, multi-account statements, year-end catch-ups, and bulk processing. 10 free pages monthly, no credit card required.
Try SendItSheets Free