Android - Prepare CSV File for Importing Contacts and Groups

To successfully import your data into Reach, you need to adhere to the required data format in CSV files. There are two methods to create the required CSV file: using the Reach application or creating the CSV file from scratch on the computer.

Method 1: Exporting CSV from Reach Application

The simplest way to get a CSV file for importing groups and contacts is to use the Reach application.

  • Create a Group in Reach or go to the existing one.
  • Export the Group with Contacts to CSV and save the file to your device. Read Export Group with Contacts To CSV File to find instructions on how to do it.
  • Transfer the exported CSV file to the PC or Mac.

This method allows you to get the required CSV file with certain columns for further editing.

Method 2: Creating a CSV File from Scratch

You can also create a CSV file from scratch on your computer. The CSV file must be in .csv format. The file can contain the following columns: first, last, nickname, relationship, address, via, translation, and template name.

These columns correspond to the fields available on the contact editing page in the Reach application and are described in detail in Edit Contact.

  • First: First name of the contact (only one).
  • Last: Last name of the contact (only one).
  • Phone (*mandatory if Email is empty): Phone number of the contact (this field is required if Email column is empty).
  • Email (*mandatory if Phone is empty): Email address of the contact (this field is required if Phone column is empty).
  • Via: The method of contact (text, imessage, email, gvoice, whatsapp, whatsapp-business).
  • Line: The line used for sending messages (0 - default line, 1 - line 1, 2 - line 2).
  • Template Name: If any of the exported contacts have a template field, this parameter will also appear as the column in the CSV file with the specified template name. You can manually add a column of a template to your CSV file. Ensure the template column name does not duplicate any other column names listed above.

Please, note that the CSV file must contain the Phone or Email column for the successful import.

It can be created this way:

example_of_table_short

In this case, after importing, you will have three contacts with the specified phone numbers and email address.

It also can be created with all described columns above. Here is an example of how your CSV file can look:

example_of_table_big

In our case, the template column is the "Location". Only the mandatory Phone or Email columns needs to be filled. All other columns can be left empty.

After creating or editing the CSV file, save it in the CSV format (.csv). You can then import this file into the Reach application to update or create groups.