How to Export a Discover Statement to Excel

You have a Discover credit card. You need 12 months of categorized expenses for a tax filing.

It downloads in 30 seconds. It includes the merchant category code (a 4-digit number that classifies each merchant).

The CSV download would have given you the same data without the MCC. The OFX is the right path for accounting.

This page is the Discover credit card export guide. It covers the 2 download options (PDF and OFX), the difference between the OFX and the limited CSV, the Capital One + Discover transition, and how to use the merchant category code in your tax filing.

Discover gives you 5 years of monthly PDF statements and 18 months of combined OFX download. The OFX is the cleanest path because it includes the merchant category code (MCC). The CSV download is limited to 4 basic columns (Date, Description, Amount, Category) and does not include the MCC.

Discover was acquired by Capital One in 2025. The transition is ongoing. If you have an older Discover account, the export flow still goes through Discover’s portal for now. The two portals will eventually merge, but as of early 2026 they are still separate.

Discover Bank (savings accounts, certificates of deposit) is a different entity from Discover credit cards. Discover Bank accounts have a different export flow, covered in the Discover Bank-specific guide. This page is for credit cards only.

What Discover Actually Gives You

Discover’s online portal at discover.com gives credit card holders 2 main export options, plus a third limited option. Here is what each is, and when to use it.

What most guides miss about Excel conversion is that the quality depends on the mechanism, not on the tool. Two tools that look different on the surface often run the same 4-step process underneath: read, find, parse, verify. The difference is in how well each step handles edge cases (merged cells, missing balances, non-standard date formats, scanned vs digital input). Choosing between tools based on UI alone misses the actual quality lever.

• Monthly PDF Statements going back 5 years. One PDF per month. The PDF has the standard Discover branding, the account summary, the reward point summary, and the transaction list with the merchant category code for each transaction.
• Combined OFX Download going back 18 months. This is the cleanest export. The file is a single OFX with all transactions for the date range. It opens in QuickBooks, Xero, and most accounting software. A converter that handles OFX can also turn it into an Excel file.
• Limited CSV Download going back 18 months. Available under the “Download transactions” feature. The file has only 4 columns (Date, Description, Amount, Category). The merchant category code is not included.

For most users, the OFX is the right choice. The PDF is the fallback for history older than 18 months. The CSV is a last resort if you need a file that opens directly in Excel but can live without the MCC.

There is no QFX, no QBO, no combined statement feature. Each Discover card is downloaded separately. The 18-month OFX limit applies per card. This is one of 10 banks covered in our US bank export guide.

How to Download Discover OFX Step by Step

The OFX export is the cleanest path. Here is the click-by-click flow.

1. Log into discover.com with your User ID and Password.
2. Click on the credit card account you want the statement for.
3. Click “Statements” in the navigation.
4. Click “Download” in the upper right corner of the transaction table.
5. Set the date range. The maximum is 18 months.
6. Choose “OFX” from the format dropdown.
7. Click “Download” again. The file saves to your default downloads folder.

The file is named something like discover_activity_2024-07-15_to_2026-01-15.ofx. Open it in QuickBooks or convert it through a tool that handles OFX.

I learned this the hard way the first time a Discover client needed categorized expenses for a Schedule C filing. I downloaded the CSV file, which gave me only 4 columns. I had to manually look up the merchant category code for each transaction.

The OFX export would have given me the MCC directly. The lesson: always use the OFX for accounting purposes, not the CSV.

How to Download Discover PDF Step by Step

The PDF export is in the “Statements” section. Here is the click-by-click flow.

1. Log into discover.com.
2. Click on the credit card account.
3. Click “Statements” in the navigation.
4. You will see a list of monthly statements going back 5 years.
5. Click the statement you want. The PDF opens in your browser.
6. Save the PDF (Ctrl+S or File > Save).

The PDF is one file per month. For 24 months of history, you are downloading 24 files. The PDF includes the merchant category code, the reward points earned, and the full transaction list.

The 18-Month OFX Limit (and How to Work Around It)

Discover’s OFX export is capped at 18 months. If you need 24 months, the extra 6 months need the PDF route. The workflow is:

1. Download the OFX for the last 18 months. Convert it. Save.
2. Download the PDFs for the 6 months before that. Convert each one. Save as separate sheets in the same workbook.
3. Combine in Excel or Google Sheets. The columns are the same across OFX and PDF conversions, so this is a simple append.

For most users, 18 months is enough. The 18-month limit is a Discover portal limit. Older data exists in Discover’s archives. Getting it requires the PDF route or a phone call to customer service.

The Merchant Category Code and Why It Matters

The merchant category code (MCC) is a 4-digit number that classifies each merchant. For Discover credit cards, the MCC is set by the merchant and transmitted with each transaction. Common MCCs include 5812 (restaurants), 5411 (grocery stores), 5541 (gas stations), and 5311 (department stores).

The MCC matters for accounting because it lets you categorize expenses automatically. If you are a freelancer filing a Schedule C, the IRS expects you to categorize your business expenses by type. The MCC gives you a starting point.

For example, if you have 50 transactions at restaurants over 12 months, and all of them have MCC 5812, you can sum them and categorize as “Meals” on your Schedule C. The same applies to other business expense categories.

The MCC is included in the OFX export and the PDF export, but NOT in the limited CSV export. If you need the MCC, you must use the OFX or PDF path. The CSV is a downgrade.

Discover Was Acquired by Capital One in 2025

Capital One completed the acquisition of Discover in 2025. If you have an older Discover account, the export flow still goes through Discover’s portal for now. The two portals will eventually merge, but as of early 2026 they are still separate.

If you have both a Discover credit card and a Capital One credit card, you will need to log into two different portals to get the data. The Discover portal gives you 5 years of PDF and 18 months of OFX. The Capital One portal gives you 5 years of PDF and 24 months of OFX for credit cards.

For the Capital One credit card export flow, see our Capital One export guide.

Discover Credit Card vs Discover Bank

Discover has two separate businesses: Discover credit cards (the orange card) and Discover Bank (savings accounts, certificates of deposit, money market accounts). The export flows are different.

This page is for Discover credit cards. For Discover Bank accounts, the export flow goes through a separate login at discoverbank.com. The Discover Bank portal gives you PDF (monthly, 7 years) and OFX (18 months) for savings accounts. The export flow is similar to Capital One’s 360 banking portal.

For Discover Bank-specific export details, see the credit card statement conversion guide.

How to Convert Discover OFX to Excel

OFX is a structured data file. A converter that handles OFX will read the file and produce a clean Excel file with the transactions.

The output has Date, Description, Amount, Balance, and MCC as separate columns. The date format is YYYY-MM-DD. The amount format is positive for charges, negative for credits. The MCC is a 4-digit number.

The conversion takes 5 to 10 seconds per file. The output is clean. You can open it in Excel or Google Sheets and start working with the data immediately. For QuickBooks users, the OFX is the cleanest path. Our QuickBooks conversion guide covers the import dance for OFX.

How to Convert Discover PDF to Excel

PDF is harder. The transactions are in a 4-column table inside the PDF. A converter needs to recognize that table, extract the rows, and write them as a spreadsheet.

Discover’s PDF layout is standard. Most modern converters handle it. The 2am test: if the converter does not produce a clean Excel file on the first try, try a different one. A good converter should handle Discover’s PDF on the first try. For the broader workflow, our general PDF-to-Excel conversion guide covers the 5-point validation check.

The output for a PDF conversion has the same columns as the OFX output, plus the MCC if the converter recognizes it. The date format may be MM/DD/YYYY instead of YYYY-MM-DD. Check the format and convert it in Excel if needed.

The 2am Test for Discover Conversions

If you are converting Discover statements at 2am, here is the flow that works.

1. Open discover.com. Log in.
2. Click the credit card. Click “Statements”. Click “Download”.
3. Set the date range. Choose OFX. Click Download.
4. If you need more than 18 months, click on individual monthly statements and download the PDFs.
5. Open the OFX file in a converter. Save the output as one sheet.
6. Open each PDF in a converter. Save the output as separate sheets in the same workbook.
7. Combine the sheets in Excel or Google Sheets.

If the converter gives you a file with merged cells, broken dates, or chopped descriptions, the converter is not handling Discover’s format correctly. Try a different converter. The OFX format is standard, not custom. A good converter should produce clean output every time.

A common failure mode bookkeepers report is treating this as a single operation rather than a chain of dependent steps. The temptation is to find a tool that ‘just works’ and stop investigating the mechanism. The result is a wrong-fix cycle: the tool gives partial output, the bookkeeper spends 30+ minutes troubleshooting, the fix is for the wrong step, and the same error recurs on the next statement. The fix: identify which step failed and apply the right intervention to that step.

What to Do With Multiple Discover Cards

If you have multiple Discover credit cards (it Card, it Miles, Chrome) and need them all in one file, the workflow is the same as for a single card: download the OFX for each, convert each, combine in Excel.

Discover does not offer a combined statement feature. Each card is downloaded separately. The 18-month OFX limit applies per card.

For users with many Discover cards, the combined approach is essential for accounting. The OFX files have the same column structure across cards, so combining is just an append operation. Add a “Card” column to identify which card each transaction came from. Our batch conversion guide covers the desktop converter setup for multi-card scenarios.

For a deeper look at the conversion step, see our general guide to converting bank statements to Excel. For QuickBooks users, see our QuickBooks-specific conversion guide. If you have multiple banks to convert at once, see our batch conversion guide. For the full map of which bank gives what, see our US bank export guide. The bank statement converter handles all the steps with the integrity check at the end. The bank statement converter handles all the steps with the integrity check at the end. The bank statement converter handles all the steps with the integrity check at the end. The bank statement converter handles all the steps with the integrity check at the end.