Importing Contacts from a SpreadsheetFrom the Contacts page, click More > Import contacts.
Then, select and copy up to 100,000 rows from your spreadsheet (not including header rows), then paste them into Telerivet in your web browser. Alternatively, click "Upload file..." to upload an Excel or CSV file directly.
If you copied any custom contact fields, click "(Unknown)" in the header cell and identify each field. If any field names are incorrect, click the field name in the header cell to change it.
You also can import contacts into different groups by pasting a column containing a list of group names separated by commas (e.g. "subscribers, participants") then identify that as the "Groups" column.
If you have more than 100,000 contacts to import, you can import them in batches by repeating the process for each 100,000 contacts.
By default, the Phone Number is used as the lookup key, which means that if a contact already exists with the matching phone number, Telerivet will update (overwrite) the existing contact information with the imported fields, instead of creating a new contact. Any blank or missing fields in the imported rows will not be changed on the matching contact.
To change which field is used as the lookup key, click the current lookup key at the bottom of the spreadsheet. Your custom fields can also be used as the lookup key, for example if you have a Customer ID field. It is also possible to disable the lookup key, so that new contacts are always created, without updating existing contacts.
Exporting Contacts to a Spreadsheet
To export contacts to a CSV file, click More > Export contacts from the Contacts page, then select the columns you would like to export.Note that Telerivet formats phone numbers in the CSV file starting with a caret (e.g. ^16505550123) so that Excel displays them as text instead of a number in scientific notation. If you re-import contacts into Telerivet, the caret will automatically be removed.