Skip to content

Free · no sign-up · nothing uploaded

Excel to QBO converter

Convert a spreadsheet of bank or card transactions (.xlsx, .xls or .ods) into a QBO file that QuickBooks imports. Free, no sign-up, and the file never leaves your browser.

The converter didn’t start. Reload the page to try again. If it still doesn’t, your browser may be too old for it: it needs Chrome or Edge 110, Safari 16.4, Firefox 115 or newer.

Read in your browser. Nothing is uploaded.

How it works

Excel in, QBO out. Nothing uploaded.

The whole conversion runs in your browser tab, so your transactions never reach a server.

  1. 01

    Drop your spreadsheet

    An .xlsx, .xls or .ods file with one row per transaction. CSVs work too.

  2. 02

    Check the columns

    Date, description and amount columns are found for you. The preview shows the first rows exactly as they will import.

  3. 03

    Download the QBO

    Built in your browser in the layout QuickBooks expects, ready to import.

What it reads

Your bank’s export, as it is

No need to tidy the file first. Each format below is detected on its own, and anything that can’t be read is listed by row instead of silently dropped.

Columns
One signed amount, money out and money in, or an amount with a debit/credit column. Balance and check number optional.
Dates
10/31/2026, 31/10/2026, 31.10.26, 2026-10-31, 20261031, 31 Oct 2026, Oct 31, 2026, with or without a time.
Numbers
1,234.56 · 1.234,56 · 1 234,56 · (12.40) · 12.40- · 12.40 DR · $, £, €, ₹ and currency codes.
Files
Comma, semicolon, tab or pipe separated; UTF-8 or Windows encoding; title rows above the header; Excel .xlsx, .xls, .ods.

Import

Import into QuickBooks

QuickBooks Online

  1. 1.Go to Transactions, then Bank transactions.
  2. 2.Choose Upload transactions (under the Link account menu on some screens).
  3. 3.Pick the .qbo file, then the QuickBooks account it belongs to.
  4. 4.Review the transactions on the For review tab and add or match them.

QuickBooks Desktop

  1. 1.Choose File, Utilities, Import, Web Connect Files.
  2. 2.Pick the .qbo file.
  3. 3.Link it to an existing account or create a new one.
  4. 4.Accept the transactions in the Bank Feeds center.

FAQ

Excel to QBO, answered

Is my file uploaded anywhere?
No. The file is read by code running in your browser tab and the QBO, OFX or QFX file is built there too. Nothing is sent to our servers, so there is no copy to delete afterwards.
Which sheet is used?
The sheet with the most filled rows. Title rows and notes above the column names are skipped, and dates are read from the cell values, so it doesn’t matter how Excel displays them.
What columns does the file need?
A date, a description, and either one amount column or separate money out and money in columns. A balance column is optional: when there is one, every row is checked against it. A check number column is carried into the file too, so QuickBooks can match checks.
Why are my amounts the wrong way round?
Most credit card exports list purchases as positive numbers. Choose “Credit card” under Account, and tick “Charges are positive in this file” if the preview still shows purchases as money in. When the file has a balance column, the tool works this out from the balance for you.
Will importing the same file twice create duplicates?
Each transaction gets an ID (FITID) built from its date, amount and description, so the same file always produces the same IDs. QuickBooks, Quicken and most other programs use these IDs to skip transactions they already have.
Is it really free?
Yes. Converting CSV and Excel files is free with no limit and no account. If you only have PDF statements, the PDF converter reads those, with a free allowance every day.