How to Convert Excel to QBO and Import to QuickBooks
No account needed for your first conversions. We never store your bank login.
To convert Excel to QBO, upload your .xls or .xlsx file to a converter, confirm it found the date, description, and amount columns, then download a real .qbo Web Connect file and import it into QuickBooks. It takes under a minute for a typical month of transactions, and it works because QuickBooks will not read a spreadsheet directly: the bank-import screens accept .csv, .qbo, .qfx, and .ofx files, but not .xlsx. Use the converter at the top of this page, or follow the four steps below.
QuickBooks Online's manual upload takes a CSV, a QBO, a QFX, or an OFX file, and QuickBooks Desktop imports bank and credit card transactions only through a .qbo Web Connect file. Neither one opens an Excel workbook. You could re-save the sheet as CSV, but then it has to match QuickBooks Online's rigid 3-column (Date, Description, Amount) or 4-column (Date, Description, Credit, Debit) layout, use US-format dates, carry no dollar signs or thousands commas, and stay under 350 KB, or the import fails. Converting straight to .qbo skips every one of those rules, which is why it is usually faster than wrestling a spreadsheet into the importer's format.
How to convert Excel to QBO in four steps
- Open or export your spreadsheet. Use the .xls, .xlsx, or .xlsm file you already have, or export transactions from your bank or accounting tool to Excel. You need at least a date column, a description or payee column, and an amount column. Extra columns like running balance, category, or check number are fine, because the converter only maps the ones it needs and ignores the rest.
- Keep the transactions on one sheet and use values, not formulas. If the workbook has several tabs, put the rows you want to convert on a single sheet. If any amount is a formula, copy the column and use Paste Special, then Values, so the cell holds a real number instead of a calculation the converter has to interpret.
- Upload it to the converter. Drop the Excel file into the converter at the top of this page. It reads the headers automatically, so there is no template to match and no Map columns screen to fill in by hand.
- Check the totals and download the .qbo. Confirm the converter detected the date, description, and amount columns and that the total matches your sheet, then download the .qbo Web Connect file. You also get an XLSX and a clean CSV copy for your own records.
Can QuickBooks import an Excel file directly?
No. QuickBooks Online's bank upload accepts .csv, .qbo, .qfx, and .ofx files, and QuickBooks Desktop imports bank transactions only from a .qbo Web Connect file. An .xlsx or .xls workbook is not on either list. Your two options are to save the sheet as a CSV that fits QuickBooks' strict column layout, or to convert the Excel file to .qbo, which avoids the layout rules and the 350 KB size cap entirely.
Can I save an Excel file as a QBO file?
No. Excel can save to CSV, PDF, and several other formats, but it has no option that writes a .qbo. A .qbo is an OFX-based Web Connect file with specific bank and account headers that QuickBooks reads as a bank feed, and renaming a spreadsheet's extension to .qbo does not create that structure. You need a converter to turn the rows in your workbook into a valid .qbo file.
Does it matter if my file is .xls or .xlsx?
No. A good converter reads the older .xls format, the current .xlsx, .xlsm macro-enabled workbooks, and plain CSV or text exports, so use whichever your bank or accounting tool produced. The extension does not change how the conversion to .qbo works. What matters is that the sheet has a date, a description, and an amount column the converter can find.
What columns does my Excel file need to convert to QBO?
At a minimum, a date column, a description or payee column, and an amount column. Banks that split money in and money out into separate debit and credit columns work too, because the converter reads both the single-amount and the two-column layouts. Columns you do not need, such as running balance, memo, or category, can stay in the workbook; the converter maps only the three fields a .qbo requires and leaves the rest alone.
Why won't my Excel transactions import into QuickBooks?
The common reasons are that QuickBooks does not accept .xlsx at all, or that a CSV you saved from Excel does not match the required column order, has dates in DD/MM/YYYY order, or carries dollar signs and thousands commas that make the amount read as text. Excel also tends to keep amounts as formulas, which can export blank. Converting the workbook to .qbo removes the column rules, reads the cell values rather than the formulas, and drops the size limit, so these errors go away.
Can I convert a multi-sheet Excel workbook to QBO?
Yes, but keep the transactions you want on a single sheet before you upload, because the converter reads one table of rows at a time. If your workbook has a summary tab and a transactions tab, point it at the transactions. To combine several months or accounts, convert each sheet and import the .qbo files one at a time, or batch them in one pass on a paid plan instead of doing them individually.
How do I import the QBO file into QuickBooks?
In QuickBooks Online, go to Transactions, then Bank transactions, choose the account, select Upload from file, and pick the .qbo. In QuickBooks Desktop, go to File, then Utilities, then Import, then Web Connect Files, and select the .qbo. QuickBooks matches the rows to the account and shows them in the bank feed, where you review each one before adding it to the register.
Is it safe to convert Excel to QBO online?
It is safe with a reputable converter that encrypts the upload and deletes files after processing, and an online tool never sees your QuickBooks login. A spreadsheet of transactions holds dates and amounts, not your bank password, so converting one does not expose account access. If your firm's policy bans any cloud upload of client data, a desktop converter that runs locally is the alternative.
The money page for this is the Excel to QBO converter, which handles .xls, .xlsx, and .xlsm workbooks end to end. If your data is already a plain CSV, the how to convert CSV to QBO guide covers that route, and the CSV to QBO converter on the home page does both. Sending the file to QuickBooks Online? See CSV to QuickBooks Online. Using the desktop edition? The CSV to QuickBooks Desktop guide walks through the Web Connect import. Converting many client workbooks at month end? Use the bulk CSV to QBO converter. If the columns do not line up, the map CSV columns to QuickBooks guide explains the mapping, and to compare tools first, the best CSV to QBO converter roundup lays them out side by side.
This all assumes the numbers already sit in a spreadsheet. If yours started life as a PDF bank or credit card statement, turn it into clean Excel columns first with a PDF bank statement to Excel and CSV converter, then convert that to .qbo. For firms running this across many clients, two jobs tend to sit next to the bookkeeping: keeping track of the certificates of insurance your vendors and clients carry, which COI tracking software stops from lapsing, and, for clients with commercial property, pulling the rent schedule and key renewal dates out of each lease so the recurring QuickBooks entries stay accurate, which lease abstraction software handles.