QuickBooks Web Connect File Converter: Turn a CSV into a .qbo

Turn a bank or card CSV into a QuickBooks Web Connect (.qbo) file here. Import it into QuickBooks Online or Desktop when your bank drops the Web Connect download.

Totals reconcile to the original QuickBooks Online and Desktop
csv / xls / xlsx → .qbo
No file handy?

No account needed for your first conversions. We never store your bank login.

Short answer: A QuickBooks Web Connect file is the .qbo file you import into QuickBooks, and this converter builds one from a plain CSV. Upload the CSV your bank or card exported, and the tool writes a valid Web Connect (.qbo) file with the dates, descriptions, and amounts signed the way QuickBooks expects. QuickBooks Online imports it under Transactions, and QuickBooks Desktop reads it through File, Utilities, Import, Web Connect Files.

Web Connect is the manual download method Intuit built for banks: you sign in to your bank, download a .qbo file, and import it into QuickBooks without ever typing your bank password into QuickBooks. It is the most reliable way to get transactions in. The problem is that a growing number of banks and cards have dropped the Web Connect download, or never offered it, leaving you with only a CSV. This page turns that CSV back into the Web Connect file QuickBooks wants.

A real .qbo file QuickBooks accepts

Built for the CSV and Excel exports US banks and cards actually send, checked before it exports.

Reconciliation

Every total checked against your file

The converter adds up the transactions it parsed and matches that to your file total before you export, so nothing is silently dropped.

Web Connect

A genuine .qbo, not a renamed CSV

Valid OFX 1.02 with QuickBooks Web Connect headers. Online and Desktop import it as a standard bank feed.

Column mapping

Your columns mapped automatically

Date, description, and amount are detected for you, so you skip QuickBooks' strict 3-column and 4-column CSV layout.

Volume

A year of CSV files in one batch

Bulk upload for catch-up and cleanup work. Each file gets its own reconciliation check and its own exports.

Dates and amounts

Dates and amounts fixed for you

Mixed date formats, currency symbols, and stray commas that break a raw CSV import are cleaned up before the .qbo is built.

Exports

Excel and CSV in the same download

One conversion, three files: the .qbo for QuickBooks, an XLSX to review, and a CSV for everything else.

How to convert your CSV to QuickBooks

Three steps. No column-mapping wizard.

1

Upload your CSV or Excel file

Drag in a CSV, XLS, or XLSX export from your bank, credit card, or accounting tool. Any column order is fine.

2

Review the reconciled rows

Every transaction is parsed and checked against your file total. You see the rows before exporting.

3

Import into QuickBooks

Download the .qbo and import it as a Web Connect bank feed. Excel and CSV are in the same download.

Questions worth answering

The specifics that decide whether the import is clean. If your case is not here, message us in chat.

What is a QuickBooks Web Connect file?

A QuickBooks Web Connect file is a .qbo file, a small text file in Intuit's OFX format that holds your transactions plus your bank and account identifiers. You download it from your bank's website and import it into QuickBooks, which reads the transactions directly with no column mapping. Quicken uses the same idea with a .qfx file. Web Connect is a one-way import: it brings transactions in, but does not let QuickBooks send anything back to the bank.

Web Connect vs Direct Connect vs Express Web Connect

Intuit offers three connection types, and they are easy to mix up. This table lays out what each one does and where a converted .qbo fits.

Connection typeHow it worksYou download a file?Notes
Web ConnectYou download a .qbo from the bank and import itYes, a .qbo fileManual, reliable, one-way; this is what the converter produces
Direct ConnectQuickBooks pulls transactions automatically, two-wayNoIntuit is retiring Direct Connect on October 30, 2026
Express Web ConnectIntuit aggregates transactions from your bank login nightlyNoAutomatic but drops and duplicates often
How do I convert a CSV into a Web Connect (.qbo) file?

Upload your CSV in the converter at the top of this page. The tool detects the date, description, and amount columns, normalizes the dates, strips currency symbols, and checks the parsed total against your file before it writes the .qbo. Download the Web Connect file and import it into the matching account in QuickBooks. The conversion runs in your browser and takes under a minute, with no account or install.

Why doesn't my bank offer a Web Connect download anymore?

Several banks have retired the Web Connect (.qbo) download, and Intuit is retiring Direct Connect for QuickBooks on October 30, 2026, with new enrollments ending April 30, 2026. As those options disappear, many banks leave only a CSV or PDF export. Since QuickBooks Desktop cannot import a raw CSV of bank transactions, converting the CSV into a Web Connect file is the practical way to keep importing cleanly.

How do I import a Web Connect file into QuickBooks Online?

In QuickBooks Online, open Transactions, then Bank transactions, choose the account, and use the upload option to add the .qbo file. QuickBooks reads it, lists the transactions for review, and posts them when you accept. Because a Web Connect file already carries the fields QuickBooks needs, you skip the column-matching screen that a raw CSV upload forces on you.

How do I import a Web Connect file into QuickBooks Desktop?

In QuickBooks Desktop, go to File, then Utilities, then Import, then Web Connect Files, and select the .qbo you downloaded here. Match it to the correct account when prompted, and the transactions post to that register. This is the only transaction-import path QuickBooks Desktop supports for bank and card activity, which is why a Web Connect file matters when your bank only gives you a CSV.

What is the difference between a .qbo file and a CSV?

A CSV is a plain spreadsheet of rows and columns with no bank identifiers, so QuickBooks Desktop cannot import it and QuickBooks Online has to be told which column is which. A .qbo Web Connect file wraps the same transactions in Intuit's OFX structure with account and financial-institution tags, so both QuickBooks Online and Desktop read it directly. Converting a CSV to .qbo is what makes the file importable without manual mapping.

Why do I get a Web Connect import error in QuickBooks?

Web Connect import errors (such as OL-201, OL-202, or a generic import failure) usually come from a malformed file, a mismatched account, or an expired financial-institution ID. A file built by this converter uses valid OFX structure and current formatting, which clears the malformed-file cause. If you still see an error, confirm you are importing into the matching account and follow the fixes in our Web Connect import error guide.

Is there a transaction limit for a Web Connect file?

No fixed row limit applies to a .qbo import the way the 350 KB cap applies to a raw CSV upload in QuickBooks Online. That means you can bring a full year of history into QuickBooks in one Web Connect file instead of splitting it. To convert several statements at once, the bulk CSV to QBO converter processes them in a single batch.

Is the converted Web Connect file accurate?

Yes, and the accuracy check is the point. Before the .qbo downloads, the converter sums every transaction it parsed and compares that to the total in your file. If a row is missing or misread, you catch it in the preview instead of during reconciliation. You only export once the parsed rows match your file, so the Web Connect file mirrors your statement exactly.

Convert your first file free.

Upload a CSV or Excel export, get a QuickBooks-ready .qbo back in seconds. No card to try it.

Related guides

Related guides: start with the CSV to QBO converter, read what changes now that Intuit is retiring the automatic feed on the Direct Connect alternative page, import into the desktop app with CSV to QuickBooks Desktop, compare tools on the best CSV to QBO converter page, and follow the steps to import a QBO file into QuickBooks.