How to Export a Bank Statement to Excel: A Guide for Every US Bank

This page is the directory of bank statement export, by bank. It tells you what each bank gives you (PDF, OFX, QFX, or CSV), where the download button lives in the online portal, and what to do with the file after you download it.

TL;DR. Exporting a bank statement to Excel works at every major US bank, with 3 methods: bank website download (CSV, fastest), bank customer service request (PDF or Excel), third-party converter (any format, cleanest output). The 4 standard columns are Date, Description, Amount, Balance. The 3 common problems: state-specific routing numbers, masked account numbers, multi-format exports. A converter normalizes the output.

The detailed export guides for 11 major US banks are linked below, organized by cycle behavior and the format each bank supports.

Most major US banks offer 24 to 60 months of monthly PDF statements and 12 to 24 months of combined OFX or QFX. The download path varies by bank. Chase, Wells Fargo, and Bank of America put the download in the Documents section. Capital One hides it under Account History. Ally has it in the More menu.

The 3 things that differ between banks: the cycle date (when the statement closes), the format options (PDF only vs PDF + OFX vs PDF + QFX + CSV), and the business account path (some banks have a separate portal for business banking).

For specific banks, see the guides below. For the broader conversion workflow, see the converter guide.

Why Every Bank Has a Different Export Flow

There is no federal rule that says banks must offer a standard export format. Each bank builds its own online portal, and the download button is whatever the portal team decided to ship that quarter. That is why the experience is so different from bank to bank.

What you can rely on: every US bank and credit card issuer offers some way to download a statement. The format and the steps vary. The 5 formats you will encounter are PDF, CSV, OFX, QFX, and QBO, each with different tradeoffs.

• PDF is the most common. It is what you see when you open the statement in your browser. It is also the hardest to convert because the data is locked inside a layout.
• CSV is the second most common. It is a plain text file with commas separating the columns. Banks that give CSV usually give a clean one with Date, Description, Amount, and Balance.
• OFX and QFX are the older banking standards. OFX is open. QFX is Intuit’s proprietary version. Both are accepted by QuickBooks and most accounting software.
• QBO is QuickBooks’ own format. A few banks (Chase, Wells Fargo, and Capital One among them) will let you download directly as QBO. If you use QuickBooks, this is the cleanest path.

Some banks also offer Excel and Quicken formats. Those are less common and not always reliable. Treat them as PDFs unless you open the file and see real transaction data.

What File Format Each Bank Gives

Here is the quick reference. Use this if you already know your bank and just want the format. The detailed steps for each bank are in the sections below.

• Bank of America: PDF (12 monthly) and OFX (combined). No CSV for most accounts.
• Chase: PDF (combined or monthly) and QBO. CSV is not offered.
• Wells Fargo: PDF (monthly) and QFX (combined). No CSV directly.
• Citibank: PDF (monthly) and CSV (combined). Both are clean.
• Capital One: PDF (monthly) and OFX (combined). No CSV for 360 accounts.
• PNC: PDF (monthly) only. No QFX, no OFX, no CSV without a workaround.
• US Bank: PDF (monthly) and QFX (combined). Limited history.
• TD Bank: PDF (monthly) and OFX (combined). 84-month history.
• HSBC: PDF (monthly) and CSV (combined). 7-year history.
• Ally: PDF (monthly) and QFX (combined). 7-year history. Online-only bank.
• Discover (credit card): PDF (monthly) and OFX (combined). 5-year history.
• American Express (credit card): PDF (monthly) and CSV (combined). 5-year history.

National Banks: The Big 4

The four largest US banks (Chase, Bank of America, Wells Fargo, and Citibank) cover roughly half of all US households. Each has a different export flow, and the differences matter when you have a deadline.

Chase

Chase’s export flow is the most forgiving. The “Download activity” button on the account page gives you a single combined file covering whatever date range you pick. You can choose PDF, CSV, or QBO.

If you are a QuickBooks user, download QBO and skip the conversion step entirely. Chase’s statement history goes back 7 years for checking and savings accounts, and 5 years for credit cards. The full Chase bank statement export walkthrough covers the click-by-click and the OFX vs QBO choice.

Bank of America

Bank of America’s portal is the most painful. BofA splits statements by month and by account. If you have 3 accounts (checking, savings, credit card), you download 3 separate files, each one a PDF covering one month.

There is no combined export, and there is no way to get the QBO format. The history goes back 18 months for most accounts, 7 years if you are a Preferred Rewards client. The OFX download is hidden under “Download account activity” and only works for the last 3 months.

The full Bank of America export guide shows how to handle 36+ PDFs without losing a day.

Wells Fargo

Wells Fargo gives you monthly PDF statements going back 7 years, plus a combined QFX download for the last 24 months. The QFX download is the right choice for QuickBooks users. For Excel, you will need the PDF.

Wells Fargo does not offer CSV directly. The QFX file is clean and will open in most accounting software, but Excel does not read it natively. You will need to convert it through a tool that handles OFX/QFX files. The full Wells Fargo export walkthrough covers the QFX download path and the historical PDF route.

Citibank

Citi is the only major bank that gives you a clean CSV. The “Account Activity” page lets you pick a date range (up to 7 years) and download a single CSV with all transactions, including the running balance.

The CSV is well-formatted, with Date, Description, Amount, and Balance as separate columns. This is the cleanest export of any major US bank. Citi also gives PDF for monthly statements, and OFX for older history. The full Citibank export guide shows the 30-second click-by-click for the CSV download.

Regional Banks: Capital One, PNC, US Bank, TD

The regional banks (Capital One, PNC, US Bank, and TD Bank) cover the second tier of US households. They tend to offer less flexible export flows than the Big 4, but each has its own quirks that are worth knowing.

Capital One

Capital One gives you monthly PDF statements going back 7 years for 360 Performance Savings and 360 Checking accounts. The “Account history” page lets you download OFX for the last 18 months. There is no CSV export, and no QBO format.

Capital One acquired Discover in 2025, so if you have an older Discover account, the export flow may still go through Discover’s portal for a transition period. The full Capital One export guide covers the hidden “Account History” page and how to use the OFX for QuickBooks.

PNC

PNC is the most restrictive. Monthly PDF statements are available for 84 months (7 years), but there is no QFX, no OFX, and no CSV export at all. PNC does offer a “Download transactions” feature inside the account activity page, but the file is a screenshot-style PDF, not a data file.

The only path to a usable file is to convert the monthly PDF. This is a 12-file-per-year chore for PNC users, and PNC business accounts are the only path with OFX. The full PNC export guide covers the 252-file problem and the business account workaround.

US Bank

US Bank offers PDF (monthly, 24 months) and QFX (combined, 18 months). There is no CSV export. The QFX file is clean and will work in QuickBooks. For Excel, you will need to convert the PDF. US Bank business accounts have a slightly different flow with a “Download transactions” button that gives OFX for the last 12 months.

The full US Bank export guide walks through both paths.

TD Bank

TD Bank offers PDF (monthly, 84 months) and OFX (combined, 18 months). TD also has a quirk: if you have a Canadian TD account, the export flow goes through a different portal (TD Canada Trust) and gives you CSV instead of OFX.

For US-based accounts, the US portal applies. CSV is not offered for US

accounts. The full TD Bank export guide covers the cross-border consideration.

Online-Only Banks: Ally

Online-only banks (Ally, Discover Bank, Marcus, SoFi) have newer portals and tend to have cleaner export flows. Ally is the largest of these and is covered below.

Ally

Ally’s “Statements and Documents” page gives you PDF (monthly, 7 years) and QFX (combined, 18 months). There is no CSV export, but the QFX file is clean and will work in QuickBooks.

Ally also has a “Download transactions” button inside the account activity page that gives a CSV of the last 18 months. This is hidden under the “More” menu. If you find it, use it. It is the cleanest Ally export. The full Ally export guide shows how to find the hidden CSV button.

Credit Cards: Discover, American Express

Credit card statements are different from bank statements in two ways. The transaction format includes merchant category codes (the MCC, which is a 4-digit number that classifies the merchant). And the export flow is often separate from the issuer’s main banking portal.

Discover

Discover gives you PDF (monthly, 5 years) and OFX (combined, 18 months). The OFX file is clean. Discover does not offer CSV, but the OFX will work in QuickBooks.

Discover’s portal also has a “Download transactions” feature that gives a CSV of the last 18 months, but the file is limited to the 4 basic columns (Date, Description, Amount, Category). If you need merchant category codes, you need the OFX. The full Discover export guide covers the OFX-with-MCC path and the Capital One transition.

American Express

Amex gives you PDF (monthly, 5 years) and CSV (combined, 5 years). The Amex CSV is the cleanest of any major credit card issuer, with Date, Description, Amount, Category, and Card Member. If you have multiple Amex cards on the same account, the CSV will include all of them.

The PDF is also good quality. Amex does not offer QBO or OFX directly. The full Amex export guide walks through the multi-card CSV download.

What to Do If Your Bank Is Not on This List

If your bank is not on this list, the export flow follows the same pattern. Log into the online portal, find “Statements” or “Documents” in the account menu, look for a download button. If the bank offers a download, it is usually one of the 5 formats above.

Three fallback options for banks that do not offer a download at all:

1. Use the bank’s mobile app. Some banks (especially smaller credit unions) have a download feature in the app that is missing from the desktop portal. Worth a try before giving up.
2. Request a statement by phone. You can call the bank’s customer service and ask them to mail or email you a CSV. Some banks will do this. Some will not. Some will only send a PDF.
3. Convert the screen view. If all else fails, the bank’s portal will at least show your transactions in a table. You can copy and paste from the table into Excel, then clean up the formatting. This is the worst option, but it works.

The 3 Things to Do After You Download

You have the file. Now what? Three steps to get from download to clean Excel.

1. Open the file and check the first 5 transactions. If the date column shows “01/05/2025” instead of “2025-01-05”, your file uses a non-standard date format. Note it. If the description column has 30-character truncation, note it. These are the quirks your converter needs to handle.
2. Run a converter if the file is PDF. If you downloaded PDF (and most banks give PDF), you need a converter. Our general guide to converting bank statements to Excel covers the conversion step for every format. A good converter reads the PDF and produces a clean CSV or Excel file with the transactions extracted. The conversion takes 10 to 30 seconds per statement.
3. Reconcile the converted file against the original. Open the PDF next to the Excel file. Count the transactions in each. If the counts match, you are done. If not, find the gap and convert again with different settings. The 2am test: if you cannot reconcile in 5 minutes, the converter is not right. Find a different one. Our batch conversion guide covers how to handle multiple files at once.

For QuickBooks users, the cleanest path is to download QBO (if your bank offers it) or use a converter that produces a QuickBooks-ready file. The QuickBooks-specific conversion guide covers the import dance for QBO and Desktop.