If you have ever wished you could create a map of your entire congregation, then we have news for you. We came across a site that is helping churches map their membership. BatchGeo allows you to map up to 250 records for free*. Keep reading for step-by-step instructions.
Export Your Address Information from IconCMO
Go to People: Households: Hse-Export
Choose the “Address Information” report
Choose a household status
Click the “Export Data” button
Format the Data
Delete or hide columns A (the household names) and C. Column C is ‘Address Line 2’ which is typically reserved for things like the apartment number. This information is not needed for the map.
Insert a row at the top and add headers for the remaining columns (address, city, state, zip)
Highlight the data in columns B through F
Copy the highlighted data to your clipboard (ctrl+c)
Make a Map
Go to http://batchgeo.com/
Paste your data into BatchGeo (ctrl+v)
Click the “Validate & Set Options” button
Review to make sure everything matches correctly
Click the “Make Map” button
You can see my sample map here:
You may notice some of the addresses in my example are not accurately mapped (e.g. a Newport, WA address showing up near Vancouver). This is because the addresses I used are completely made up and that is confusing Google Maps. When you use real addresses from your database, the map should look much better.
*Icon Systems is not affiliated with or partnered with BatchGeo. But we think it is a pretty amazing resource to know about and hope you find it helpful.
Don’t have IconCMO? Sign up for a FREE 10-day trial.