User Guide

Importing and Exporting Contacts

Last Updated: Jun 22, 2015 10:08PM PDT
Telerivet makes it easy to import contact information from a spreadsheet program like Excel, as well as to export contact information back into a spreadsheet. It's also possible for developers to import and export contacts via the REST API.

Importing Contacts from a Spreadsheet

From 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.

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.

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.

Importing and Exporting Contacts via the API

To learn how to use the Telerivet API to import or export contacts, visit the REST API documentation .

Contact Us
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
Invalid characters found