New CSV Template for Congregation Upload (1)
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJ
1
Member IDTitleFirst NameLast NameGoes byGenderAddress 1
Address 2 City
CityStateZIP
Member Status
EmailHome PhoneCell PhoneBirth
Marital Status
Family ID
Spouse First Name
Children at Home NamesLifegroup StatusFirst ContactedWho ContactedFirst VisitMission OutpostCommentsUtility 1Utility 2Utility 3Utility 4Utility 5Utility 6Utiilty 7Utility 8Utility 9Utility 10
2
4Mr.JohnDoeJohnM123 Davis StApt 204DallasTX75211ME
johndoe@email.com
800-555-1212
800-555-1313
12/25/1985M37MaryDavid, Sue12/1/2013Bill12/7/2013Had recent surgery
Possible volunteer
3
The field layout shown above is recommended, but not required. It will make it easier to match up your fields if you have them in this format.
4
The fields highlighted in yellow are the only ones required.
5
NOTES ON FIELDS
6
Member IDThis should come from your Church Management Software (CMS) if there is one.
7
TitleMr., Mrs., Miss, Ms., Dr.
8
Goes by
When sending a letter or making a call how do you want them referred to? Dear…..
9
GenderM or F
10
Address 1Street Address
11
Address 2
Typically this is an apartment number, but often the apartment number will be at the end of address 1.
12
CityCity
13
StateState abbreviation
14
Zip5 digit code for zip code
15
CampusLocation member attends
16
EmailMember email address
17
Family IDThis should come from your Church Management Software (CMS) if there is one.
18
Spouse first nameSpouse's first name
19
Children at homeNames of children at home
20
Member StatusPreferably a 1 or 2 digit code e.g. "M" or ME" for member and "V" or "VI" for Vistitors
21
Lifegroup StatusAre they active in a Sunday School Class or other small group?
22
First contactedWhen did you first contact the member?
23
Who contactedWho from the church contacted the member?
24
Mission Outpost
These are members who have been trained to reach out to their visitors and new neighbors
25
CommentsAdd any special comments
26
Utility Fields 1-10Add any additional fields you wish to track
Loading...
Main menu