Excel imports in QuickBooks Desktop: the paths that work
QuickBooks Desktop users can move customers, vendors, items, and account lists through Excel; we map each import route and the export button.
One of the most durable questions in the QuickBooks Desktop community is also one of the plainest. How do you move list data in and out of the software using Excel? A French-language thread on the subject drew an accepted answer credited to Intuit’s help team, and we read it end to end. The guidance holds up. Three import routes exist, each tuned to a different list, and the export side turns out to be a single button on almost every list window.
The question behind the thread
Users arrive trying to bring customers, vendors, items, or a full chart of accounts in from a spreadsheet. Others want the reverse: a clean Excel copy of a list they already maintain inside the software. The confusion is not whether the software can do this. It can. The confusion is that each list has its own route, and the wrong route produces dead ends rather than errors.
Standard import covers customers, vendors, and items
The standard route starts under the File menu. Choose Utilities, then Import, then Excel Files. A prompt may appear offering Add/Edit Multiple List Entries; the guidance says to decline it, because that tool serves a different job. Follow the wizard and select the type of data you are bringing in. The software then opens a pre-formatted Excel workbook for you to fill in.
Enter your records in that workbook, save it, and close it. You then get the option to add your data immediately, followed by a results screen worth reading before you dismiss it. If more rows need to come across later, the same window accepts a second pass. An import does not have to be perfect the first time.
How do you import items with no spreadsheet at all?
The item case trips people up because many start with no Excel or CSV file in hand. The fix is built into the same wizard. Choose items as your data type and let the software generate the formatted workbook for you. Its columns are the columns the import expects, which removes the guesswork of building a sheet from scratch. Fill it in, save, close, and add the data as with any other list.
Two notes for this route. Item type is required, so every row needs a valid one before the import will take it. And if you already keep items in a sheet of your own design, plan on reworking the headers. The import reads specific columns, and a header it does not recognize will not carry your data across.
Chart of accounts imports run through mapping
The account list takes a different path, and the guidance front-loads a caution: make a backup of your company file first. Imports into the chart of accounts are hard to unwind, and a backup turns a bad import into a restore rather than a cleanup. From there, open the Lists menu and choose Chart of Accounts. The Account dropdown at the bottom of that window holds the Import from Excel option.
Browse to your file, open it, and pick the worksheet that holds the data. Then comes the step that decides everything: mapping. Field names inside the software rarely match the headers in a homegrown spreadsheet, so you pair each one, telling the import which column feeds which field. Save that pairing under a name and the next import can reuse it. Confirm on the first run and the accounts come across.
Does the export side need the wizard?
No. Export runs from the list windows themselves. Open a customer, vendor, item, or account list and an Excel button sits in its toolbar. The button offers a new worksheet in an open workbook, an update to an existing worksheet, or a plain CSV file. Exports also solve the template problem in reverse. If a homegrown sheet will not map cleanly, export the list first and use that file as the pattern for your import sheet.
A few habits close the gaps
Back up before any import that touches the account list. Read the results screen instead of closing it on reflex. Use the generated workbook when you have no file, and export a list when you need a pattern. One more thing: the window you decline during the wizard, Add/Edit Multiple List Entries, is the tool for bulk edits to records already inside the software. Declining it during an import is right. Forgetting it exists is why many of these threads start.