Import contacts¶
To add many contacts to a list at once, open the list under Contact lists and click Add contacts. There are four ways:
| Option | When to use it |
|---|---|
| Single contact using form | One contact at a time |
| Multiple contacts using CSV | A file exported from another system (up to 100,000 contacts): see Import with CSV |
| Multiple contacts using Microsoft Excel | Your list is in an Excel sheet, on Windows: see Import with Excel |
| Multiple contacts using Google Sheets | Your list is in a Google Sheet: open the template sheet and follow the instructions on its Configuration sheet |
Before you import¶
- Create the custom fields first. To import columns other than email and phone (name, company, region…), the list needs a field for each. Create them under Edit on the list, section Custom fields → New custom field. Columns without a matching field can't be imported.
- Phone numbers with digits only, optionally starting with
+or00:912345678,351912345678,+351912345678and00351912345678all work. Non-Portuguese numbers need the country code. - Email or phone: every contact needs at least one of the two.
- Consent: if you mark contacts as subscribed (Subscribed), have their consent recorded elsewhere.
After importing¶
Check the result on the list's page: the Subscribed and not bouncing, Unsubscribed and Bouncing totals open the contacts in each group.
Common problems¶
There's no field to map a column to. Create the custom field on the list and start the import again.
Rejected rows or SMS that don't arrive. Phone numbers with dots or brackets (+351.912345678, (351)912345678) are rejected on import. Phone numbers with spaces or hyphens (912 345 678, 351-912-345-678) are imported, but SMS to them may not arrive. Keep only the digits and, if you like, the leading +.
Duplicate contacts. DUO compares email and phone exactly as they are in the file. 351912345678 and 912345678 are different numbers to DUO; always use the same format.
To import through the API, see Upload CSV.