Don't be left in the dark.

Little Green Light is a cloud-based donor management system for fundraisers.
Subscribe to get our latest product updates, best practices and tips to grow your nonprofit.

Is it ok to use spreadsheets to track donors?

Posted June 9, 2022 by Hunter Williams

using spreadsheets to track donors

As a new nonprofit organization you may be wondering, “Is it ok to use spreadsheets to track donors?”

If you’re working on capacity building for a brand-new nonprofit, you will likely be tempted to track your list of potential donors in an Excel spreadsheet or Google Sheet. But is it a mistake to do this? This exact question came up recently in one of our Little Green Light Prospective Customer Q&A sessions.

It might surprise you to learn that my answer was, “No, it’s not necessarily a mistake.”

This may sound odd coming from someone who works in Sales for Little Green Light (which is a terrific low-cost donor management system for nonprofits). But the reality is that if your organization is just starting out, you might not have the resources (human or financial) for a full-fledged donor management system. Especially while your potential donor list is still small—under 200 people, let’s say—a spreadsheet can be a great place to start.

And, in fact, over 40 percent of Little Green Light customers were using spreadsheets to manage their donors prior to LGL. So, we know it is a common solution for many nonprofits.

It is, however, important to ensure that your spreadsheet data is well organized. This will also be extremely helpful if and when you do move to a donor management CRM database, because it will make importing your data much easier.

Our top recommendations if you’re using a spreadsheet to manage a small but growing donor list

  • Use a cloud-based spreadsheet program, like Excel as part of Microsoft 365 or Google Sheets, so that you can access the data from anywhere and allow others to help you manage the data.
  • Use one spreadsheet to maintain contact information (email addresses, phone numbers, physical addresses) for all of your contacts, and be meticulous about keeping this sheet up to date. It’s fine to have other spreadsheets as well, such as to track event invitees/attendees or annual appeal asks and gifts, but you don’t want to maintain contact information in multiple sheets.
  • Identify each contact as being either an individual or an organization. This is a critical piece of information to know when you are writing acknowledgments with tax receipt information (whether you have already received your nonprofit status or are awaiting approval). You want to address your letters appropriately, which means you need to know if the gift came from an individual or an organization.

Pro tip: In LGL we use a field called Employer/Organization, and it is the same field that can be used for the employer name in Individual constituent records and the organization name in Organization constituent records.

  • In addition to first name, last name, and employer/organization name, try to get an email address for every contact. Email addresses are a great way to identify your contacts in every spreadsheet you maintain because they are generally unique to each person, which allows them to work well as a “unique identifier.”

Pro tip: If the email address is in each of your spreadsheets, then you can use the incredibly useful vlookup function that’s part of Excel and Google Sheets to pull information from one spreadsheet into another spreadsheet. See a Google search on how vlookup works.

  • When recording gifts, use a separate row for each gift. Do not use columns to add additional gifts to the same record. It will be tempting to use columns, but over time that becomes much harder to manage, and also much harder to import to your donor management system if you decide to migrate to one. As long as each row identifies the donor effectively, such as via their name and email address, you’ll be able to create reports that sum up giving by constituent.

Important note: Be sure you use separate columns for the gift date and gift amount, and make certain only a full date (e.g., 1/20/2022) is used for the gift date and just the number (e.g., 250) is used for the amount. Avoid the temptation of adding text notes to either piece of data, and avoid combining those two pieces of data into one column.

Pro tip: Pivot tables are an essential feature in both Excel and Google Sheets, and they allow you to sum gift data by donor.

Free download: Spreadsheet template to track donors

This worksheet provides several spreadsheet templates that you can use to track donors and gifts. There is also a sheet included that explains the steps for importing these spreadsheets into Little Green Light, which is the donor management system we recommend you move to when you outgrow spreadsheets.

Free downloads of this spreadsheet template are available as a Google Sheet or Excel file.

 

When should you move to a donor management system?

Spreadsheets are an effective place to start, but since they will not serve you forever I’d like to share some indications for when it is time to move to a true donor management system.

  • When you have donor data in numerous spreadsheets, you will start to feel like you have information all over the place and wish you could track it all in one place. That’s an excellent reason for moving into a donor management system, which is a relational database that can tie all that data together.
  • If you’re tracking more complex types of gifts, including pledges, tribute gifts, and soft credits, you will need a database so that a single gift can be tied to more than one donor or tied to another gift (like a payment against a pledge).
  • If your donors have summer addresses and you need to send mailings to the appropriate address, but you don’t want to spend a lot of time sifting through your address fields.

More about using a donor management system vis-a-vis  spreadsheets

3 thoughts on “Is it ok to use spreadsheets to track donors?

  1. Looking beyond the start-up period and spreadsheet: I would suggest creating a unique ID for each constituent and using it for each of that constituent’s materials in every spreadsheet. Such an ID will facilitate sorting and retrieving segmented data within the spreadsheets. More importantly, when the organization is ready for a relational database, importing each spreadsheet into the database and using the unique ID to enforce referential integrity will be a simple, straightforward process. Incidentally, I can use Excel but am primarily an Access junkie who used this process to move a large amount of data from a failing CRM product to a fairly sophisticated database via .csv. My organization is now looking at LGL as a likely successor, owing to its online access to multiple users and the availability of some standard CRM reports.

    1. R.C.,

      That’s an excellent point about creating a unique ID! And, we’re thrilled to hear you are considering LGL as your organization’s first donor management system!

      Thanks,
      Timi

Leave a Reply

Your email address will not be published.

Ready to try LGL? Get your first 30 days free. No credit card required.