How to Export Your Discover Transactions to a Spreadsheet

Discover offers several types of accounts, including credit cards, checking, and savings. Whether you’re tracking Discover card purchases, cashback rewards activity, or Discover Bank account transactions, you can export your transaction history to CSV and then import it into your own spreadsheet.

This guide walks through the full export process step by step for both Discover credit cards and Discover Bank accounts. If you manage Discover alongside accounts at other institutions or you want your data to stay current without manual downloads, the end of this guide covers how to connect Discover to a spreadsheet automatically so new transactions arrive daily with no effort.

How to export Discover credit card transactions as a CSV

Step 1: Log in to your Discover account

Go to discover.com and sign in to your account.

Step 2: Navigate to your card account

From the account overview, select your Discover credit card account.

Step 3: Go to your transaction history

Click on Activity & Statements or the transaction history section of your card account.

Step 4: Find the download option

Look for a Download button or link near the transaction list. Discover typically displays this as a labeled link above or near the transaction history.

Step 5: Choose your date range and file format

• Set a date range for the transactions you want. Discover typically allows exports going back up to 7 years for credit card accounts.
• Choose CSV as the file format for best compatibility with Google Sheets and Excel.
• Discover may also offer OFX and QFX options. These are intended for Quicken and not ideal for direct spreadsheet import.

Step 6: Download the file

Click Download and save the CSV file to your computer.

How to export Discover Bank transactions as a CSV

The process for Discover Bank checking and savings accounts follows the same pattern but starts from a different section of the account portal.

Step 1: Log in at discover.com and navigate to your Discover Bank checking or savings account.

Step 2: Click on Account Activity or your transaction list.

Step 3: Look for a Download Transactions or Export option near the top of the transaction list.

Step 4: Select your date range and choose CSV as the file format.

Step 5: Download the file and save it to your computer.

How to open your Discover CSV in Google Sheets

1. Go to sheets.new to open a new Google Sheet, or go to the home page for your Google Drive or Sheets account.
2. Click File → Open → Upload.
3. Drag and drop your downloaded CSV file or click Browse to locate it.
4. Google Sheets will import the file and display your Discover transactions.

How to open your Discover CSV in Microsoft Excel

1. Open Excel and click File → Open.
2. Browse to your downloaded CSV file and open it.
3. If the Text Import Wizard appears, select Delimited, click Next, check Comma, and click Finish.
4. Your Discover transactions will appear in columns ready to work with.

For Excel Online: go to excel.cloud.microsoft, click Upload a File, and select your CSV.

Discover’s credit card CSV typically includes columns for Transaction Date, Post Date, Description, Amount, and Category. The Category column is a useful starting point since Discover pre-categorizes many transactions, which can save time if you’re building a budget sheet from scratch. The Amount column uses negative values for charges and positive values for payments and credits, which is the format that most budget spreadsheets use.

Limitations of manual Discover exports

There are a few things to keep in mind with Discover CSV exports:

• Separate exports per account: If you have a Discover credit card and a Discover Bank account, each requires its own separate download.
• No scheduling: There’s no automated export option. You repeat the full process manually every time you want to update the data.
• Pending transactions: Pending credit card charges don’t appear in exports until they post, so your export may miss recent activity.
• Cashback tracking: Discover’s CSV doesn’t include a dedicated cashback rewards column. If you’re tracking rewards value, you’ll need to add that manually.

Automate Discover transaction tracking with Tiller

If you’re tracking Discover alongside other financial accounts or just want your spreadsheet to always reflect current data, Tiller removes the export process entirely.

Tiller connects your Discover credit cards and Discover Bank accounts directly to Google Sheets or Excel and delivers transactions automatically each day. All your Discover activity appears pre-formatted in your spreadsheet alongside any other connected institutions. Tiller’s Foundation Template lets you keep a clear view of your finances in one place. 

AutoCat handles categorization automatically based on rules you set. Discover’s own pre-categorization can inform your AutoCat rules. If Discover calls a merchant “Restaurants,” you can create a matching AutoCat rule to tag it as Dining Out in your spreadsheet automatically.

Frequently asked questions

Q: Does Discover let me export both credit card and bank account transactions?

Yes, but separately. Discover credit card and Discover Bank accounts each have their own export process. You’ll need to log into each account type and run separate downloads. Tiller connects both account types simultaneously and consolidates everything into one spreadsheet automatically.

Q: How far back can I export Discover credit card transaction history?

Discover credit card accounts typically allow exports going back up to 7 years. Discover Bank checking and savings accounts may have shorter export windows. Check your current account interface for exact date range limits.

Q: Discover pre-categorizes some of my transactions. Can I use that in my spreadsheet?

Yes. Discover’s CSV export includes a Category column with their pre-assigned categories for many transactions. You can use this as a starting point in your spreadsheet, either keeping Discover’s categories or using them to build AutoCat rules in Tiller that apply your own preferred category labels automatically.

Q: What file format should I choose when downloading Discover transactions?

Choose CSV for Google Sheets or Excel. Discover may also offer OFX or QFX formats, but these are designed for Quicken and aren’t ideal for direct spreadsheet import.

Q: Can Tiller automatically import Discover transactions into my spreadsheet?

Yes. Tiller supports both Discover credit card and Discover Bank account connections and delivers transactions daily into Google Sheets or Excel alongside your other financial accounts.

Q: Does Discover’s CSV include cashback rewards data?

Yes. Tiller supports both Discover credit card and Discover Bank account connections and delivers transactions daily into Google Sheets or Excel alongside your other financial accounts.