OFX Format

Excel to OFX Converter Free Online: Set the Account

The conversion is the easy half. The half that goes wrong is the import afterwards, when a file that says nothing about which account it came from gets filed against whichever register you happened to pick the first time. An OFX carries the account number and the currency inside it, and a spreadsheet states neither — so you are asked for them here, before the file is written, rather than left to sort it out in your accounting software later. Put the workbook in as it stands: .xls or .xlsx, cover sheet and all, nothing to re-save and nothing to install.

Bank-grade security - Files processed securely and deleted immediately
Trouble converting a file? Tell us — we fix issues fast. Report it

Not the file you need?

Exported as CSV?
The same .ofx from a plain-text export
Statement came as a PDF?
Straight to .ofx, no spreadsheet in between
Need categories kept?
QIF carries a category, OFX has no such field
Using Quicken?
Quicken needs .qfx — plain OFX is refused
QuickBooks Desktop?
Desktop wants a .qbo, not an .ofx
Using TallyPrime?
The same sheet as Tally XML vouchers

Why Use Our Excel to OFX Converter Tool?

The account travels with the file

The account number you enter is written into the file as the account it belongs to, and the currency alongside it, so your software has something real to match against instead of a placeholder every converted file shares. That is the difference between an import that files itself correctly the first time and one you spend the evening unpicking.

The workbook goes in untouched

The sheet holding the transactions is found for you, so a cover tab, a logo block or three heading rows above the table need no tidying first, and dates Excel is storing as five-digit serial numbers are read as the dates they represent rather than arriving as 45790. Both .xls and .xlsx open the same way, with no Save As to CSV — the step nearly every free alternative opens with.

Nothing to install, nothing to expire

The best-known Excel to OFX tool is an add-in costing $79 for the first year and $69 to renew, tied to Excel for Windows, and its trial stops after 100 transactions. This runs in a browser tab on any machine, has no per-file ceiling that truncates a long statement, and asks nobody for install permissions — an Excel to OFX converter free of trial caps and annual renewals rather than free until you reach the interesting part.

How to convert Excel to OFX in three steps

1

Bring the workbook as it is

Whatever your bank sent or whatever you keep yourself — .xls and .xlsx are read the same way, so converting xlsx to OFX and xls to OFX are one job here. There is no template to paste your rows into and no CSV to save out first, which is where most alternatives begin.

2

Upload the spreadsheet

Click to browse, or drag the workbook straight in. Whichever tab the transactions actually sit on is the one that gets read, so a cover page or a block of headings above the table can stay exactly where it is.

3

Answer three questions, take the file

A spreadsheet records neither what kind of account it came from, nor its number, nor its currency — and an OFX file has to state all three. Set them and the Excel to OFX conversion is finished.

Why an OFX file lands in the wrong place

The importer remembers the wrong account

GnuCash asks once which register an imported file belongs to, stores the answer against the account named inside the file, and applies it silently every time afterwards. When two different accounts convert to files that name themselves identically, the second import inherits the first one's answer and the rows land in the wrong register without a single warning. Undoing it means the Import Map Editor and a manual clean-up. Giving each account its own number at conversion time is what stops the two files looking like the same account.

Some software checks before it imports

Not every importer is equally forgiving. Some read the identifying fields inside an OFX and decline a file whose account details do not match the one you are importing into — which is the better failure of the two, since a refusal is visible where a silent misfile is not, but it still means a file written with placeholder details may not go in at all. Filling the account number and currency in before you download is what keeps that from being a question.

The software people name most cannot open this file

Quicken is the destination most often typed alongside a spreadsheet, and it is the one program here that will not take an OFX. It reads QFX — this format with an Intuit header attached — and refuses everything else, however well formed. The confusion is worth naming rather than glossing over, because searching for a way out of Excel and into Quicken surfaces OFX as though it were the obvious answer, and it is not. The file Quicken accepts is a .qfx, and the CSV to QFX converter is where that comes from.

Re-importing an overlapping month doubles it

Every transaction in an OFX carries an identifier, and your software uses it to recognise rows it has already seen — which is how OFX avoids the duplicate pile-up that catches QIF users. It only works if the identifiers are stable, so a row edited in the sheet between two conversions reads as a new transaction rather than the one already filed. Line the conversions up so no period is done twice and the question never comes up.

Who converts a workbook to OFX

Two accounts, one importer

GnuCash remembers which register it filed your last import into and quietly reuses that choice for the next file from the same source. Give each account its own number here and the second workbook stops landing on top of the first.

Stricter importers

Some accounting software reads the identifying details inside an OFX and will not accept a file whose account does not match the one you are importing into. Setting the number and currency before download costs nothing and removes the question.

Multi-currency bookkeepers

An OFX has to declare a currency and a spreadsheet almost never states one, so converters that assume dollars relabel a euro or sterling account without mentioning it. The currency is asked for rather than guessed.

Anyone on a Mac

The established Excel to OFX tool is an add-in for Excel on Windows, which leaves Mac users with no version at any price. A browser tab has no such requirement.

Credit card statements

A card account and a bank account are different containers inside an OFX, and cards imported as bank rows arrive in the wrong register with their signs reversed. Which one it is gets asked before the file is written.

Locked-down work machines

Add-ins and desktop converters both need permission to install, which is exactly what a managed laptop withholds. Nothing is installed here, so there is nothing to get approved.

Frequently Asked Questions — Excel to OFX Converter

QHow do I convert an Excel file to OFX?

Three things happen and then you have the file: the workbook goes up, you state the account type, its number and its currency, and the .ofx comes back down. No mapping grid appears in between — which column holds the date and which holds the amount is read off the sheet rather than asked about. People arrive at this wanting slightly different things (convert Excel to OFX file, xls to OFX, xlsx to OFX, create an OFX file from Excel) and all of them are this one upload. Because it runs inside the browser, Windows, macOS and Linux behave identically.

QWhat is an OFX file?

OFX is short for Open Financial Exchange, a format that banks and personal-finance programs have used to hand transactions to one another since the late 1990s. What sets it apart from a plain list of rows is the header at the top: before a single transaction appears, the file declares what kind of account this is, its number, and the currency it is kept in. That header is the part a spreadsheet has no way of supplying by itself, which is exactly why those three questions get asked before the download.

QWhich software reads OFX files?

GnuCash, Xero, Sage, MoneyDance, Banktivity, YNAB, Microsoft Money and QuickBooks Online, among others. The two notable exceptions are Quicken, which needs QFX, and QuickBooks Desktop, which needs QBO — both of those are OFX with an Intuit header added, and both have their own converter here.

QWhy does it ask for my account number?

Because the OFX file has a field for it and your spreadsheet does not. That field is how your software decides which of your accounts the transactions belong to, and when it is left as a placeholder every file you convert looks like the same account to the importer. GnuCash in particular stores its answer and reuses it silently, so two accounts sharing a placeholder is how a month of rows ends up in the wrong register. Nothing you type is kept once the file is written.

QWhat if I do not know the account number?

Leave it and the file is still written — you will get a placeholder, which is perfectly fine when you only ever import one account and your software asks you where to file it. It matters when you keep more than one account in the same software, and it matters with any importer strict enough to check the field before accepting a file. Any consistent identifier works; it does not have to be the full number from your statement.

QCan Quicken open an OFX made from a spreadsheet?

It cannot, and a tool that tells you otherwise is handing you a rejection. Quicken reads QFX only — this same format carrying an Intuit institution header — and turns away plain OFX no matter how correct its contents are. The route that does work is a .qfx: save the workbook out as CSV, then run it through the CSV to QFX converter. Every other program named on this page opens a plain OFX without complaint.

QHow do I import an OFX file into GnuCash?

File → Import → Import OFX/QFX, choose the file, then pick the account it belongs to. Worth knowing that GnuCash only asks that question once: the answer is stored against the account named inside the file and reused for every later import from the same source. If a file ever lands in the wrong register, Tools → Import Map Editor is where that stored answer is corrected.

QWhat is the best Excel to OFX converter?

It depends on how often you do it and what you are running. Big Red Consulting's XL to OFX Converter is the established paid option at $79 for the first year and $69 to renew, and it writes OFX, QFX and QBO — but it is an Excel add-in for Windows, has no Mac build at any price, and its trial stops at 100 transactions. ProperSoft's ProperConvert is a paid desktop program covering similar ground and is the one competitor whose documentation is honest about the account identity fields mattering. The free web tools are quicker to reach but most take CSV only, and of the handful that read a workbook, few let you set the account number at all. Converting weekly, a licence pays for itself. For a statement now and then, a browser tab has the file written while an installer would still be downloading.

QIs there an Excel to OFX add-in?

Yes, and that is the form most paid tools take — they install into Excel and add a Save As OFX command to the ribbon. It works well if you are on Excel for Windows and convert often. It rules out Macs, rules out Excel for the web, and rules out any machine where installing software is not your decision, which between them is a large share of the people looking for this. Converting in a browser sidesteps all three. And Excel itself has never shipped an OFX export, in any release on any platform — those add-ins exist because of that absence, not alongside it.

QMy dates came out as numbers like 45790. What happened?

That is Excel storing a date as a serial number counting from 1900, and it is what you get from tools that read the raw cell value instead of the date it represents. Serial numbers are converted back to real dates here before the file is written, so 45790 arrives as 13 May 2025. It is the single most common way an Excel conversion goes wrong, and it is worth opening any converted file to check, whatever tool produced it.

QMy workbook has several sheets. Which one is used?

The one with the transactions on it. Sheets are examined rather than assumed, so the cover page many banks put first, or a summary tab sitting before the detail, does not need deleting beforehand. The same applies within a sheet: a logo, an address block or a few heading rows above the table are skipped over rather than being read as data.

QDoes the conversion change my amounts?

No. Currency signs and grouping marks come off, a comma decimal is understood as readily as a full stop, and if withdrawals and deposits occupy two separate columns they collapse into the one signed figure OFX expects. Nothing is rounded and nothing is recalculated — what reaches your accounting software is what the sheet said, to the penny.

QWhat happens to the account number I type in?

It is used to write the file and nothing else — it is not stored, not logged and never sent anywhere, because the .ofx is assembled in your browser and the number goes straight into it. The workbook is handled the same way, so neither file crosses the network. What does go out is the row data on its own, so that the columns can be identified — it is held for the length of that one request and retained by nobody.

Other Conversion Formats

PDF to QIF Converter

Convert to QIF

CSV to QIF Converter

Convert to QIF

CSV to QBO Converter

Convert to QBO

CSV to OFX Converter

Convert to OFX

CSV to QFX Converter

Convert to QFX

CSV to IIF Converter

Convert to IIF

Write the file with the account already on it

Your bank sends a spreadsheet and your accounting software wants an OFX. Convert Excel to OFX online free in the panel above, set the account number and currency while you are there, and import a file that names the account it actually came from. Nothing to install, and no cap that cuts a long statement short.