How do I import our list of adorers?

How do I import our list of adorers?

One of the most challenging tasks you'll need to convert an existing chapel to We Adore Him is to gather all of your adorer information into a single spreadsheet and ensure that the data is accurate. After that, the rest is easy!

We made this process as painless as possible. Here are the steps to import your list of adorers.

Note: You can also create adorer accounts individually.

Step 1: Prepare the Adorer Data

Please download the We Adore Him CSV template and open it with your favorite spreadsheet software such as Microsoft Excel, Numbers, or Google Sheets. (CSV stands for "comma-separated values" and is one of several file formats that spreadsheet programs use.)

Then, copy and paste (or type) your adorer information into the template, following its format, like this:


Be sure to leave the headers in the first row, starting with your first adorer in the second row, just like the screenshot above.

Please note:

  • The Name and Gender fields are required. (Though, you can make the Gender field optional).
  • The Password field is optional. If left empty, the adorer will be emailed a link to set their password themselves. If you don't have the adorer's email address, you should create a simple password. That way, you can communicate the password personally, such as over the phone. Passwords are case-sensitive. Learn how adorers can log in if they don't know their password.
  • The Name, Email Address, and Phone Number fields are unique and cannot be shared among multiple adorers.
    • Suppose you have two adorers who share an email address or phone number. In that case, you can either (1) create one adorer such as "Jane and John Doe" and assign that one adorer to multiple time slots, or (2) create two separate adorers giving one of them the email address and the other one the phone number.
  • In the Gender field, enter "male" or "female" (all lowercase). Or, if it's optional, leave it blank.
  • In the Language field, enter "English" or "Spanish."
  • In the Notification Preference field, enter "email", "text" or "call" (all lowercase).
  • In the Substitute fields, enter "Y" for adorers who want to be notified of substitute requests or leave these fields empty.
  • In the Administrator field, enter "Y" for adorers with administrative privileges (e.g., adoration coordinators, parish staff, etc.), or leave it empty.
  • In the Captain field, enter "Y" for adorers with elevated privileges (e.g., team captains), or leave it empty. If the adorer is also an administrator, leave this field empty. Learn what captains can do.
  • To optionally include postal addresses, populate the Country field with the two-character country code (e.g., "US").
    • If you include the country code for an adorer, the system will require all other address fields, so be sure to leave the country code blank if you don't have their mailing address.

When finished, be sure to save the file as a CSV (comma-separated value) file with the .csv file extension.

Step 2: Review the Welcome Email

The welcome email is sent to an adorer after their account is created on We Adore HimLearn how to review and customize the welcome email.

Don't want adorers to receive this email quite yet? If you would rather first populate the schedule with their existing commitments (which is a good idea), then we recommend not sending the welcome email to your adorers until after you've populated your schedule (see Steps 4 and 5 below).

Step 3: Import the Adorers

Whew! You just finished most of the hard work.

Now, please visit Admin » Adorers and click the down arrow next to the "+ New Adorer" button, and then click "Import multiple adorers."

You'll see a place to upload your template file. Choose the file from your computer.

Next, you'll see a checkbox next to "Send welcome email." We recommend leaving this unchecked, so they are not notified until after Step 4 (more on this below).

Finally, click the "Import" button to complete the import process.

Please note: If there are any problems with your import file, the adorers won't be imported, and you'll see some helpful error information. Simply correct the errors and re-run the import. If it's successful, you'll see a confirmation saying so, and every adorer will now appear in the system!

Step 4: Populate the Schedule (optional)

Now, add adoration commitments to the Schedule for your newly-imported adorers.

Step 5: Send the Welcome Email (optional)

If you didn't already send the welcome email in Step 3, it's time to do it now. Learn how to send the welcome email to multiple adorers.

Final Thoughts

We are so proud of you. You just muscled through the most difficult part of managing your adoration chapel. Now it's time for smooth sailing with the help of We Adore Him!

Also, it's easy if you ever want to add a new adorer apart from the import process. Visit Admin » Adorers and click on the "New Adorer" button (learn more).

Still stuck? How can we help?