OFX to Excel: How to Open OFX Files in Excel

You downloaded transactions from your bank, double-clicked the .ofx file, and Excel either refused to open it or filled the screen with markup soup. Nothing is wrong with your file or your copy of Excel. OFX simply is not a spreadsheet format, and Excel has no importer for it. This guide explains exactly why the import fails, then walks through three working ways to get OFX data into Excel: a free browser converter that produces a ready-made workbook, a manual Power Query route for the patient, and a direct PDF path for people whose "OFX file" turns out to be a PDF statement.

Why Excel Cannot Open OFX Files

OFX stands for Open Financial Exchange. It is a data interchange format created in 1997 by Microsoft, Intuit, and CheckFree so that banks and personal finance software could exchange transactions in a machine-readable way. The key word is machine-readable. An OFX file describes your transactions with nested tags, not with rows and columns, so a spreadsheet application has nothing to grab onto.

Here is what actually happens when you try to open one in Excel:

• Double-clicking the file: Windows and macOS usually do not associate .ofx with any application, so you get an "open with" prompt. Picking Excel launches the Text Import Wizard, which crams every tag into column A as plain text.
• Forcing it open as XML: If the file is a newer XML-based OFX, Excel offers to open it "As an XML table" and then explodes the nested structure into dozens of metadata columns, with dates and amounts left as unformatted text.
• Older OFX files fail outright: Many banks still export OFX version 1.x, which is SGML rather than XML. SGML tags have no closing counterparts, so Excel's XML parser reports an error and stops. No amount of renaming fixes this.

In short, the file format and the application are speaking different languages. Something has to translate. That translation is the entire job of an OFX to Excel converter, and it is also what you would be doing by hand with Power Query. This article focuses on the specific task of opening OFX data in Excel; for the wider view of output formats and conversion options, see our complete OFX to CSV and Excel guide.

What Is Inside an OFX File?

Knowing what the file contains makes every method below easier to follow. If you open an OFX file in a plain text editor such as Notepad or TextEdit, you will find a header block followed by nested tags describing your bank, your account, and each transaction. A single transaction looks something like this:

<STMTTRN>
  <TRNTYPE>DEBIT
  <DTPOSTED>20260702120000
  <TRNAMT>-54.20
  <FITID>2026070200387
  <NAME>COFFEE ROASTERS LLC
  <MEMO>CARD PURCHASE
</STMTTRN>

Each STMTTRN block is one transaction. TRNTYPE is the transaction type, DTPOSTED is the posting date in compact YYYYMMDD form, TRNAMT is the signed amount (negative for money out, positive for money in), FITID is the bank's unique transaction identifier, and NAME and MEMO carry the payee and description. Notice that in this OFX 1.x example the inner tags never close. That is legal SGML and completely illegal XML, which is why so many manual import attempts die on the spot.

One more useful fact: QFX files from Quicken and QBO files from QuickBooks use the same Open Financial Exchange structure with a different extension, so everything in this guide applies to them too. For a full breakdown of how these formats compare, read our QBO vs OFX vs CSV guide.

Method 1: Use the Free CapyParse OFX to Excel Converter

The fastest route from .ofx to a working spreadsheet is the free CapyParse OFX to Excel converter. It runs entirely in your browser, needs no signup, and handles both OFX 1.x (SGML) and OFX 2.x (XML) files, along with QFX and QBO.

The whole process takes well under a minute, and there is nothing to clean up afterward. Dates sort correctly, amounts sum correctly, and pivot tables work immediately. That last point is the real difference from manual import, where the data arrives as text and every downstream step fights you.

Method 2: Import OFX into Excel Manually with Power Query

If you prefer to stay inside Excel and your file is a newer XML-based OFX (version 2.x), you can import it with Power Query, which ships with Excel 2016 and later under Data > Get Data. Be warned: this route works, but it is fiddly, and it does not work at all for SGML-based OFX 1.x files.

Manual import is a reasonable choice if you enjoy Power Query, need a repeatable refresh from the same bank every month, and know your bank exports valid OFX 2.x. For a one-off conversion, it is nearly always slower than uploading the file to a converter.

Method 3: When Your Statement Is Actually a PDF

A surprising number of people searching for "OFX to Excel" do not have an OFX file at all. They have a PDF bank statement, because their bank either never offered an OFX download or only offers it for a short recent window while older months are PDF-only. If that is your situation, converting the PDF directly skips the OFX step entirely.

CapyParse's bank statement converter reads PDF statements from thousands of banks and turns them into Excel, CSV, or QBO files. Upload the PDF, review the extracted transactions in an interactive preview where you can edit any row before exporting, and download the format you need. It handles multi-month batches, so a full year of statements becomes one consistent workbook instead of twelve copy-paste sessions.

This route also solves the history problem. Banks typically keep several years of PDF statements available even after transaction downloads have aged out, so the PDF is often the only machine-recoverable record of older activity.

Comparing the Three Methods

Troubleshooting Your Converted Data

Whichever method you use, a few OFX conventions surprise people the first time. Here is how to read what you are seeing:

What to Do Once Your Data Is in Excel

A clean transaction table is the starting point, not the finish line. A few quick wins once the workbook is open:

Frequently Asked Questions

Related Articles