Contact Database Sample Spreadsheet

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X
1	Contact Preferred Title (Ms, Miss, Mrs. Mr.,)	Contact First Name	Contact Last Name	Organization Name (if applicable)	Email Address	Phone Number	Mailing Address	Date of Birth	Contact Type						Interests/Hobbies/Important Information	Employer	Frequency of Volunteerig/Service	Donation Dates	Donation Amounts	Donation Type			Contact Notes	Follow-Up Items
2	Contact Preferred Title (Ms, Miss, Mrs. Mr.,)	Contact First Name	Contact Last Name	Organization Name (if applicable)	Email Address	Phone Number	Mailing Address	Date of Birth	Board Member	Staff	Volunteer	Donor	Event Guest	Sponsor	Interests/Hobbies/Important Information	Employer	Frequency of Volunteerig/Service	Donation Dates	Donation Amounts	Donation Type	Contact Dates	Method of Each Contact	Contact Notes	Follow-Up Items
3	Sample: Ms	Shirley	Townsend	N/A	shirley@me.com	204-555-5555	123 Town St. Providence, RI 02906	1/18/76	Place an "x" for each relevant contact type.		X	X	X		is a caretaker for elderly parents	Unknown	Yearly	1: 1/21/2019 2: 12/17/2019	1: $25 2: $50	1: Cash 2: Credit card	1: 11/20/2018 2: 3/14/2019 3: 12/27/2019	1: Event 2: Phone 3: Phone	1: Met Ms. Townsend at a program meet and greet. She was invited by a coworker who is a regular volunteer. She expressed interested in volunteering on weekends but has limited time because she is caring for elderly parents. Is eager to learn more about the program and repeatedly asked how she can help. Spoke with her about our food bank and she noted that she would begin volunteering in the new year	11/20/2018: Sent out program list. 1/28/2019: Sent thank you letter for donation 12/22/2019: Sent thank you letter for donation
4	For help with this sheet, contact Tiffany at Boss on a Budget at www.bossonabudget.com																		Tip: On Mac computers, hold down the "option" and "return" key to make a new line in a cell. For Windows, select "Alt" and "enter".				Tip: If the cells get too big, break up each contact on its own row. Once this gets to be unmanageable, you'll know it's time to invest in a donor relationship management system.
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100