Little Square

There's more on
this topic at:

Importing customers, vendors, and employees

You've probably got contact information for the people you work with—customers, vendors, employees—in places like Gmail or LinkedIn. You can import those contacts into QuickBooks.

Note: If you use Contacts, you can sync your contacts with QuickBooks so that updates are available in both QuickBooks, Contacts, and other devices you sync with Contacts.

Before you start

You'll need a spreadsheet of the contacts you want to import into Quickbooks. If you have one, great! Go to the next section. I don't have a spreadsheet.

To import your contacts:

  1. Go to File > Import > Contacts. Or go to the Customer Center, Vendor Center, or Employee list, click plus menu, and then click the Import option.
  2. Open your spreadsheet (see the "Before you start" section above if you don't have a spreadsheet.)
  3. Copy the First Name column in your spreadsheet.
  4. Click into the first field in the QuickBooks First Name column. The field turns white.
  5. Paste in the column you copied in Step 4.

    Tip: Copy and paste by column, not by row.

  6. Repeat steps 4-6 for every column in your spreadsheet.

    Tip: Be sure to scroll over to the right to see and copy in all the available fields.

  7. Be sure that the Import box is checked for all the contacts you want to import.
  8. Change or add any info you didn't have in your original spreadsheet.
  9. In the Role column, be sure that each contact is labeled as a Customer, Vendor, or Employee correctly.
  10. Click Import.
  11. Click OK when the status window says Import Complete.

Fun fact: You can use the Add Contacts window to add basic customer info without copying it from someplace else. Just type your customers' info into the fields rather than copying it.

Troubleshooting: