NOTE: This page describes how to bulk register contacts that are cases. To bulk register contacts that are mobile workers, see this page.


For certain projects, it makes sense to register all the participants in the system ahead of time.  This can be done by uploading their information through an Excel file using the Excel Importer.  Create an Excel file with the following information/headers:

An example Excel file can be found here: sample_excel_contacts.xls

Uploading Contacts

  1. Go to the Data tab, then select Import Cases from Excel.
  2. Select the Excel file that you want to import.  Make sure that "This file has column headers" is set to True and select Next.
  3. Specify the case type for the upload.  This should be used by the Surveys in your application (ex. your case type is contact).  If you haven't setup an SMS Survey, Create an SMS Survey.   
  4. Choose the Excel column as the Case ID and Corresponding case field as the case id column in your Excel document.
  5. Make sure "Create new records if there is no matching case" is checked.
  6. Select Next step
  7. The next page lets you map the columns in your Excel document to case properties.  
    1. Case Name, choose the existing "name" case property
    2. For contact_phone_number, check off "Create a new property instead" and type in  and contact_phone_number
    3. Follow the same step for contact_phone_number_is_verified and any other case properties.
  8. Select Confirm Import.  This will create all the contacts in the Excel document.