Can You Import Excel and CSV Files Into QuickBooks?

Yes. QuickBooks can import Excel and CSV files for certain kinds of data, but the accepted format depends on whether you use QuickBooks Online or QuickBooks Desktop and what you are importing. Excel or CSV is commonly used for lists such as customers and products; bank activity usually needs a supported bank file or a correctly formatted CSV.

Why the file format depends on what you are importing

“Importing a spreadsheet into QuickBooks” can mean several different things: adding customer records, loading a chart of accounts, bringing in products and services, or entering past transactions. QuickBooks provides different import routes for these jobs. A file accepted by a list-import tool may not be accepted by the bank-transaction upload, even if both contain dates and amounts.

QuickBooks Online and QuickBooks Desktop also have different menus and import capabilities. Available choices can vary by product edition, region, account permissions, and software updates. Before changing your spreadsheet, open the relevant import screen and check the file types it accepts. If Excel is not offered for that particular task, save a clean copy as CSV or use another supported route.

What kinds of data can spreadsheets import?

QuickBooks Online’s Import data feature is commonly used to bring in lists such as customers, suppliers (often called vendors in some versions), products and services, and a chart of accounts. Depending on the list and the current import screen, it may accept Excel workbooks or CSV files. Importing a list creates or updates records; it does not automatically create the sales, bills, payments, or other transactions associated with those records.

Bank activity is a separate case. QuickBooks Online’s bank upload generally accepts a bank-supported file such as QBO, QFX, or OFX, or a properly structured CSV. An ordinary Excel workbook is not a substitute for those formats in the bank upload flow. QuickBooks Desktop can import certain lists from Excel, while bank downloads typically use a supported Web Connect file, such as QBO. Transaction imports beyond those routes can require a dedicated import tool or an approved third-party app.

Check the import options for the exact record type before preparing a large file. An import option for customers does not imply that invoices or journal entries can be loaded through the same screen.

Importing Excel or CSV into QuickBooks Online

For a supported list, start in QuickBooks Online and open Settings (the gear icon), then choose Import data. Select the data type, such as customers or products and services, and follow the prompts to choose an Excel workbook or CSV file. The wording and available types can change as QuickBooks updates its interface, so use the choices shown in your account rather than assuming every list has the same workflow.

Make a copy of the source workbook and remove unrelated worksheets or sample rows.
Choose the matching import category in QuickBooks and select the file.
Review the column-mapping screen. Match each spreadsheet heading to the QuickBooks field it represents; do not map a column merely because its name looks similar.
Preview the records, correct any warnings, and run the import.
Review the resulting list in QuickBooks and compare its record count and a few key details with the source.

For example, a customer sheet might have columns for company or customer name, email, phone, billing address, and payment terms. QuickBooks may require a name field while other fields are optional. Use the preview to confirm that addresses and names land in the intended fields before importing hundreds of rows.

Uploading bank transactions

In QuickBooks Online, open the bank transactions area, select the relevant account, and use its upload or file-upload option. The precise button label can differ between interface versions. Choose a supported bank file or CSV, then map the date, description, and amount columns if QuickBooks asks. Check whether the CSV represents money in and money out in one signed amount column or separate debit and credit columns; mapping those incorrectly can reverse or distort transactions.

Bank uploads usually place transactions in the bank-feed review area. They are not necessarily posted to the books simply because the file uploaded. Review the entries, match them to existing transactions where appropriate, and add only the new ones. This review helps prevent a downloaded transaction from being recorded twice if it was already entered manually.

If the bank provides a QuickBooks-compatible download, that file can preserve information a generic spreadsheet may not. If you must use CSV, follow the column layout shown by QuickBooks, and export only the required data. Do not rename an Excel workbook’s extension from .xlsx to .csv; that changes the label, not the file format.

Importing with QuickBooks Desktop

QuickBooks Desktop includes Excel import options for certain lists. A common route is File > Utilities > Import > Excel Files, though available choices can vary by Desktop edition and version. The import wizard guides you through selecting a worksheet, matching spreadsheet columns to QuickBooks fields, and reviewing records. If the menu or file option is absent, consult the help for your specific release rather than relying on steps for another edition.

For bank activity, Desktop commonly uses a bank-provided Web Connect file, often with a .QBO extension, through the bank-feed or file-import workflow. The Excel list-import wizard is not a general-purpose way to turn any worksheet of transactions into posted accounting entries. For other transaction types, verify the supported method for your version; some workflows use an add-on or a structured Intuit interchange file. Always confirm whether an import creates transactions, list records, or only a file for review.

Prepare the spreadsheet before importing

A tidy source file reduces mapping mistakes and makes it easier to find problems. Keep one record per row, put a single field in each column, and use a clear heading in the first row. Remove merged cells, blank lines within the data, totals rows, explanatory notes, and extra formatting that could be mistaken for records.

Keep dates consistent and use values QuickBooks recognizes; avoid mixing date styles in the same column.
Store phone numbers, postal codes, and account numbers as text when leading zeroes matter.
Use consistent names for customers, products, and accounts so you can recognize duplicates.
Check that amounts are numeric and that debit, credit, and tax information is in the intended columns.
Remove formulas or confirm their displayed results are current before exporting, especially if the import reads values rather than formulas.
Save a backup of the original workbook. If exporting to CSV, remember that CSV stores plain text values from a sheet, not workbook features such as multiple tabs, formulas, or formatting.

In Excel for Microsoft 365 on Windows, use File > Save As and select a CSV format when the QuickBooks import requires CSV. Excel may warn that CSV does not support multiple worksheets or some workbook features; keep the original .xlsx file and save the CSV as a separate copy. Reopen the CSV or inspect it in a text editor if you need to confirm that the exported columns and separators look right.

Mapping, duplicates, and common import problems

Column mapping is one of the most important parts of the process. A spreadsheet heading such as “Client” may correspond to a customer display name, company name, or another field depending on how the business uses QuickBooks. Check the preview carefully. A wrong mapping can put information in the wrong field even when the import completes without an error.

Common causes of failed or messy imports include unsupported file types, headings QuickBooks cannot identify, missing required fields, inconsistent dates, invalid amounts, and duplicate records. A duplicate can also arise when a file is imported twice after an unclear error message. Before retrying, check the relevant QuickBooks list or bank-feed review area to see whether some or all of the records were already added.

For a large or business-critical import, first test a small set of representative rows if the workflow allows it. Compare the imported records with the source, then proceed with the full file. Keep the original and a copy of the final import file so you can trace what was supplied if an issue appears later. For financial transactions, reconcile the resulting activity against the bank statement or source system rather than treating a successful upload as proof that the books are correct.

Alternatives when Excel or CSV is not enough

If the file is not accepted, first check whether the source system can export a QuickBooks-compatible format. For bank activity, a direct bank connection or a bank-provided QBO, QFX, or OFX download may be more suitable than rebuilding a file by hand. For other transaction types, QuickBooks may offer a product-specific import route, while a third-party importer may support a broader range of records.

Before using an app or conversion service, check its supported QuickBooks version, the record types it creates, whether it can identify existing entries, and what access to company data it requests. Review pricing and cancellation terms directly with the provider; costs and features vary. Do not share an administrator password or upload financial records to an unfamiliar service. For a one-time complex conversion, an accountant or QuickBooks specialist can help choose a process and review the results.

Frequently Asked Questions

Can I import an Excel file directly into QuickBooks Online?
For some lists, QuickBooks Online offers an Excel import option through Import data. For bank transactions and other tasks, the accepted formats differ; check the file types displayed in that workflow. A CSV export may be needed, but it is not accepted for every type of record.

Can I upload an XLSX file for bank transactions?
Usually, the bank-transaction upload expects a supported bank file or a structured CSV rather than an XLSX workbook. Export a clean CSV in the layout QuickBooks requests, or download a compatible file from the bank.

Does importing a customer spreadsheet create invoices?
No. A customer-list import adds or updates customer records. Invoices are separate transactions and need their own supported entry or import method.

Will QuickBooks automatically prevent duplicate imports?
Do not rely on that. Duplicate handling depends on the workflow and record type. Check the destination list or bank-feed review area before repeating an import, especially after a timeout or unclear completion message.

Can I undo an import?
There is not one universal undo action for every import. What can be corrected or deleted depends on the record type, accounting period, and whether entries have been matched, reconciled, or used elsewhere. Keep a source copy, review the import immediately, and ask an accountant or QuickBooks support about corrections that could affect completed books.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.