Excel to OFX Converter, Free Online up to 100 Rows

Why OFX?

Xero, Sage Accounting, FreeAgent, Wave and GnuCash import OFX statement files without column mapping, but none of them reads a spreadsheet as-is. Utilly reads the first sheet with data, combines Debit and Credit into one signed amount, gives each row a stable transaction ID and writes a standard OFX file. Have a .csv instead? Use CSV to OFX. Moving into QuickBooks? Use Excel to QBO.

How to convert an Excel sheet to OFX

Put the transactions on the first sheet with data, under one heading row (Date, Description, then Amount or Debit and Credit), and save as .xlsx.
Upload the workbook above. The heading row, date, description and amount columns are picked out for you; opening-balance, total and empty lines are left out.
Look over the preview. Spending should be negative (tick Flip signs if not). For a card sheet choose Credit card, and type the account's last 4 digits if you want them as the account ID.
Download the .OFX and import it into the matching bank or card account in your accounting program.

Which workbooks work

.xlsx and .xlsm files. An old .xls has to be saved as Excel Workbook first, or exported as CSV for the CSV to OFX converter.
Only the first worksheet that has data is read. Empty cover tabs are skipped. If two tabs have transactions, drag the one you want to the front and save.
Bank name or account lines above the table are fine as long as the heading row is in the first 15 rows.
Date cells, or dates typed as text such as 09/30/2026, 2026-09-30 or 30/09/2026 (pick the day-first format in the preview when needed).
One signed Amount column, or two columns like Withdrawal and Deposit, Money out and Money in.
Free up to 100 rows; up to 20,000 rows per workbook.

What ends up in the OFX

The first row of our sample workbook is a 6,420.18 debit on 09/01/2026. In the download it reads:

<STMTTRN><TRNTYPE>DEBIT<DTPOSTED>20260901120000<TRNAMT>-6420.18
<FITID>202609019989CD404B4200<NAME>ACH DEBIT GUSTO PAYROLL 0912
<MEMO>ACH DEBIT GUSTO PAYROLL 0912</STMTTRN>

From your sheet	OFX field
The date cell	DTPOSTED as YYYYMMDD at 12:00, with rows sorted by date.
Amount, or Debit and Credit combined	TRNAMT with two decimals; TRNTYPE DEBIT for money out, CREDIT for money in.
Description	NAME (first 32 characters) and MEMO (all of it), in plain ASCII.
Balance column	The statement's ending balance (LEDGERBAL) when it agrees with every row; 0.00 otherwise. The sample workbook ends at 13,440.52.
Category, notes or other columns	Not written. OFX statement files have no category field.
Not in a spreadsheet	FITID, a transaction ID built from the account, date, amount and description, so converting the same rows again gives the same IDs. Bank ID is the placeholder 999999999.

Where to import it

Program	Menu
Xero	Bank accounts → the account's ⋮ menu → Import a Statement.
Sage Accounting	Banking → bank statement import (one bank account per file).
FreeAgent	Banking → Bank Accounts → the account → Upload Statement.
Wave	Transactions → More → Upload transactions, then pick the account.
GnuCash	File → Import → Import OFX/QFX; choose the account once and it's remembered.
QuickBooks	Pick Excel to QBO instead: Desktop's Web Connect reads only .qbo files. Excel to IIF covers Desktop without Web Connect.
Quicken	Pick Excel to QIF for Quicken for Windows. Quicken checks OFX/QFX files against its online service and doesn't support converted ones, so we don't promise they'll open.

Common problems

Problem	Fix
"Old .xls files aren't supported"	In Excel, File → Save As → Excel Workbook (.xlsx), then upload that.
Dates came through as numbers like 46296	Format the date column as Date in Excel, save and upload again.
The wrong tab was read	Move the transactions tab to the front of the workbook and save.
Deposits imported as spending	Tick Flip signs, or choose the right Debit and Credit columns in the preview, and download again.
Ending balance is 0.00	The Balance column didn't agree with the rows (or there isn't one). Your program works the balance out from the transactions, so check the opening balance there.
Rows imported twice	The workbook overlapped dates already in the account. Remove the extra copies and import only new dates next time.

Other conversions

Have a .csv rather than a workbook? The CSV to OFX converter makes the same OFX. A Quicken .qif? QIF to OFX.
For QuickBooks: Excel to QBO or Excel to IIF. For Quicken for Windows: Excel to QIF. For Xero's CSV template: CSV to Xero (takes .xlsx too).
Only PDF statements? The bank statement PDF to OFX converter balances each statement first.
OFX back to a spreadsheet: OFX / QFX to Excel. Want to look inside one first? See the sample OFX file.

Pricing

Free for files up to 100 transactions, which covers a typical month of activity. Larger files (a year of catch-up, a client's full history) use 1 credit from the same $9 pack of 5 as our PDF statement converter, or unlimited on Pro at $19/month. The preview is always free.

FAQ

Questions

Is it free?

Yes for files up to 100 transactions: no sign-up, no watermark. Bigger files (multi-month catch-up work) use 1 credit from the same $9 / 5-credit pack as our PDF converter, and the preview is always free.

How do I import the OFX file?

Xero: Accounting → Bank accounts → the account's menu icon (⋮) → Import a Statement. Sage Accounting: its bank statement import under Banking (Sage says OFX files upload without editing). FreeAgent: Banking → Bank Accounts → the account → Upload Statement. GnuCash: File → Import → Import OFX/QFX. QuickBooks Online also takes an OFX under Upload from file, but for QuickBooks pick the .QBO output instead.

Is my file stored?

No. Files are processed in memory and deleted after 1 hour. We never use your data for AI training.

Can I try it without uploading my own file?

Yes. Click a sample button under the upload box. It opens a made-up export from a fictional bank in the same preview your own file gets, and every format is free to download, so you can test an import in a test or backup company file first. Don't import a sample into your real books.

Does it read every tab in the workbook?

No, only the first worksheet with data. A blank cover sheet is skipped; if more than one tab has transactions, move the one you want to the front and save.

Which programs open the OFX?

Xero, Sage Accounting, FreeAgent, Wave and GnuCash import it as a bank statement. For QuickBooks choose Excel to QBO, and for Quicken for Windows choose Excel to QIF.

Will it open in Quicken?

We don't promise that. Quicken checks OFX and QFX files with its online service and says it doesn't support converted ones. Excel to QIF is the safer route for Quicken for Windows.

Does the file include my bank's routing number?

No. A spreadsheet doesn't have one, so the bank ID is 999999999 and the account ID is the last 4 digits or nickname you type (or one made from the columns).

Can I make a credit card OFX from Excel?

Yes. Pick Credit card as the account type in the preview and the file is written as a credit card statement, with charges as money out.

Can I convert a CSV to OFX the same way?

Yes. The CSV to OFX converter writes the same OFX from a .csv file, with the same column detection and preview.

Convert Excel (.xlsx) to OFX

Why OFX?

How to convert an Excel sheet to OFX

Which workbooks work

What ends up in the OFX

Where to import it

Common problems

Other conversions

Pricing

Questions

Other converters

Convert CSV to QBO for QuickBooks

Convert Excel (.xlsx) to QBO for QuickBooks

Convert CSV to IIF for QuickBooks Desktop

Convert Excel to IIF for QuickBooks Desktop

Convert OFX or QFX to IIF

Convert a .QBO file to IIF

More bookkeeping tools

Receipts & invoices to CSV

Bank reconciliation checker

QuickBooks reconciliation discrepancy finder