QBO Format

Excel to QBO Converter Free Online: Import to QuickBooks

QuickBooks Desktop does have an Import from Excel menu, which is exactly why this is confusing. It takes customers, vendors, items and a chart of accounts — and no bank transactions at all. Those arrive one way only, as a Web Connect file. Upload a workbook above and the columns are auto-detected — date, description and amount found in the data rather than matched on a mapping screen — and the .qbo downloads instantly, in the browser, without a signup. Dates arrive as dates rather than the serial numbers Excel keeps underneath. That is all there is to how to import Excel to QBO, and from there into QuickBooks.

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 .qbo from a CSV instead
Only got the PDF?
Skip the spreadsheet entirely
On TallyPrime?
The same sheet as Tally vouchers

Why Use Our Excel to QBO Converter Tool?

It finds the sheet with the transactions

Bank workbooks open on a cover or summary tab, and converters that ask you to choose a sheet make that your problem. The sheet carrying an actual table is the one read here, wherever it sits in the workbook.

Dates stay dates

Excel stores 13/05/2025 as the number 45790, so a careless reader hands QuickBooks five-digit integers where the dates should be. Every cell is taken as it displays, and a title block above the table is stepped over rather than mistaken for the header row.

You set what QuickBooks checks

Account type, account number, currency and the bank the file claims to come from are all yours to set before the download. Those four are what QuickBooks inspects on the way in, and guessing them is what makes an import fail on a file whose data was fine. Everything else about the excel to qbo file is filled in for you.

How to convert Excel to QBO in three steps

1

Start with the workbook you have

An .xls or .xlsx from net banking, a card issuer, an accounting export or one you built yourself. Several sheets is fine, and so is a header that does not sit on row one — there is no template to copy your rows into before you convert Excel to QBO.

2

Upload the spreadsheet

Drop it in the box above to upload Excel to QBO, up to 10MB. Conversion is instant and browser-based — the workbook is parsed on your own machine rather than queued on a server. Date, description and amount are located in the data, so there is no mapping screen and no template to match your columns against. Both spreadsheet formats work — convert xls to qbo or xlsx to qbo makes no difference to what comes out.

3

Set the account details, then download

Pick the account type, the currency and which bank the file should say it came from, and add the account number if you want it to match. Download the .qbo, then in QuickBooks use File, Utilities, Import Data and choose Web Connect Files.

Where an Excel import into QuickBooks Desktop goes wrong

The Excel import only does lists

File → Utilities → Import → Excel Files is real and it works, which is the whole problem. Intuit restricts it to customers, vendors, items and the chart of accounts, so it succeeds on a list and simply has no option for bank transactions — people reasonably assume the feature covers both.

Excel hands over numbers where dates belong

A date cell holds a serial number, not text, and 13/05/2025 is really 45790 underneath. Read carelessly the whole statement arrives as five-digit integers, which QuickBooks either rejects outright or accepts as dates decades from now.

The workbook opens on the wrong tab

Bank exports lead with a cover or summary sheet more often than not. A converter that grabs whichever tab comes first reads a heading and a logo, finds no transactions, and produces an empty file without saying anything went wrong.

The paid importers want a subscription

Saasant, Dancing Numbers and similar tools do import Excel transactions into Desktop, and they charge monthly and connect directly to the company file to do it. That is a reasonable trade for daily bulk work and a poor one for a spreadsheet you need in once.

Who needs a spreadsheet turned into a .qbo

QuickBooks Desktop users

Desktop accepts bank transactions through Web Connect and nothing else, so an Excel to QuickBooks Desktop import always means converting first. A spreadsheet that took an hour to tidy still has to become a .qbo file before Desktop will look at it.

Banks with no direct feed

Smaller banks, credit unions and payment processors often publish an .xlsx download and no Web Connect feed at all. Converting xlsx to qbo is then the only way those transactions reach the books without being typed.

Sheets built by hand

Petty cash, a director loan account, reimbursements tracked in a workbook — real transactions that never came from a bank feed and still belong in the books.

Cleaning up before import

A spreadsheet is where duplicates get removed and categories get fixed. That editing is the reason the file is Excel by the time it needs importing.

Closing an old year

Transactions older than Web Connect's window cannot be re-downloaded from the bank, but a saved spreadsheet of them converts and imports normally.

Bookkeepers billing by hour

Paid importers charge a monthly subscription per company file. Occasional work across many clients rarely justifies one, and a converter costs nothing per file.

Frequently Asked Questions — Excel to QBO Converter

QCan QuickBooks Desktop import a spreadsheet of bank transactions?

No. Desktop accepts bank transactions as Web Connect (.qbo) files and in no other way — not Excel, not CSV, not PDF. The Import from Excel menu that does exist is for list data, so how to import Excel transactions into QuickBooks Desktop has one real answer: convert the workbook to .qbo, then import that. Working out how to import Excel into QuickBooks Desktop any other way ends at a menu that will not offer transactions.

QWhat does QuickBooks' Import from Excel actually import?

Customers, vendors, items and the chart of accounts. Intuit documents the Excel and CSV toolkit as a list-management feature, which is why it appears to work perfectly and then offers nothing for transactions. Anyone hoping to import an Excel bank statement into QuickBooks that way has found the wrong menu, not a broken one — which is why an Excel to QuickBooks converter exists at all.

QWhich sheet gets read if my workbook has several?

The one holding a transaction table. Bank exports commonly lead with a cover or summary tab, so sheets are scored by how many rows carry a date, a description and an amount, and the winner is read regardless of its position in the workbook. That is the step where a converter most often goes quietly wrong: pick the cover tab and it reads a heading, finds nothing, and hands back an empty file.

QMy dates turned into numbers like 45790. What happened?

That is the date, as Excel stores it internally — a count of days rather than text. Any tool that reads the raw cell instead of the displayed value hands those integers straight to QuickBooks. Here the displayed value is taken, so 45790 stays 13/05/2025.

QHow do I upload Excel to QBO here — is there anything to set up first?

Nothing at all — it is an Excel to QBO converter online that auto-detects your columns, so there is no install, no signup and nothing to configure first. Several converters open with a column mapping screen where you match each column to a field, which is work your spreadsheet already describes. Date, description and amount are located in the data itself, whatever order they sit in and whatever the headings are called.

QWhich account type should I choose?

Match the account the transactions belong to — checking, savings or credit card. It is written into the file and QuickBooks reads it when deciding which register to offer, so a credit card statement labelled as checking will import into the wrong place even though every figure is right.

QWhy does it ask which bank the file came from?

Because QuickBooks checks a financial institution id on the way in and shows that bank's name in the import dialog. Picking yours makes the file present as it would if the bank had issued it; the transactions are identical either way, but the dialog is far less alarming.

QCan I import Excel to QuickBooks Online without converting it?

Yes, and it is worth knowing before you convert anything: an Excel to QuickBooks Online import is supported natively, so if that is where the books live you may not need this at all. Whether you can import Excel into QuickBooks Online, or connect Excel to QuickBooks Online directly, both land here. What sends people back to a converter is that the uploader is strict about column order and date format and rejects the file without naming the column that offended it. A .qbo sidesteps the whole dialog, so plenty of Online users convert anyway.

QWhat is a Web Connect file?

The format QuickBooks was built to receive bank data in — an OFX document with an Intuit identifier that names the institution, saved as .qbo. It carries an id per transaction, which is how QuickBooks recognises one it has already seen. To create a QBO file from Excel by hand you would be writing that structure yourself, which is what this does for you.

QWhat is the best Excel to QBO converter?

It depends on how often you do it. For daily bulk work SaasAnt Transactions is the stronger tool — it imports Excel transactions into Desktop directly and handles invoices and journal entries this does not touch — but it runs $25 a month for one company file and $30 for several, with no permanent free tier. Big Red Consulting sells an Excel add-in that writes QBO, OFX and QFX for $79 the first year and $69 after, Windows only. For getting a spreadsheet of bank rows in, a converted .qbo needs no install, no connection to your company file and no fee at all.

QWill importing the same spreadsheet twice duplicate everything?

No. Each transaction is given an id derived from its own contents, so a second import presents QuickBooks with ids it has already recorded and they are recognised rather than added again. Two genuinely different files never collide. This matters more than it sounds when you import Excel to QBO monthly: converters that number transactions sequentially per file restart at one every month, and QuickBooks then either duplicates the lot or refuses rows that are perfectly real.

QMy workbook has formulas, merged cells and a logo on top. Does that matter?

Not to the conversion. Formulas are read as the values they display, a title block above the table is skipped to find the real header row, and blank spacer rows are dropped. Nothing needs tidying before upload.

QIs this Excel to QBO converter free, or is there a limit?

Free, with no trial ceiling and no cap on transactions — the only limits are the 10MB upload and 50,000 rows from one sheet, neither of which a bank statement reaches. Nothing is held back for a paid tier, because the conversion runs in your browser and costs nothing per file to perform.

QDoes my spreadsheet get uploaded anywhere?

The file itself does not — it is read in your browser and the .qbo is assembled there too. The transaction rows alone are sent out so the columns can be identified, and nothing about the workbook, its name or its other sheets goes with them.

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

Give QuickBooks the file it will actually take

Your bank sent a spreadsheet and QuickBooks wants Web Connect. Convert Excel to QBO here in about ten seconds, set the account details the import dialog checks, and upload Excel to QuickBooks the way it was designed to receive it. You can convert Excel to QBO free, with no account and nothing to install.