Before you begin
- Save your list as a CSV file. Other file types aren’t accepted.
- Include a first name column and a last name column. Both are required.
- Tidy up the file first. Check that each column holds one kind of data, such as only email addresses, and remove blank and repeated rows.
Upload your contacts
- Select Contacts in the left sidebar.
- Select Upload Contacts.
- In the Import Contact Details window, select Click to upload.
- Pick your CSV file.
- Under Formatting Options, turn on Convert data to Title Case if your file is in all capitals or all lowercase.
- Turn on Update existing contacts based on email address if some people in the file are already contacts and you’d like to update them. Leave it off to add new contacts only.
- Under Column Mapping, select the column from your file that matches First Name.
- Select the column that matches Last Name.
- Match any other columns you’d like to bring in, such as Emails, Phones, Tags, or addresses.
- Select Add.
- Wait for “Uploading contacts…” to finish before you close the page.
Avoid common problems
Run one import at a time
Wait for an import to finish before you start another one for the same contact book. Starting a second import while one is still running can be refused or can create duplicate contacts.Duplicate contacts
- If you see “One or more of the contacts you are trying to upload already exist,” some email addresses in your file already belong to contacts. Those rows were skipped. To update those contacts instead, run the import again with Update existing contacts based on email address turned on.
- If you see “One or more of the contacts you are trying to upload already exist in a different Contact Book,” those email addresses belong to contacts in another organization’s contact book. Those rows can’t be imported here.
- Rows without an email address can’t be checked for duplicates by email. Uploading the same file twice can create duplicates of those people.