Downloading Membership Data CSV


Due to unfortunate abuse, the Church has generally disabled the ability to download membership data in CSV (Excel) format. Church technical support will tell you that this feature is completely disabled. That’s not quite true. Stake clerks (and ONLY stake clerks) have this ability. Here is how to download Membership data in CSV, after you have received authorization from your Stake President.

1. Log in to LDS.org

Hopefully you know how to do this step.

2. Go to the Directory

Click Directory, then choose the ward you wish to export, then click the “Export Households” link.

Only Stake Clerks will see the “Export Households” function.

3. You Must Download Each Ward Separately

The church makes it really hard to export data, and you must export each ward individually. Clicking on “Stake Information” will give you no membership data. If you have 10 units, you will need to do 10 downloads.

4. Yes, I will Use it Only as Directed

I care about privacy a lot (I’m a privacy attorney). I will use the data only as directed, and destroy it after about a month. Someday I’d really like to build a Crisis Caller API so that zero membership data ever leaves church servers, and you view the map through lds.org/maps. But I can’t do that today.

Be sure to get authorization from your Stake President before doing this. Call me at (202) 669-2969 with questions/ concerns.

5. Save the Files. Do not Open.

You will be prompted to either save or open the file. Click “Save” or “Save as…,” depending on your browser. Be sure to save the files in a place you know; do not open them. Warning: The files might automatically download to a default folder, such as your “downloads” folder.

6. Email to aaron [at] crisiscleanup.org

Attach the files to an email, and put the name of the stake in the subject line.

  1. No comments yet.
(will not be published)