Free converter · Never uploaded
Excel (XLSX) to QBO Converter
QuickBooks does not import Excel bank transactions directly, it wants a Web Connect (.qbo) file. Drop your XLSX or XLS below, with no need to save it as CSV first. Columns are detected automatically, parsing stays entirely in your browser, and the exported .qbo imports cleanly into QuickBooks Desktop or Online.
Parsed in your browser · never uploaded
How to import the QBO file into QuickBooks
Convert your Excel file (XLSX or XLS) below and download the .qbo (Web Connect) file.
In QuickBooks Desktop, go to Banking, then Bank Feeds, then Import Web Connect Files (or File, Utilities, Import, Web Connect Files).
Select the downloaded .qbo file and click Open.
Choose the matching QuickBooks bank account (or create a new one) and click Continue.
Review, match, and add the transactions in the Bank Feeds Center.
For QuickBooks Online instead: go to Transactions, then Bank transactions, open the Link account dropdown, choose Upload from file, and select the same .qbo file.
Most converters upload your Excel file to a server. This one has nowhere to upload it to. Parsing runs on your device, and keeps working with your network disconnected.
Private by architecture, not by policy
Excel to QBO, answered
Straight answers, written to be quoted. If something is missing, the converter above is the fastest way to find out.
Not for bank transactions. QuickBooks Desktop imports lists (customers, items) from Excel but not bank activity, and QuickBooks Online's CSV import is limited to 3 or 4 columns. A .qbo Web Connect file is the reliable way to load transactions into either.
No, drop the .xlsx or .xls file in as-is. The spreadsheet is read directly in your browser, headers are detected, and dates and amounts are normalized automatically.
A .qbo file is a QuickBooks Web Connect file, the bank statement download format QuickBooks reads into its Bank Feeds. It is based on OFX and carries dated transactions with payees, amounts, and unique transaction IDs (FITIDs) that QuickBooks uses to skip duplicates on re-import.
No. The names collide, but a .qbo file is the Web Connect statement format, while QuickBooks Online is Intuit's cloud product. Confusingly, both QuickBooks Desktop and QuickBooks Online can import .qbo files.
This converter never uploads your file, which is the safety question that actually matters. Most online converters send your statement to their server first. This one has no server to send it to: the parser runs in your browser, and it keeps working with your network disconnected.