Exporting Chase Transactions Made Easy for Google Sheets
OpenBudget
Simplify your financial management by importing your Chase transactions into a spreadsheet. Our user-friendly guide provides step-by-step instructions.
Explore the following steps to efficiently export your Chase transactions into Google Sheets.
With your transactions now in Google Sheets, the possibilities are endless. Customize reports, monitor spending patterns, and establish a personalized budget that aligns with your financial goals.
How to Export Chase Transactions into Google Sheets or Excel
Step 1: Log in to your Chase account
- Go to the Chase website.
- Enter your online ID and passcode to log in to your account.
- Click "Sign In."
Step 2: Navigate to the Account with the Transactions You Want to Export
- Once you're logged, click on the account you want to export transactions from.
Step 3: Find Download Transactions Button
- Once you're in the account, find the "Account activity" tab.
- Click on the "Download" icon. Highlighted red in the image below.
Step 4: Configure the Download Settings
- Once you click download, a new window will pop up.
- Select the account, date range, and file format you want to download. For Google Sheets, select "spreadsheet (Excel, CSV)" as the file format.
- Configure the date range by selecting "Custom date range" option.
- Select the date range you want to download and click "Download."
Step 5: Open the File in Google Sheets
- Open New Google Sheet.
- Click on "File" in the top left corner.
- Select "Import" from the dropdown menu.
Step 6: Upload the File
- Click on "Upload" tab.
- Drag and drop the file you downloaded from Chase or click on "Browse" button.
- Once the file is uploaded, you will see the transactions in Google Sheets.
- Now you can analyze your transactions the way you want. You can create custom reports, track your spending, and even create a budget.
Skip the manual work — automate it
Instead of downloading CSVs and uploading them every time, OpenBudget can handle all of this automatically. Connect your banks, sync to spreadsheets, or ask AI about your spending — pick what works for you.
Connect your banks
Securely link 10,000+ banks, credit cards, and brokerages via Plaid.
Get started
Sync to spreadsheets
Push transactions to Google Sheets or Excel automatically.
Get started
Ask AI about your money
Connect Claude or ChatGPT and get answers about your spending.
Get startedConnect your bank accounts
OpenBudget uses Plaid to securely connect to over 10,000 financial institutions — the same infrastructure used by Venmo, Robinhood, and Coinbase. Your credentials are never stored on our servers.
Once connected, transactions from your checking accounts, savings, credit cards, and brokerages sync automatically. Each transaction comes with the date, amount, merchant name, and a personal finance category assigned by Plaid — no manual tagging needed.
You can connect as many accounts as you want from different banks, and everything shows up in one place. New transactions appear within minutes of posting.
Connect your banksSync to Google Sheets or Excel
This is the core of what OpenBudget does — it takes the transactions from your connected banks and pushes them directly into your spreadsheet. No more logging into your bank, downloading a CSV, cleaning up the data, and uploading it to Sheets. It just happens.
You pick a Google Sheet or Excel file from your drive, choose which bank accounts should sync to which tabs, and OpenBudget handles the rest. Column headers are created automatically — date, amount, description, account name, institution, category, and more. As new transactions come in, they get appended to the sheet. If a pending transaction updates, the row gets updated too.
You can map multiple bank accounts to the same tab (to see everything in one view) or split them across separate tabs (one per credit card, for example). Your spreadsheet, your rules.
Ask AI about your spending
If you'd rather talk to your data than stare at rows, OpenBudget connects to Claude and ChatGPT through MCP (Model Context Protocol). Once set up, you can ask plain-English questions about your finances and get real answers based on your actual transaction data.
Try things like “What did I spend the most on last month?”, “Show me all my subscriptions”, or “Compare my spending this month vs last month”. The AI reads your transactions in real time — no need to export anything first.
Access is read-only: the AI can see your transactions but can never move money or modify your accounts. Setup takes about 2 minutes on either platform.
Set up ChatGPT