See an overview of the process.
Consider renaming the columns in your original (source) spreadsheet, and reordering your columns so they're in the same order as the columns in the formatted spreadsheet. This will make it easier for you to copy from your original file and paste your information into the formatted spreadsheet.
Always start pasting your data into row 8 of a column in the formatted spreadsheet.
If you can't find columns in the formatted spreadsheet to paste all of your data into, you can add the information later
(after you finish adding the data to QuickBooks).
If the formatted spreadsheet finds errors as you paste your data in, you will see these indicators:
Cells with errors highlight yellow and display a red triangle. (Position your mouse (pointer) over the red triangles for details to fix any errors.)
Red exclamation marks show rows that contain errors.
The Messages box shows the number of errors you need to fix to successfully add all of your information to QuickBooks.
Note: We recommend that you print this topic before you start.
Important: Make sure your existing Excel spreadsheet (that contains your source information) is open so that you can copy information from it into the specially formatted QuickBooks spreadsheet.
To do this task
Go to the File menu, select Utilities, select Import, and click Excel Files. The Add Your Excel Data to QuickBooks window opens.
Click the button that indicates the type of data you want to add (for example, Customers, Vendors, or Products I sell).
You'll be prompted to back up your data and then proceed.
A specially formatted Microsoft Excel spreadsheet opens for you to add your data into.
If you're prompted to enable macros to use the spreadsheet, click Enable Macros.
The spreadsheet shows the steps you follow to copy your data, fix errors, and add your data to QuickBooks. If you need help to finish a step, click Show Detailed Instructions.
Click in any column to see a tip about the type of data you can enter there.
Copy and paste your data into the spreadsheet one column at a time.
To fix errors, locate each yellow cell, position your mouse (pointer) over the red triangle to see the problem and use the solution to fix the problem.
After you fix the errors, in the Excel spreadsheet, go to the File menu and click Save to save your spreadsheet.
Give your spreadsheet a name you can easily remember.
Note the location where you saved the spreadsheet.
To leave the spreadsheet, in the Excel spreadsheet, go to the File menu and click Exit. In the Add to QuickBooks window, click I'll Add My Data Later.
To add your data to QuickBooks from the spreadsheet, in the Excel spreadsheet, click Add My Data Now. In the Add to QuickBooks window, click Save & Add My Data Now.
The spreadsheet closes and you'll see comments about the data you added to QuickBooks.
Note: Checkmarks show the steps you've completed. If steps 2 and 3 in the QuickBooks window are not checked, be sure to complete them:
Step 2: Browse to and select the spreadsheet you created so QuickBooks knows where to find the data you want to add.
Step 3: Review the results of data you added and fix errors.
What to expect when using a formatted spreadsheet
Add data or browse and select data to add
Review the results of data you added
What to do if you can't find your saved spreadsheet
Add data from sources other than Excel
Use the Advanced Import feature
Copy and paste your data from Excel directly into QuickBooks