Paypal vs Integrated Donation form

A Practical Guide to Using Spreadsheets

It’s not uncommon to see start-up nonprofits using spreadsheets to organize information. Spreadsheets seem like a sufficient solution and non-profits assume database programs cost money, which start-ups don’t have. (Sumac Bronze is a fully functional database program available to small nonprofit organizations for free). Some will eventually move to a database once the organization gets bigger. Others will keep using spreadsheets with no intention of ever switching.

Generally speaking, using spreadsheets to organize your nonprofit’s data causes problems:

  • The person who created the spreadsheet is often the only one who understands how it works. So when someone else needs the information, it may not be available.
  • Spreadsheets do not impose editing controls. They let you enter dates in email columns and phone numbers in street address columns. Over time, data quality gets lower and lower.
  • Spreadsheets are single-user. You cannot have two people sharing and using the contents of a spreadsheet.
  • Spreadsheet supports only very simple data structures. Setting up records for contacts and recording their monthly donations, regular attendance at ticketed events, and occasional volunteer activities is complex and error prone if you have only a spreadsheet to work with.
  • Spreadsheets do not let you create the rich organizational memory your nonprofit needs to thrive. See article: Time for a spreadsheet Intervention? The Critical Importance of Organizational Memory.

If you’re going to use them, however, you should make sure you’re using them correctly. Here are some tips for organizing your data more effectively in spreadsheets:

Have a separate spreadsheet for each logical group of data

If your organization manages both contacts and donations, don’t try to put all of this information into one spreadsheet. You will find that it just doesn’t work. Instead, put contact information in one spreadsheet and donation information in another. The data will be a lot easier to organize and use.

Use each row to represent a single record

For contacts put all the information about one contact (e.g. first name, last name, phone number) in a single row. Do not use rows to indicate attributes of records. For example, using “Board” and “Staff” as titles for groups of contacts:

First NameLast name

Phone number

Board 

 

JohnSmith

123-4567

JaneDoe

567-8901

Staff 

 

AliceJones

543-9876

BobBarton

890-4321

The problem with doing this is that any re-organization (e.g. sort by last name) causes the information about contact types (board or staff) to be separated from the contact records themselves, like this:

First NameLast name

Phone number

BobBarton

890-4321

JaneDoe

567-8901

AliceJones

543-987

JohnSmith

123-4567

Board 

 

Staff 

 

To make the data more user-friendly and easy to transfer into a database, the data should instead be organized like this:

PositionFirst NameLast name

Phone number

BoardJohnSmith

123-4567

BoardJaneDoe

567-8901

StaffAliceJones

543-9876

StaffBobBarton

890-4321

Put only one type of information in a column

When you create a spreadsheet, it may seem like a good idea to have a column designated for one of two things, say “Date or Comment,” but it will lead to confusion. Instead, make two columns, one for Dates and one for Comments.

Put only one value in each cell

If the column is Phone Number, don’t put two phone numbers in it. If a record needs two phone numbers, add a “Phone Number Two” column and put the second number in that column. Likewise, do not put an entire address in one column like this:

Address

123 Main Street Happytown, ON, J0Y 1S1
265 Maple Avenue Appletown, MB K8R 8U8
12 Orangeview Drive Maple, NB H7Y 3W5

1289 Plum Street Crepeview, AB G9G 4L6

Almost every program that needs to process the data will be able to handle it more effectively if the pieces are broken up so that there is only one value in each cell. So if you are entering addresses, break the data into separate columns like this:

StreetCityState

Postal Code

123 Main StreetHappytownON

J0Y 1S1

265 Maple AvenueAppletownMB

K8R 8U8

12 Orangeview DriveMapleNB

H7Y 3W5

1289 Plum StreetCrepeviewAB

G9G 4L6

When you sort, make sure you select the whole spreadsheet first

This is very important. If you do not select the whole spreadsheet, you may split records. For example, if you have these two records of three columns each:

First nameLast name

Phone number

JohnSmith

123-4567

JaneDoe

567-8901

and you sort just the first two columns by last name, you end up with:

First nameLast name

Phone number

JaneDoe

123-4567

JohnSmith

567-8901

which gives each person the wrong phone number.

Colour a few (non-consecutive) rows to prevent mismatching caused by incorrect sorts

Using the example above, if we had coloured the first row like this:

First nameLast name

Phone number

JohnSmith

123-4567

JaneDoe

567-8901

then sorted by just the names, we would have produced this:

First nameLast name

Phone number

JaneDoe

123-4567

John

Smith

567-8901

which shows that the John Smith record has been broken up.

Don’t expect formulas to be preserved

The values contained within formulas will be lost as your data is converted from one format to another, preparatory to being imported into your new database.

If you have donation amounts and dates being entered into two columns:

e.g. 500.00 on January 15 and 600.00 on March 23

do not create a formula “=500+600” in one cell, and put “January 15,March 23” in another cell.

Instead, create columns for the separate donations (Donation Amount 1, Date 1, Donation Amount 2, Date 2).

Enter dates in a way that spreadsheet programs recognizes

Spreadsheet programs let you enter anything you want into each cell, but they only recognize certain things as dates. For example, most spreadsheet programs will not recognize “15 Jan” or “15 January” as a date.

If whatever you are entering is not automatically reformatted to date format (e.g. ISO standard yyyy mm dd or 2010 12 25) then what you have entered has not been recognized as a date and the software won’t be able to sort the data correctly.

Chances are if your spreadsheet program doesn’t recognize it as a date, neither will other programs, so if you have to convert your data for any reason (e.g. when moving to a database) you’re going to be in trouble.

Entering complete dates is good practice anyway, since while “15 Jan” may be meaningful on January 16, when you are entering the data, you will probably have forgotten which January 15 was intended 3 years down the road.

Do not use colour to indicate data

You may be tempted to use colour to group data. For instance, mark current contacts green and inactive ones blue and big donors magenta. But if you are planning to move to a database, this colour information will be lost when the data is exported from the spreadsheet.

Download Your Free Guide on Choosing CRM Software for Your Nonprofit!

  • Hidden
  • Hidden
  • Hidden
  • This field is for validation purposes and should be left unchanged.

GET MORE CONTENT LIKE THIS DELIVERED TO YOUR INBOX!

Sign up for our newsletter packed full of nonprofit help!

  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • This field is for validation purposes and should be left unchanged.
Scroll to Top

Premium Case Management Package

Take your program to the next level by integrating your fundraising.
Includes:

All Basic features:

  • Client profile & case intake definition
  • Complete case lifecycle tracking
  • Resource management
  • Service tracking
  • Email marketing
  • Reporting
  • Communication tracking
  • Workflow management
  • Quickbooks integration
  • Cloud-based access
  • Phone & email support

All Standard features:

  • Specialized Case Management setup (configured for health & social services, transition & emergency shelters, hospice & palliative care)
  • Client registration & intake webforms

Plus:

  • Donor management
  • Donation webforms
  • Pledges & monthly donations
  • Automatic receipting
  • Fundraising campaigns
  • Event management

Includes: Up to 750 contacts; Up to 5GB of storage capacity
(cloud-based); Up to 13 concurrent users

Need more contacts, storage, or users? Just ask us!

Premium Memberships Package

Take your program further by integrating fundraising.
Includes:

All Basic features:

  • Manage member lifecycles
  • Member & membership tracking
  • Custom membership level definition
  • Email marketing
  • Reporting
  • Communication tracking
  • Workflow management
  • Quickbooks integration
  • Cloud-based access
  • Phone & email support

All Standard features:

  • Membership registration webforms

Plus:

  • Donations & fundraising
  • Donation webforms
  • Pledges & monthly donations
  • Fundraising campaigns
  • Event management
  • Automatic receipting
Includes: Up to 750 contacts; Up to 5GB of storage capacity
(cloud-based); Up to 3 concurrent users
Need more contacts, storage, or users? Just ask us!

Standard Memberships Package

Membership purchases flow from your web forms, through payment processing, and into your database, so there's less effort and less errors.
Includes:

All Basic features:

  • Manage member lifecycles
  • Member & membership tracking
  • Custom membership level definition
  • Email marketing
  • Reporting
  • Communication tracking
  • Workflow management
  • Quickbooks integration
  • Cloud-based access
  • Phone & email support

Plus:

  • Membership registration webforms
Includes: Up to 750 contacts; Up to 5GB of storage capacity
(cloud-based); Up to 3 concurrent users
Need more contacts, storage, or users? Just ask us!

Premium Donations Package

Manage complex donations for planned giving and larger gifts.
What's Included

All Basic features:

  • Donor & donation tracking
  • Email marketing
  • Fundraising campaigns
  • Pledges & monthly donations
  • Event management
  • Receipting
  • Reporting
  • Communication tracking
  • Workflow management
  • Quickbooks integration
  • Cloud-based access
  • Phone & email support

All Standard features:

  • Donation webforms

Plus:

  • Grant Management
  • Major Gift Proposals
  • Prospecting
  • Volunteer Management with online signup

Includes: Up to 750 contacts; Up to 5GB of storage capacity (cloud-based); Up to 3 concurrent users

Need more contacts, storage, or users? Just ask us!

Standard Donations Package

Donations flow from your website forms, straight through payment processing, and to your database, so there's less effort and less errors.
What's Included
All Basic features:
  • Donor & donation tracking
  • Email marketing
  • Fundraising campaigns
  • Pledges & monthly donations
  • Event management
  • Receipting
  • Reporting
  • Communication tracking
  • Workflow management
  • Quickbooks integration
  • Cloud-based access
  • Phone & email support
Plus:
  • Donation webforms
Includes: Up to 750 contacts; Up to 5GB of storage capacity
(cloud-based); Up to 3 concurrent users
Need more contacts, storage, or users? Just ask us!

Basic Memberships Package

Manage your members and membership campaigns, engage members, and increase revenue.
Includes:
  • Manage member lifecycles
  • Member & membership tracking
  • Custom membership level definition
  • Email marketing
  • Reporting
  • Communication tracking
  • Workflow management
  • Quickbooks integration
  • Cloud-based access
  • Phone & email support
Includes: Up to 750 contacts; Up to 5GB of storage capacity (cloud-based); Up to 3 concurrent users
Need more contacts, storage, or users? Just ask us!

Basic Donations Package

Manage your donations and fundraising campaigns, engage donors, and increase revenue.
What's Included
  • Donor & donation tracking
  • Email marketing
  • Fundraising campaigns
  • Pledges & monthly donations
  • Event management
  • Receipting
  • Reporting
  • Communication tracking
  • Workflow management
  • Quickbooks integration
  • Cloud-based access
  • Phone & email support
Includes: Up to 750 contacts; Up to 5GB of storage capacity
(cloud-based); Up to 3 concurrent users
Need more contacts, storage, or users? Just ask us!

Standard Case Management Package

Pre-configured client management modules fit your exact program and make your administration even easier.
Includes:

All Basic features:

  • Client profile & case intake definition
  • Complete case lifecycle tracking
  • Resource management
  • Service tracking
  • Email marketing
  • Reporting
  • Communication tracking
  • Workflow management
  • Quickbooks integration
  • Cloud-based access
  • Phone & email support

Plus:

  • Specialized Case Management setup (configured for health & social services, transition & emergency shelters, hospice & palliative care)
  • Client registration & intake webforms

Includes: Up to 750 contacts; Up to 5GB of storage capacity
(cloud-based); Up to 8 concurrent users

Need more contacts, storage, or users? Just ask us!

Basic Case Management Package

Manage intake forms and client data securely so data transitions seamlessly from when a case opens to its close.
Includes:
  • Client profile & case intake definition
  • Complete case lifecycle tracking
  • Resource management
  • Service tracking
  • Email marketing
  • Reporting
  • Communication tracking
  • Workflow management
  • Quickbooks integration
  • Cloud-based access
  • Phone & email support
Includes: Up to 750 contacts; Up to 5GB of storage capacity
(cloud-based); Up to 3 concurrent users
Need more contacts, storage, or users? Just ask us!

Wait, don't go away empty handed.

Join 50,000 other nonprofits in getting the BEST nonprofit tips, tools, and how-to guides delivered right to your inbox!

Subscribe to our newsletter: