ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
What is this?
2
These spreadsheets provide templates you can use to store data about your donors and prospective donors before you invest in getting a donor management CRM database.
3
4
These spreadsheets are READ ONLY, so please copy/paste the contents into your own worksheet.
5
6
7
Who should use this?
8
This spreadsheet is designed for brand new nonprofits who are just starting out.
9
10
About Little Green Light
11
When you have outgrown spreadsheets, and you're ready to move into a donor management solution,
12
we hope you'll select Little Green Light. And if you do, you'll be able to import all the data from these
13
Little Green Light is a powerful, affordable, and easy-to-use donor management CRM database for smaller nonprofits.
14
You can learn more, sign up for a demo, sign up for an account (free for 30 days), and contact LGL, all from:
15
www.littlegreenlight.com
16
17
Table of contents
18
Contact Info template
Template for tracking your contacts and their contact information
19
Gift tracking template
Template for tracking gifts you've received
20
VLOOKUP function
Example of how to use the VLOOKUP function to combine data from two tables
21
Pivot tables
Example of how to use pivot tables to roll up sums of numbers
22
Importing into LGL
Tips on how to import from these templates into Little Green Light
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