How to: Create a Contact Group using Microsoft Excel Files

How to: Create a Contact Group using Microsoft Excel Files

You can create a new group by importing clients/contacts through a Microsoft Excel file. Please follow the steps below to import clients using Microsoft Excel files.
Note: Our Supported Formats are: .xls, .xlsx and .csv only. Additionally, any hidden columns or rows will be imported, this includes when you use Excel to filter results. All results regardless of filter will be uploaded in the file.
  1. Open your Excel file. Make sure that your data is organized in columns.



  2. Verify there are column headers in the file. Headers in the file must be in row 1.
    If you do not have headers, please right-click on the 1 in the rows section and choose Insert to add a new row at the top of the file.



    Type the headers for the information that you will be importing to Teletask.



  3. In Excel, click File and choose Save As .

  4. We recommend saving to your Desktop so you can find it easily.



  5. Enter a File name for this document that you will recognize later.



  6. Under Save as type: choose either Excel Workbook (*.xlsx),  Excel 97-2003 Workbook (*.xls), or CSV (Comma delimited) (*.csv). Then select Save.



  7. Log-in to: https://hms.teletask.com/, your email address is your username.

  8. Click on Contacts   in the top menu bar.

  9. Press Create  a new Group  button in the top right-hand corner.

  10. Enter a Group Name for the new Contact group.



  11. Under Where do you want to import contacts from? select the radio button for Upload new file (csv, xls, xlsx).



  12. Press the Next button to finalize your selection.

  13. Click on Choose File, locate the file you saved previously, on your Desktop and select Open.



  14. Select the Upload type and decide if you want to Replace Group contacts or Add to Group contacts of an existing group. 



  15. If you have dates and times in your file, find the format that matches the Date format and Time format from the drop down list.
    In our example we are using the date format MM/DD/YYYY and the time format HH:MM AM/PM





  16. Press the Upload  button to finalize the selection.

  17. On the Map Fields we will locate which columns of the Excel file contains what information. You must included at-least one of the Required Fields.

     

  18. Select the drop-down list and choose the header which matches the associated field.
    In our example the required fields would look like this:



  19. Select any Optional fields that need to be captured from the Excel file.
    In our example we are capturing the full name, and appointment date and time.



  20. Press Continue  to finalize the selections.

  21. You will receive a notification that the Records are imported successfully after validation.


    Note: Depending on the number of clients it may take a few minutes for all of the clients to upload.
As you can see when you click to view the contact details the, the file imported the information specified. The Language since not selected defaults to English and a default Patient ID and Family Code was created.




    • Related Articles

    • How to: Create a Contact Group using a .txt File

      You can create a new group or add to an existing group of clients/contacts with a few changes to a .txt file. Please follow the steps below to import clients using .txt files. Note: Our Supported Formats are: .xls, .xlsx and .csv only this tutorial ...
    • How-To: Create an Opt-In Keyword Contact Group

      Using the Opt-in Keyword feature for a contact group allows new contacts to be added to the contact group when they send a text message to your organization containing a unique keyword attributed to a contact group. For more information about contact ...
    • How to: Edit or Delete an Existing Contact Group

      The clients or contacts that you have may change over time and you may need to update or delete your current Contact Groups. Here we have directions on how to: Import a New List of clients Download the Current List of clients in a Contact Group ...
    • How to: Create a Contact Group through the Transfer Client

      Creating a Contact Group through the Transfer Client is used when you want to continually update a Contact Group of contacts/clients using our Transfer Client or SFTP (Secure File Transfer Protocol). Supported file formats include: .csv, .xls, .xlsx, ...
    • How to: Create a Smart Group

      Smart Groups are used to create custom groups based on specific rules. These groups offer an additional way to filter your existing clients/contacts. Please follow the steps below to create a Smart Group. Note: In this example we will be making a ...

      Support Ticket

      Submit a support request to our Support Team