Import People via CSV Upload

Use a CSV upload to populate people in your Gloo account to start texting today.

Brian Knollman avatar
Written by Brian Knollman
Updated over a week ago

If you don’t have a church management system, or you don't want to integrate with your church management system, a CSV upload is a great way to quickly populate your Gloo account with people.

You can import a CSV file by navigating to My People -> Integrations. Click the green Import button.

How to import people using a CSV file

  1. Download the template to input the information in the appropriate format for an upload.

  2. Enter each person's information into the CSV template in this format.

    • Note that Phone Number, First Name and Last Name are required- all other fields are optional.

    • Even if you don't use a particular column for any of your contacts, such as the optional Address column, don't delete the column completely or it will cause an error. Simply leave that column blank.

    • You also should never add additional columns to the template, as this will also cause an error.

    • Finally, do not change the order of the columns, as this will cause an error.

  3. Upload the document and then click Continue.

  4. Match the group names in your CSV document to the correlating groups in your Gloo account. If those groups don't exist yet in your Gloo account, you can create them here. Then click Continue.

  5. Ensure there are no errors. If there are any errors, the system will prompts you to fix each one individually. Then click Continue.

  6. Verify that the information is correct. Then click Continue.

  7. Verify you have permission to text the phone numbers you are importing and click Yes, Import People to finalize your import.

  8. If you receive an error upon submission, please do not continue trying to submit your csv. The Gloo Support Team will contact you as soon as possible to help you work through the submission error.

  9. Once confirmed, the numbers will populate under My People.

How to update information using a CSV upload

You can also update people's information using a csv upload! If you upload a csv file that has contacts that already exist in your Gloo account, rather than creating duplicate contacts the system will simply update any information that you've changed. For example, you can use a csv upload to update people's email addresses, or add mass people into groups.

Important: The only piece of information that cannot be updated via a csv upload is a person's phone number. In order to update a phone number, you must go into their profile in the My People tab and make the change there. If you try to make that change by uploading a csv, the system will create a brand new person attached to that phone number.

Did this answer your question?