Skip to content

Excel to QBO converter

Convert bank transactions in an Excel spreadsheet (XLSX, XLS or ODS) into a QuickBooks .qbo file, OFX, QFX or QIF. Private — the workbook never leaves your computer.

🔒 Never uploaded✓ Balances reconciled🏦 Any bank's CSV or Excel🆓 Free, no signup

Works with real spreadsheets

  • Pick the sheet if the workbook has several; Bankfold suggests the one that holds transactions.
  • Title rows, account details and blank rows above the table are skipped automatically.
  • Excel date cells, text dates and numbers stored as text are all understood.
  • Change any column's meaning with the dropdown above it — your choice is remembered for next month's file.

Typical uses

Statements your bank exports as Excel, transactions a client sends you in a spreadsheet, a PDF statement you've already converted to Excel (our sister tool TidyLedger does that privately too), or a cash log you keep by hand.

How it works

  1. Drop your bank or card export — CSV, TXT or an Excel/ODS spreadsheet.
  2. Check the columns. Bankfold detects the date, description, amounts and balance; change any column with its dropdown.
  3. Review and download a QBO, QFX, OFX, QIF or CSV file ready to import.

FAQ

Is it really private?

Yes. Your file is read and converted by JavaScript running in your browser tab. Its contents are never sent over the network. You can verify this in your browser's developer tools (Network tab), or disconnect from the internet after the page has loaded — conversion still works.

Which banks are supported?

Any bank or card that exports CSV, TXT or Excel — Chase, Bank of America, Wells Fargo, Capital One, Citi, American Express, RBC, TD, Barclays, HSBC, Monzo, Revolut, CommBank, Sparkasse and thousands more. Bankfold detects the columns automatically, and you can change any column with a dropdown; your choice is remembered for that layout.

Can it convert PDF statements?

Not directly — Bankfold converts CSV and spreadsheet exports. For PDF statements, use our sister tool TidyLedger, which also runs entirely in your browser.

Will QuickBooks import duplicates if I convert overlapping statements?

No, as long as the transactions are the same. Every transaction gets an ID based on its date, amount and description, so QuickBooks and Quicken recognize ones they've already imported.

Which file should I download?

QuickBooks Desktop or Online: QBO. Quicken: QFX. Xero, Sage, Wave, FreeAgent, GnuCash and most other apps: OFX. Older software: QIF. QuickBooks Online also accepts our 3- or 4-column CSV.

What's free?

Every format, one file at a time, up to 150 transactions per conversion. No account needed. Pro removes the limit and lets you merge several statements into one import with duplicates removed.