• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Icon Systems

Simple to use. Power to grow.

  • (800) 596-4266
  • Free Trial
  • Blog
  • Features
  • Bookkeeping
  • Order
  • Pricing
  • Resources
  • Login

May 9, 2013 by Robert Leave a Comment

This post was last updated on July 22nd, 2024 at 11:59 am.

If you have ever wished you could create a map of your entire church membership, 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.

Click on the Reports button at the bottom.

Click on the “Exports” Tab.

Choose the “Address Information” export under the ‘Household Export List’ section.

Choose the appropriate criteria.

Click the “Show Report” 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 the Church Membership 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’re done!

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 30-day trial.

Photo Credit: Lightstock.com

Filed Under: People Tagged With: church directory, church leadership, church membership, church reports, church technology

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Top Rated
Church Accounting Software

Search blog posts…

Popular Posts

  • Debits and Credits – Does Debit Mean Minus and Credit Mean Plus?
  • Church Software Mobile Apps - IconCMO Set Up
  • Church Finance - Renting Space And Its Cost
  • Fund Transfers and Account Transfers, part 1 of 2
  • Fund Transfers and Account Transfers, part 2 of 2
  • Icon Systems Announces New Hires and Expansion
  • Bolster Your Outreach With QR Codes
Blog Home

Subscribe to Our Blog!

Sign Up Now
We respect your privacy and you can unsubscribe at any time.
  • The Facebook icon button link
  • The Instagram icon button link
  • The X icon button link
  • The LinkedIn icon button link
  • The YouTube icon button link
  • The Wordpress icon button link
Icon Systems, Inc.
3330 Fiechtner Drive S Suite 204
Fargo, ND 58103
Hours: Mon-Thu 8-5, Fri 8-4 CT
About Us — Privacy — Support — Careers — Sitemap
Recent Blog Posts
  • Is an All-In-One Church Software the Best Option?
  • Church Donation Software - Do you Need It?
  • Text Messaging for Church Software!
  • Is Church Software Online A Better Solution?
  • The Best Church Software Is Compliant & User Friendly!
Sales
800-596-4266
sales@iconcmo.com
Tech Support
218-236-1899
support@iconcmo.com
Fax: 218-236-0235
© 1992 – 2025 Icon Systems, Inc.