QuickBooks Online vs Desktop CSV Import Compared

The short version: QuickBooks Online can import a CSV, but QuickBooks Desktop cannot. QuickBooks Online has a manual Upload from file tool that reads a CSV with Date, Description, and Amount columns. QuickBooks Desktop has no CSV importer for bank or credit card transactions at all; it only takes a .qbo Web Connect file. The one file that imports into both is a .qbo, which is why converting your CSV to .qbo is the reliable path no matter which version you run.

That single difference trips up a lot of people moving between the two products or setting up a new company file. The question comes up most during a migration. With Intuit winding down QuickBooks Desktop, including ending new Desktop for Mac sales after September 30, 2024, more firms are moving historical transactions into QuickBooks Online and finding that the two products treat a CSV very differently.

Below is how each one actually handles a CSV, the formats they accept, and how to get the same transactions into either version without keying them in by hand. You can convert a CSV or Excel export to a .qbo with the tool at the top of this page, then follow the steps for your version.

Notice the bottom row: a converted .qbo works in both products. That is the practical takeaway. Instead of fighting QuickBooks Online's column rules or hunting for a CSV importer in Desktop that does not exist, you convert the spreadsheet once and import the same file wherever your books live. The converter above reads the date, description, and amount columns in any order, cleans up the dates and amounts, and writes a .qbo with a unique ID on each transaction so QuickBooks does not create duplicates.

When a QuickBooks Online CSV import does fail, the cause is almost always the file, not the product. The usual culprits are a DD/MM/YYYY date that QuickBooks reads as the wrong month, dollar signs or thousands commas left in the Amount column that turn the value into text, and a bank export that splits money in and money out across two columns when you mapped a single amount. A .qbo sidesteps all three, because the converter normalizes the dates, strips the symbols, and resolves the debit and credit columns before it writes the file.

Can QuickBooks Online import a CSV file?

Yes. QuickBooks Online imports a CSV through Transactions, Bank transactions, Upload from file. The file needs a Date, a Description, and either one Amount column or separate Credit and Debit columns, with up to 1,000 rows and a size under 350 KB. Larger or messier files import more reliably as a .qbo.

Can QuickBooks Desktop import a CSV file?

Not for bank or credit card transactions. QuickBooks Desktop can import lists such as customers, vendors, and items from CSV, but it has no tool to import transactions from a CSV. To bring in bank or card activity, convert the CSV to a .qbo Web Connect file and import it under File, Utilities, Import, Web Connect Files.

What file formats can QuickBooks Online import for bank transactions?

QuickBooks Online accepts CSV, TXT, QBO, QFX, and OFX for manual bank uploads, and Intuit lists .qbo as the suggested format. A .qbo carries the bank identity and a unique ID on each transaction, so it imports more cleanly than a raw CSV that has to match the strict 3-column or 4-column layout.

Why doesn't QuickBooks Desktop have a CSV import for transactions?

QuickBooks Desktop was built around Web Connect, the .qbo format banks use for downloads, so its transaction importer expects that structure rather than a free-form spreadsheet. A CSV has no fixed layout and no transaction IDs, which is why Desktop will not read one. Converting the CSV to .qbo gives Desktop the structure it needs.

Is it easier to import a CSV into QuickBooks Online or Desktop?

QuickBooks Online is easier for a one-off CSV because it has a built-in upload, though the file still has to match its column rules. For Desktop, or for any file QuickBooks Online rejects, converting to .qbo first is simpler and more reliable, since the .qbo skips the column mapping and format checks entirely and imports as a standard bank feed.

Can I import the same CSV into both QuickBooks Online and Desktop?

Yes, once you convert it to a .qbo. The .qbo Web Connect file is the one format both products read: QuickBooks Online accepts it in the manual upload, and QuickBooks Desktop imports it through File, Utilities, Import, Web Connect Files. Convert the CSV once and use the same file in either version.

Should I switch from QuickBooks Desktop to Online just to import CSVs?

Not for that reason alone. Plenty of firms stay on Desktop and simply convert CSVs to .qbo when they need to import transactions. Moving to QuickBooks Online is a bigger decision about hosting, multi-user access, and features. Whichever you run, a converted .qbo handles the CSV import without forcing a product change.

Ready to import? If your books are online, the CSV to QuickBooks Online converter walks through the upload and bank-feed match. On Desktop, the CSV to QuickBooks Desktop guide covers the Web Connect route step by step. Working from a spreadsheet, use the Excel to QBO converter; on a Mac, the CSV to QBO converter for Mac runs in the browser with no install. For a stack of client files, the bulk CSV to QBO converter handles them in one pass, and the map CSV columns to QuickBooks guide explains the column rules QuickBooks Online enforces.

This guide assumes your transactions already live in a CSV. If they are locked in a PDF statement, export the PDF bank statement to a clean Excel or CSV file first so the columns line up before you import. For other paperwork that feeds the books, pull data out of scanned documents into a spreadsheet, and if your firm also tracks vendor orders, keeping purchase orders and approvals organized alongside the bookkeeping keeps the accounts payable side in sync.