Why does your Chase download show up as a PDF with no columns? Why does pasting it into Excel scatter dates across 5 rows? Why does the "Export" button on Chase only offer CSV — but your version of Excel opens it as gibberish?
The answer is simple: Chase doesn’t give you true Excel files. It gives you CSV or PDF — and how you handle that file determines whether you get usable data or a mess.
The Problem
You log in to chase.com, click Statements, download the latest PDF or CSV, and paste it into Excel. What you get isn’t a table — it’s misaligned numbers, merged cells, blank rows, and dates like "03/15/2024" turning into "45365". Worse: transaction descriptions wrap across 3 rows. You spend 12 minutes manually fixing one month.
| Column | Sample Data (A1:A10) | Rating | Notes |
|---|---|---|---|
| Date | 03/15/2024 45365 03/17/2024 03/18/2024 45367 | ★☆☆☆☆ | Excel auto-converts some dates to serial numbers |
| Description | ACME CORP PAYROLL WALMART STORE #2345 AMAZON MKTPLACE PMTS STARBUCKS COFFEE APPLE.COM/BILL | ★★★☆☆ | No line breaks — but PDF exports add them randomly |
| Amount | -4,520.00 (4,520.00) -4,520.00 -12.95 -1,299.00 | ★★☆☆☆ | Mixed formats break SUM() — parentheses = text, not numbers |
| Balance | $12,450.32 $12,450.32 $7,930.32 $7,917.37 $6,618.37 | ★★★☆☆ | Dollar signs & commas prevent math operations |
The Solution
This works every time — even if you’re using Excel 2013 or Microsoft 365. Do this:
- Log in to chase.com → Accounts → Select checking/savings → Statements → Choose month → Click "Download" → Select "CSV (Comma Delimited)". Not PDF. Not OFX. CSV only.
- Open Excel → File → Open → Navigate to downloaded file → Select it → Click "Open". Don’t double-click the file — that bypasses Excel’s import wizard.
- In the Text Import Wizard (Step 1), choose "Delimited" → Next.
- Step 2: Check "Comma" only → Uncheck everything else → Next.
- Step 3: Click column B (Description) → Set Column data format to "Text" → Click column C (Amount) → Set to "General" → Finish.
Now fix the Amount column: In cell C2, enter =SUBSTITUTE(SUBSTITUTE(C2,"$",""),",","")+0. Drag down. This strips $ and commas, converts text to number. If you see #VALUE!, it means some rows have parentheses. Use this instead: =IF(ISNUMBER(SEARCH("(",C2)), -SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(C2,"$",""),",",""),"(",""),")",""), SUBSTITUTE(SUBSTITUTE(C2,"$",""),",","")).
Finally, convert Date column (A2:A100) to real dates: Select A2:A100 → Ctrl+1 → Number tab → Date → Choose format → OK. Or use =DATEVALUE(A2) in D2 and drag down.
| After Fix | A1:A5 | B1:B5 | C1:C5 |
|---|---|---|---|
| Date | 2024-03-15 | ACME CORP PAYROLL | -4520.00 |
| Date | 2024-03-17 | WALMART STORE #2345 | -89.45 |
| Date | 2024-03-18 | AMAZON MKTPLACE PMTS | -129.99 |
| Date | 2024-03-19 | STARBUCKS COFFEE | -12.95 |
| Date | 2024-03-20 | APPLE.COM/BILL | -1299.00 |
Going Further
Can you export Chase statement to Excel automatically each month? Yes — but not natively. Use Power Query (Data → Get Data → From File → From CSV). Load the CSV once, then refresh with one click. Set up a folder watch: save all Chase CSVs to C:\Chase\Exports\, then use Power Query’s “Folder” connector to append new files.
Need categories? Add a helper column: In D2, use =IFS(ISNUMBER(SEARCH("AMAZON",UPPER(B2))),"Online Retail", ISNUMBER(SEARCH("STARBUCKS",UPPER(B2))),"Food & Drink", ISNUMBER(SEARCH("ACME",UPPER(B2))),"Payroll", TRUE,"Other"). Drag down.
Want to merge multiple months? Stack them vertically: Copy B2:C100 from March → Paste into A2 of a new sheet → Repeat for April starting at A101. Then use =TEXT(A2,"yyyy-mm") in column C to tag each row with its month.
When NOT to Use This
Don’t use CSV export if your account has >10,000 transactions. Chase truncates CSVs at ~10,000 rows. For full history, request a PDF statement and use Adobe Acrobat’s “Export PDF to Excel” — but expect manual cleanup on multiline descriptions.
Don’t try this with Chase Business accounts that show “pending” and “posted” side-by-side in one CSV. Those exports split transactions across two rows. You’ll need Power Query’s “Fill Down” and “Group By” steps — not basic formulas.
And never open the CSV by double-clicking. That forces Excel to guess delimiters and encoding. Always use File → Open → select CSV → let the wizard run.
Keyboard Shortcuts
| Action | Shortcut | Notes |
|---|---|---|
| Open Text Import Wizard | Alt+A, T | From Data tab — faster than mouse |
| Format Cells dialog | Ctrl+1 | Critical for fixing date/number display |
| Fill Down | Ctrl+D | After entering formula in C2, select C2:C100, then Ctrl+D |
| AutoSum | Alt+= | Place cursor below Amount column → Alt+= |
