Back to milestra.app

Free template

Free donor database template (Excel): every supporter and gift in one place

Most small fundraising teams keep supporters in one spreadsheet, gifts in another and consent in someone's inbox. This free Excel donor database puts them together: one row per supporter, one row per gift, consent to contact recorded for everyone, and a dashboard that shows income, retention and who has lapsed.

Preview of the donor database template
Excel · 4 sheets

Donor database template

Every supporter and gift in one place, with consent recorded and a dashboard that shows who to thank and who has lapsed.

  • Last gift, total given and status worked out for every donor
  • Consent to contact recorded for each supporter
  • Dashboard: income, retention and top 10 donors by year
  • Days to thank tracked for every gift
Free · Opens in Excel and Google Sheets · Sent to your inbox

What's inside the template

SheetWhat it does
Start hereSix setup steps, a status key and a short data protection checklist.
DonorsOne row per supporter: type, contact details, consent to contact, how and when they agreed, preferred channel and owner. First gift, last gift, total given and status fill in automatically.
GiftsOne row per gift: date, donor ID, amount, campaign, restricted or unrestricted, fund, payment method, receipt and thank-you date. The donor's name and days to thank fill in.
DashboardPick a year to see income, change on the year before, average gift, donor retention, unrestricted share, thank-you speed, lapsed donors to contact and the top 10 donors.

How to set up a donor database in Excel in five steps

  1. Give every supporter one ID. D001, D002 and so on. The ID links each gift to the right person, even when two people share a name.
  2. Record consent before anything else. Note whether each supporter agreed to be contacted, when, how, and on which channel.
  3. Log every gift as its own row. Totals, first and last gift and status come from the Gifts sheet, so never type them by hand.
  4. Thank within 48 hours. Enter the date you thanked each donor; the dashboard shows how many gifts were thanked within two days.
  5. Review lapsed donors monthly. Sort by status and contact lapsed supporters who agreed to hear from you, before they become lost.

Donor status at a glance

StatusMeaningWhat to do
ProspectIn the database, no gift yetIntroduce your work and invite a first gift
ActiveGave in the last 12 monthsThank, report back and ask again at the right time
LapsedLast gift 12 to 24 months agoPersonal contact: share a result and invite them back
LostNo gift for more than 24 monthsCheck consent; contact once, or archive

From a donor list to reports that show what gifts achieved

Milestra is not a donor CRM. It tracks your funders and grants, links each one to the goals and results it pays for, and builds donor and board reports from live numbers, so supporters see what their money achieved. It's free for up to 5 people, and nonprofits get 50% off paid plans.

Frequently asked questions

What is a donor database?

A donor database is one place that holds every supporter, every gift they have made and how they want to be contacted. It lets you thank people quickly, see who has stopped giving and report income accurately.

What should a donor database record?

For each supporter: a unique ID, name, type, contact details, consent to contact with date and source, preferred channel and an owner. For each gift: date, donor ID, amount, campaign, whether it is restricted, payment method and when you said thank you.

Is Excel good enough for a donor database?

For a few hundred supporters and one or two people updating it, yes. Move to a donor CRM when several people edit at once, online donations need to flow in automatically, or you run regular mailings and tax reclaims such as Gift Aid.

How should we record consent?

Record whether the person agreed to be contacted, the date, how they agreed (form, event, conversation) and the channel. Check the rules that apply to you, such as GDPR in Europe, and remove people who ask to be forgotten.

How is donor retention calculated?

Donors who gave in both the selected year and the year before, divided by donors who gave the year before. The dashboard works it out for any year you choose.

Does it work in Google Sheets?

Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. It also works in Excel 2019, Excel 2021 and Microsoft 365; in Excel 2016 the first and last gift columns need newer functions.

Is it free?

Yes. Enter your email and we send it straight to your inbox. You can share it with your fundraising team.

More free resources