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