Convert Excel to QBO for QuickBooks — free, private, no signup

Drop an .xlsx (or .xls / .csv) transaction export — from your bank, your card portal, or a spreadsheet you maintain by hand. The first sheet is read automatically, date / description / amount columns are auto-detected, and the finished .QBO (Web Connect) file imports straight into QuickBooks. Everything runs in your browser — your data never leaves your device.

Drag & drop your .xlsx or .csv file here

Your file never leaves your device — conversion runs 100% in your browser.

…or paste CSV content directly (first line can be headers)

Routing number (optional, written into QBO) Account number (optional, written into QBO)

Preview

#	Date	Description	Amount (USD)

How to convert Excel to QBO

Drop your spreadsheet

Use an .xlsx or .xls transaction export — or a plain CSV. The first sheet is read and the header row is detected automatically. You can also paste CSV text directly.

Check the column mapping

The parser shows which columns it picked for date, description and amount. Every cell in the preview is editable, so fix anything before exporting.

Download the QBO

Import via Banking → Upload transactions in QuickBooks Online, or File → Utilities → Import → Web Connect in Desktop. Stable transaction IDs mean re-imports don't duplicate.

Frequently asked questions

What files does this work with?

Excel workbooks (.xlsx and legacy .xls) and plain CSV files — downloads from US banks and credit card portals, or spreadsheets you maintain yourself. For a workbook, the first sheet is used; it needs a date column and an amount column. The parser auto-detects the columns and shows you the mapping it chose before you export.

My sheet has separate debit and credit columns — is that supported?

Yes. Columns headed "Debit"/"Withdrawal" and "Credit"/"Deposit" are recognized automatically: debits become negative amounts and credits positive. A single signed amount column works too, including parentheses-style negatives like (60.00).

What if the column detection guesses wrong?

You'll see the detected mapping ("Date → X, Amount → Y") above the preview, plus a warning when several columns look plausible. Every cell in the preview table is editable, so you can fix dates, descriptions, or amounts — or delete stray rows — before downloading the QBO.

Is my spreadsheet uploaded anywhere?

No. The file is read and converted entirely by JavaScript running in your browser tab. Nothing is sent to any server — you can even load this page, disconnect from the internet, and keep converting.

How do I get the QBO into QuickBooks?

QuickBooks Online: Banking → Upload transactions, pick the .qbo file, choose the account, and review. QuickBooks Desktop: File → Utilities → Import → Web Connect. Each transaction carries a stable ID, so re-importing the same file won't duplicate entries.

Which date and amount formats are recognized?

Dates: US-style MM/DD/YYYY and M/D/YY, ISO YYYY-MM-DD, plus written forms like "05 Jan 2026" or "Jan 5, 2026". Amounts: dollar signs and thousand separators are fine, and negatives work as either a leading minus or accounting-style parentheses — (60.00) becomes -60.00.

I already paid but lost my license key — what do I do?

Your license key is shown on your Gumroad receipt, which was sent to your inbox right after purchase — search for "Gumroad" and open that receipt to copy the key. Then use the "Enter license key" link in the top navigation to reactivate unlimited exports.