Learn how to import your customer or supplier contact lists from from Outlook, Excel, Gmail, or Google Sheets.
Do you have a customer or supplier list that you’d like to bring into QuickBooks Online? We’ll show you how to export your list as a spreadsheet from Outlook, Gmail, Excel or Google Sheets. Then we’ll show you how to import them directly into QuickBooks.
Things to know before you import contacts from Outlook, Excel, or Gmail
- The file size limit is 2MB or 1000 rows. If you need to import a list larger than that, you’ll need to split it up into multiple imports.
- Subaccounts can't be imported. We recommend changing the subaccounts into parent accounts before you import. Then you can change them back after the import.
- If the file imported incorrectly and it needs to be re-imported, your customer or supplier list won't be overwritten, which can create duplicate entries. You'll need to delete the imported customers or suppliers before re-importing, or edit each one individually.
- The entries in the Name field must be unique. A supplier, customer, or employee can't have the same name as another.
- The import only supports one email address. Don't worry, you can add others in QuickBooks later.
- When importing contacts from a spreadsheet (including files exported from Google Sheets, Excel, and as a CSV) make sure that:
- column headers are in the first row.
- contacts are on Sheet1 of the spreadsheet.
- the spreadsheet doesn't have any formulas, charts, or blank rows.
- the spreadsheet doesn't have any errors, such as #REF!, #NAME?, #N/A or #VALUE!.
- names don't contain colons (:) or quotation marks (").
Export your contacts from Outlook or Gmail
If you have a contact list in Outlook or Gmail, you can export a CSV file of your contacts and import it to QuickBooks.
- Select File, then Open and Export and Import/Export.
- In the Import and Export wizard, select Export to a file and choose Comma Separated Values for the type.
- Select the folder you keep your customer contact information in and follow the on-screen instructions to save the export file. Make note of the location where the file is saved.
There are two options for exporting contacts from Gmail.
|Note: When you connect to Gmail, all your contacts are not automatically added as either suppliers or customers. You must select which contact to add as a supplier or customer.|
Option 1: Link Gmail contacts
- Select + New.Select the Create ⨁ icon.
- Under Customers, choose Invoice.
- Select the Customer ▼ drop-down menu, then Add New.
- Select Connect your Gmail account.
- Select Allow.
|Note: Disconnecting Gmail only removes your access to your Gmail contacts in QuickBooks Online (and thus the chance to add them as supplier or customer), but it does not remove contacts already added as customers or suppliers in QuickBooks Online.|
Option 2: Export Gmail contacts to a file
How to create an export file:
- Sign in to Gmail.
- Select Gmail at the top-left corner of your Gmail page, then choose Contacts.
- Select Export.
- Choose whether to export all contacts or only one group.
- Select the Outlook CSV format, then Export.
- Select Save to Disk, then OK.
- Select a location to save your file then OK.
Create an Excel or Google Sheets file for import
To import a spreadsheet into QuickBooks, you’ll need to format it correctly. Learn more about contact field descriptions and restrictions. Then follow these steps to create your spreadsheet.
- Create a new spreadsheet in Excel or Google Sheets.
- Make sure you’re using Sheet 1 of the spreadsheet
- Make sure that row 1 of your spreadsheet is filled in like the sample table below (under the capital letters). For example, label column A, row 1 as Full Name. Label column B, row 1 as Company Name, etc. Also make sure there are no blank cells or other headers at the top of the spreadsheet.
- Fill in your spreadsheet with your contacts' information. It’s ok to leave any information that you don’t have blank. Note: the import maps the contact’s address to the billing address field in QuickBooks Online.
- If you’re using Excel, save the spreadsheet as an XLS or an XLSX file and note where you save it. Or, if you’re using Google Sheets, the spreadsheet saves automatically.
|Country||Opening Balance||Date||Resale Number|
Verify the exported file
Before you import your contacts, it’s important to review the information and make sure everything looks right. If the import has mistakes, it can be a lengthy process to manually correct or remove your imported contacts.
- Open the CSV, XLSX, or Google Sheet file you saved and check it for accuracy.
- Double check that your spreadsheet column titles in row 1 match the sample spreadsheet above.
- Check the contacts, fill in any missing information, and correct any mistakes.
- Make sure the file doesn’t exceed the 2MB or 1000 row limit. If it does, split it into multiple import files.
Import your contacts
Now that your spreadsheet is accurate, you’re ready to import your contacts to QuickBooks Online.
- Sign in to QuickBooks.
- Select Settings ⚙. Then select Import Data.
- Select Customers or Suppliers, depending on which you are importing.
- Select Browse to upload the file from your computer. Choose the file, and select Open.
- Or, to upload from Google Sheets, select Connect to sign into your Google account. Choose the file, and then Select.
- Select Next.
- In the Your Field column, select each small arrow ▼ icon. Then, match your field to the corresponding QuickBooks Online field.
- Select No Match if you have a field that doesn’t have a matching column in your spreadsheet.
- Confirm your contacts. Uncheck any that you don’t want to save.
- If everything looks good, select Import.