Is my bank file uploaded anywhere?

No. The conversion runs in your web browser. Your file is never sent to ConvertDepot or anyone else, and the page keeps working if you disconnect from the internet after it loads.

Which programs can import the OFX file?

GnuCash, Moneydance, Banktivity, YNAB, MoneyWiz, Microsoft Money and most other programs that accept OFX or "Money" files. For Quicken, use the QFX converter instead.

Do I need to enter my account number?

No. Some programs use it to match the file to the right account, so entering the last four digits can save a step, but any value works. Use the same value every time for the same account.

If I import two overlapping files, will I get duplicates?

Usually not. Each transaction gets an ID built from its date, amount and description, so the same transaction gets the same ID every time and most programs skip the copy.

What does the balance field do?

OFX files include a closing balance, and some programs show it next to your account. Enter the balance before the first transaction in your file and the closing balance is worked out for you. Leave it blank if you don't need it.

Why are accented letters missing from payee names?

The converter writes the widely supported OFX 1.02 format, which is plain ASCII, so "Café" becomes "Cafe". This avoids garbled names in programs that read older OFX files strictly.

CSV to OFX Converter

Turn a bank or credit card CSV download into an OFX file, the standard bank statement format most budgeting and accounting programs can import.

Private by design. Your file is converted right here in your browser. It is never uploaded to ConvertDepot or anyone else.

1Choose your CSV file

Drop a .csv file here
or click to choose one

No file handy? Try it with the sample CSV.

How to convert a CSV file to OFX

Download your transactions from your bank's website as a CSV file.
Drop the file into the box above. The converter guesses which column holds the date, payee and amount.
Choose the account type. The account and routing numbers are optional.
Check the preview, then download the .ofx file and import it into your budgeting program.

What is an OFX file?

OFX (Open Financial Exchange) is a bank statement format created in 1997 by Intuit, Microsoft and CheckFree. Banks use it for downloads labeled "Money", "OFX" or "Web Connect", and it is the format most budgeting and accounting programs prefer, because each transaction carries a unique ID that helps prevent duplicate imports.

This converter writes OFX version 1.02, the most widely supported version. A transaction looks like this:

<STMTTRN>
<TRNTYPE>CREDIT
<DTPOSTED>20261015120000
<TRNAMT>1850.00
<FITID>20261015-5d2d9447
<NAME>PAYROLL DEPOSIT
<MEMO>Direct deposit
</STMTTRN>

OFX, QFX or QIF?

OFX is the general standard. Use it for GnuCash, Moneydance, Banktivity, YNAB, MoneyWiz and most others.
QFX is Quicken's version of OFX with an extra Intuit bank ID. Quicken expects QFX rather than plain OFX. See CSV to QFX.
QIF is an older, simpler Quicken format without transaction IDs. Some programs still prefer it. See CSV to QIF.

Importing the OFX file

GnuCash

Choose File > Import > Import OFX/QFX. The first time, GnuCash asks which account the file belongs to and remembers the answer for next time.

Moneydance and Banktivity

Choose File > Import and pick the .ofx file. Both match the file to an account using the account number in the file.

YNAB

Open the account and choose File Import, then pick the .ofx file. YNAB shows the transactions for review before adding them.

Things to know

Use the same account number every time. Programs that match by account number will otherwise treat each file as a new account.
Credit cards. Choose Credit card as the account type. Purchases should be negative and payments positive in the preview. If not, tick Flip signs.
Dates. Each transaction is dated at noon, so a time zone difference in your program can't push it to the day before.
Long payee names. OFX limits payee names to 32 characters. When a name is longer, the full name goes in the memo.

Sample file

The sample CSV looks like a typical checking account download, with account details above the table and separate withdrawal and deposit columns. Drop it in the box above to try the converter.

Frequently asked questions

Is my bank file uploaded anywhere?: No. The conversion runs in your web browser. Your file is never sent to ConvertDepot or anyone else, and the page keeps working if you disconnect from the internet after it loads.
Which programs can import the OFX file?: GnuCash, Moneydance, Banktivity, YNAB, MoneyWiz, Microsoft Money and most other programs that accept OFX or "Money" files. For Quicken, use the QFX converter instead.
Do I need to enter my account number?: No. Some programs use it to match the file to the right account, so entering the last four digits can save a step, but any value works. Use the same value every time for the same account.
If I import two overlapping files, will I get duplicates?: Usually not. Each transaction gets an ID built from its date, amount and description, so the same transaction gets the same ID every time and most programs skip the copy.
What does the balance field do?: OFX files include a closing balance, and some programs show it next to your account. Enter the balance before the first transaction in your file and the closing balance is worked out for you. Leave it blank if you don't need it.
Why are accented letters missing from payee names?: The converter writes the widely supported OFX 1.02 format, which is plain ASCII, so "Café" becomes "Cafe". This avoids garbled names in programs that read older OFX files strictly.