Can QuickBooks Import CSV Files? Online and Desktop
No account needed for your first conversions. We never store your bank login.
Short answer: QuickBooks Online can import a bank-transaction CSV, but only in a specific layout (3 or 4 columns, English, 350 KB or smaller, 1,000 rows or fewer per upload). QuickBooks Desktop cannot import a bank CSV in any version; its only import route for transactions is a .qbo Web Connect file. So the answer depends entirely on which edition you run, and for Desktop you will need to convert the CSV first.
This is one of the most common questions bookkeepers and business owners ask before a migration or a catch-up, and the wrong assumption wastes hours. Below is a straight breakdown of what each QuickBooks edition actually accepts, the exact format rules, and how to get transactions in when the native path is blocked. Last updated July 2026.
Can QuickBooks Online import CSV files?
Yes. QuickBooks Online imports bank and credit card transactions from a CSV, but the file has to match one of two fixed layouts: a 3-column file (Date, Description, Amount) or a 4-column file (Date, Description, Credit, Debit). The file must be in English, one consistent date format, 350 KB or smaller, and 1,000 rows or fewer per upload. Anything outside those bounds fails or posts incorrectly.
QuickBooks Online can also import lists (customers, vendors, chart of accounts, products) from CSV or Excel, and it accepts .qbo, .qfx, and .ofx bank files. If your bank export is close to the required shape, you can upload it directly under Transactions, then Bank transactions, then Upload from file. When the columns, dates, or amount signs do not line up, see the exact QuickBooks CSV import template and format requirements before you retry, because most failed uploads are format problems, not data problems.
Can QuickBooks Desktop import CSV files?
No. QuickBooks Desktop (Pro, Premier, and Enterprise, both Windows and the discontinued Mac line) cannot import a bank CSV of transactions in any version. There is no menu, add-in, or setting that reads a raw CSV of bank activity into the register. The supported route is Banking, then Bank Feeds, then Import Web Connect File, which only accepts a .qbo file.
That single limitation is why so many Desktop users end up stuck. Your bank hands you a CSV or Excel export, Desktop refuses it, and the built-in bank feed may be unavailable for your institution. The fix is to convert the CSV into a .qbo Web Connect file, which we cover step by step in how to import a CSV file into QuickBooks Desktop. Our CSV to QuickBooks Desktop converter produces exactly that file from any bank CSV or Excel export.
Why won't QuickBooks import my CSV file?
If QuickBooks Online rejects a CSV, the cause is almost always the format. The most frequent reasons are extra or misnamed columns, a missing or duplicated header row, mixed date formats, amounts stored as text, files over 350 KB or 1,000 rows, and non-English characters. Fix the layout to match the 3 or 4 column template and the same file usually uploads cleanly.
Date formatting alone accounts for a large share of failures, because QuickBooks reads the first row to guess the format and then applies it to everything. If some rows use MM/DD/YYYY and others use DD/MM/YYYY, the import silently posts wrong dates. Our guide to the QuickBooks CSV import date format shows how to force one consistent format in Excel.
What CSV format does QuickBooks Online need?
QuickBooks Online accepts two bank CSV layouts. Match one of them exactly, keep a single header row, and use one date format throughout.
| Requirement | 3-column CSV | 4-column CSV |
|---|---|---|
| Columns | Date, Description, Amount | Date, Description, Credit, Debit |
| Sign convention | Negative = money out | Split into two columns |
| Header row | One row, at top | One row, at top |
| Date format | One consistent format | One consistent format |
| Language | English only | English only |
| File size | 350 KB max | 350 KB max |
| Rows per upload | 1,000 max | 1,000 max |
There is no official downloadable template file from Intuit, so you build the layout yourself in a spreadsheet or let a converter handle it. If your export runs past 1,000 rows, split it into monthly files or convert it to a .qbo, which sidesteps the column mapping entirely. The QuickBooks CSV import limit guide covers the size and row caps in detail, including why a .qbo does not raise the QBO upload cap.
Which is better: CSV import or a .qbo file?
For QuickBooks Online, a small, clean CSV imports fine, but a .qbo file is more reliable because it carries a bank ID and a unique transaction ID (FITID) that lets QuickBooks block duplicate re-imports. For QuickBooks Desktop, there is no choice: .qbo is the only path. A .qbo also preserves the exact posting so you do not have to fix signs or date formats by hand.
The tradeoff is that a raw CSV is easy to edit but easy to break, while a .qbo needs to be generated by a tool. If you convert regularly across accounts, using a dedicated CSV to QBO converter is faster than reformatting spreadsheets every month. For businesses tracking card spend across several accounts, pairing clean imports with an expense management workflow keeps categorization consistent after the data lands in QuickBooks.
Can QuickBooks import credit card transactions from CSV?
Yes, in QuickBooks Online. Credit card activity uses the same 3 or 4 column CSV layout as bank transactions, with charges as negatives (or in the Debit column) and payments or credits as positives. The one catch is the account type: import the file into the matching credit card account, not a checking account, or the signs will read backward.
QuickBooks Desktop again cannot read a credit card CSV directly and needs the transactions as a .qbo. Convert the card export the same way you would a checking export, then import it through Bank Feeds.
How many transactions can QuickBooks import at once?
QuickBooks Online caps a single CSV upload at 1,000 rows and 350 KB. There is no monthly total limit, so you can run several uploads back to back, but each individual file must stay under both caps. For a full year of activity, split the data into monthly files or convert the whole export to a .qbo, which QuickBooks Desktop imports in one pass without the row cap.
The reliable workaround for both editions
When a CSV will not import, or when you are on Desktop and it never will, convert the file to a .qbo Web Connect file. A .qbo is the native format both editions understand, it survives the format checks that trip up CSV uploads, and it protects you against duplicate imports. Upload your CSV or Excel bank export, map the columns once, and download a QuickBooks-ready file in seconds. For the mechanics of loading the result, see how to import a QBO file into QuickBooks.
If you are choosing between editions or planning a migration, remember the core rule: QuickBooks Online will take a well-formatted CSV, QuickBooks Desktop will not, and a .qbo works everywhere. Get the format right once and bank imports stop being a monthly headache.