Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.


  • Case Name: The name of the registered case (or some other way to quickly identify who the person is).  
  • contact_phone_number: This is the phone number of the person.  The phone number should include the country code and contain no spaces and not have a + symbol.  Also, be sure to define this column as a Text column in Excel, otherwise the phone number may not import correctly.  For example, a US number should be 12065551234.  An Indian number would be 919560187280
  • contact_phone_number_is_verified: This should be set to 1 for every item.  It specifies that the phone number for the person is correct. 
  • commcare_email_address: This is optional, but can be specified if you prefer to email your mobile workers (instead of sending a message).  
  • case id: A blank column needs to be added here.  This is the ID of the item (but since these are new items, they have no ID).  
  • Additional DataIf there is other information you want to add about the person (ex. gender, age, etc.) you can also include that as additional columns in the Excel file. sample_excel_contacts.xls


  1. Go to the Data tab, then select Import Cases from Excel.
    Image RemovedImage Added
  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 Setup 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.