QuickBooks Excel and CSV Imports: What You Can Bring In

How-to basics · Updated November 21, 2026

Yes. QuickBooks can import Excel and CSV files, but the right method depends on whether you use QuickBooks Online or QuickBooks Desktop and whether the spreadsheet contains lists, bank activity, or transactions such as invoices. Prepare the columns to match QuickBooks’ import template, check the preview and field mapping, and review the results before relying on the imported records.

What Excel and CSV imports can do

An import is a way to transfer structured spreadsheet data into QuickBooks without typing every record again. The main distinction is between lists and transactions. Lists are records reused in bookkeeping, such as customers, vendors, products and services, and accounts. Transactions record activity, such as invoices, bills, or bank deposits. QuickBooks does not offer one universal spreadsheet import that accepts every kind of data.

QuickBooks Online has import tools for several lists and, depending on the feature available in the account, some transactions. Bank activity has its own upload process. QuickBooks Desktop has an Excel import tool for supported lists, while many transaction imports require a different format or an additional tool. Available choices can vary by product edition, region, subscription, and changes to the interface.

Excel files normally use the .xls or .xlsx format. CSV means comma-separated values: it stores plain text in rows and columns, not workbook formatting, formulas, or multiple sheets. A CSV is useful for transferring simple data between programs, but it cannot preserve formatting, formulas, or extra worksheets.

Importing into QuickBooks Online

In QuickBooks Online, list imports are generally started from the gear icon and Import data. Depending on the version and screen, you may be asked to choose a data type, upload a CSV or Excel file, and map spreadsheet columns to QuickBooks fields. Common supported list types include customers, vendors, products and services, and the chart of accounts. Follow the prompts for the particular type rather than assuming every type accepts the same columns or file format.

Some accounts also offer an invoice import option under Import data. If it appears, use the downloadable template and its instructions; invoice imports need more than a customer name and total. They may require invoice dates, product or service details, quantities, rates, and other fields. A single invoice with several lines may need a separate spreadsheet row for each line, with shared invoice information repeated as the template specifies. Confirm how the template represents invoice numbers, tax, and line items before uploading a large batch.

Bank transactions are handled separately. In the bank transactions area, choose the option to upload transactions, select the account, and provide a supported file such as a properly formatted CSV. The exact menu label can vary as QuickBooks updates its interface. After upload, transactions usually appear for review and categorization; importing them does not automatically mean they have been added as categorized entries to the books. Avoid uploading a period already brought in through a bank connection unless you are prepared to identify and exclude duplicates.

Importing into QuickBooks Desktop

QuickBooks Desktop for Windows includes an Excel import route for supported list data. A common path is File > Utilities > Import > Excel Files. The import window guides you through choosing a list, selecting a worksheet, matching columns to QuickBooks fields, and reviewing the records. The exact options depend on the Desktop edition and the list type. Save a copy of the company file before a significant import so you can recover if the data is not what you intended.

The Excel import wizard is not a general-purpose way to load every Desktop transaction from a spreadsheet. Desktop users may use an IIF file for certain supported data, or a compatible third-party application for more complex transactions. IIF is a specialized text format, not simply a renamed CSV, and its requirements differ from an ordinary spreadsheet. Check the instructions for the specific transaction and Desktop edition before converting or importing data.

If your source is CSV and the Desktop tool expects an Excel workbook, open the CSV in Excel, check that the columns have been separated correctly, and save a working copy as an Excel workbook. Do not simply rename the file extension: changing .csv to .xlsx does not convert its contents into an Excel workbook.

Prepare the spreadsheet before uploading

Good preparation prevents many import failures. Download the current template from QuickBooks when one is offered, and use it as the source of truth for column names and required fields. If you are adapting an existing workbook, make a clean import sheet rather than uploading a report full of totals, notes, blank rows, or decorative headings.

  • Use one header row, with one record or transaction line per row as the template requires.
  • Keep each field in its own column. Do not combine a customer name, address, and phone number in one cell.
  • Use consistent dates and number formats. Check whether dates such as 04/05/2026 mean April 5 or May 4 in your region.
  • Use the exact customer, vendor, account, and item names already in QuickBooks when you want to connect new activity to existing records.
  • Remove totals, subtotals, merged cells, empty header lines, and formulas that produce blank-looking values.
  • Check for duplicate names, invoice numbers, and bank transactions before importing.

For example, a basic customer-list sheet might contain columns for display name, company, email, phone, billing address, and opening balance only if the import template supports those fields. A bank CSV usually needs a date, description, and amount, or separate money-in and money-out columns in the layout accepted by the upload screen. Do not assume a sheet designed for one importer can be used unchanged in another.

Map fields and test a small batch

During import, QuickBooks may ask you to match spreadsheet headings to its fields. A column called Client, for example, may need to be mapped to Customer rather than left unmapped. Review every match: a column mapped to the wrong field can create records that look valid but contain incorrect information. If a field is optional and has no corresponding spreadsheet column, leave it unmapped instead of assigning an unrelated column.

For a large file, first test a small, representative batch. Include different cases, such as a record with a company name, one with an individual name, and an address with a postal code. Review the imported records in QuickBooks and compare them with the source before importing the rest. For transaction files, verify dates, amounts, tax treatment, and account selection. A successful upload message only confirms that the importer accepted data; it does not prove the accounting is correct.

Common problems and how to fix them

Errors often arise from formatting or from references to records that QuickBooks cannot match. A customer name in an invoice file may need to match an existing customer exactly, and a product or service may need to exist before its invoice line can be imported. If the importer reports an unmatched field or record, correct the source or create the needed list entry first, then try again.

  • Columns appear in one field: Check the CSV delimiter and encoding. Reopen the source in Excel and confirm that each value is in its intended column before saving a corrected copy.
  • Dates or amounts look wrong: Check regional date order, decimal separators, currency symbols, and whether negative amounts are represented in the accepted format.
  • Rows are rejected: Look for missing required values, invalid account names, unsupported characters, or blank rows included in the selected range.
  • Duplicate entries appear: Stop before importing the file again. Compare the affected records and use QuickBooks’ duplicate or matching tools where available; repeated uploads can create further duplicates.
  • Bank entries do not match downloaded activity: Check the selected account, date range, sign conventions, and whether the same transactions were already brought in by a bank connection.

Do not delete or alter accounting records just to make an import pass without understanding the effect. If a failed import partially created records, inspect what was added before retrying the whole file. For a large or financially important correction, consult a qualified bookkeeper or accountant familiar with your QuickBooks edition.

Excel versus CSV: which should you use?

Use Excel when the QuickBooks importer accepts a workbook and you need to prepare or inspect data across worksheets. Excel can retain multiple sheets and workbook features while you work, although the importer may use only one selected sheet. Use CSV when the specific QuickBooks upload asks for it, especially for bank activity, or when a simple portable text file is preferable.

Neither format makes data automatically compatible. A workbook can contain formulas, date values, hidden rows, and extra columns that affect what you see or what an importer reads. CSV avoids some workbook complexity but carries only plain text values and may be interpreted differently if its delimiter, character encoding, or regional number format is unsuitable. Always use the format requested by the QuickBooks import screen and inspect the preview.

Safety, backups, and alternatives

Before importing, protect both the source file and the accounting data. Keep an untouched copy of the spreadsheet, restrict access if it contains customer or bank details, and use a secure location rather than emailing sensitive files unnecessarily. In QuickBooks Desktop, make a company-file backup before a substantial import. In QuickBooks Online, review the company’s available backup and restore options and keep a dated copy of the source data; do not assume an upload can be undone with one click.

If the built-in importer does not support the data you have, alternatives include entering a smaller number of records manually, using a supported bank connection, or choosing a reputable integration application that explicitly supports your QuickBooks product and transaction type. Check permissions, pricing, supported fields, and how the integration handles duplicates before granting access or sending it financial data.

Frequently Asked Questions

Can QuickBooks import a CSV file?
Yes. QuickBooks Online accepts CSV files for certain imports, including supported list or bank-data workflows. The accepted data types and columns depend on the importer. QuickBooks Desktop has an Excel import tool for supported lists; a CSV may need to be opened and saved as an Excel workbook or processed through another supported method.

Can I import an Excel spreadsheet into QuickBooks Online?
Yes, for supported data types. Go to the gear icon and choose Import data, select the relevant type if available, and follow its template and mapping steps. Not every spreadsheet or transaction type can be imported directly, so check the options in your account first.

Can I import invoices from Excel or CSV?
Some QuickBooks Online accounts provide an invoice import option, typically using a specified template and CSV or spreadsheet workflow. Availability and required columns can vary. In QuickBooks Desktop, the standard Excel list importer should not be treated as an invoice importer; check the Desktop edition’s supported methods or a compatible integration.

Will importing a file overwrite existing QuickBooks records?
Do not assume it will. Import behavior depends on the data type and the matching rules in that workflow. An import may add records, reject matches, or create duplicates rather than update existing entries. Test a small batch and review the preview and results before proceeding.

Can I import an entire Excel workbook with multiple sheets?
A workbook can contain multiple sheets, but an import typically asks you to select a sheet or range and does not combine every worksheet automatically. Prepare each data type separately unless the QuickBooks template explicitly describes a multi-sheet process.

Why does my CSV import show the wrong dates or amounts?
Regional settings, date order, decimal marks, currency symbols, and negative-number conventions can change how values are interpreted. Check the CSV in a spreadsheet program, compare it with the import preview, and use the format requested by that QuickBooks workflow before uploading again.

Related

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.