CSV file format for donor imports
Every column of the donor CSV file, the date formats it accepts, and how to write names that look good on screen.
Updated 3 min read
On this page
A donor import file is a CSV file with one donor per row and a header row naming the columns. Start
from the CSV template on the import page: it has every column in place, and its rows show every
location (ALL), so it imports as it is. Columns can be in any
order; the header names must match, though capitals and spaces around a name don't matter.
Columns
| Column | Required | What to put in it | Example |
|---|---|---|---|
| Name | Yes | A unique name for the record, used to match donors when you import again. Never shown on screen. | Ron Weasley |
| Display Name | Yes | The name shown on screen. | Mr. & Mrs. Weasley |
| Amount | Yes | The donation amount. The dollar sign and commas are optional. | $35,000.00 |
| Relationship Type | No | Donor, Sponsor, Partner or In-kind Sponsor, comma-separated for several. Empty means Donor. |
Donor, Sponsor |
| Donor Since | No | The date the donor relationship began. Kept for the Donor, Sponsor and In-kind Sponsor types. |
05/24/2001 |
| Sponsorship Level | No | A giving level of your choice. Only kept for Sponsor and In-kind Sponsor. |
Gold |
| Locations | No | Your location names, comma-separated, spelled exactly as in your settings. Empty or ALL means every location. |
Main Branch, Downtown |
| Recognition Start Date | Yes | The first day the donor is shown. | 07/15/2026 |
| Recognition End Date | Yes | The last day the donor is shown. Must be after the start date. | 07/14/2027 |
Put quotes around any value with a comma, such as "Acme, Inc." or "$35,000.00". Save the file
as CSV UTF-8, so names with accents come through as written.
Older files with Sponsorship Start Date and Sponsorship End Date columns still import; they are read as the recognition dates.
Dates
All three date columns accept these formats:
| Format | Examples |
|---|---|
| Month/day/year | 03/15/2027, 3/15/2027, 3/3/2027 |
| Month/day/two-digit year | 03/15/27, 3/3/27 |
| Day-month-year with dashes | 17-03-2027 |
| Day.month.year with dots | 17.03.2027 |
A two-digit year from 00 to 69 means 2000 to 2069; from 70 to 99, 1970 to 1999. Donor Since
can be left empty.
Recognition period
A donor is shown from the Recognition Start Date through the Recognition End Date, then leaves the displays that list donors automatically. To recognize a donor indefinitely, use an end date far in the future. See Recognition periods.
Relationship types and levels
A donor can have several relationship types; Donor, Sponsor is a normal row. Displays can filter by
type, for example to show sponsors only.
Donor Since belongs to Donor, Sponsor and In-kind Sponsor, and Sponsorship Level to Sponsor and In-kind Sponsor. A
value in a column that doesn't fit the row's types doesn't stop the import: the row is imported
without it, and the review strikes it through.
Sponsorship Level is free text, so keep the spelling the same on every row. Displays offer the
levels your donors use as filter options, so Golld becomes an option of its own. Every level filter
also offers No level assigned.
Display names that look good on screen
- Use titles:
Dr. Jane SmithorMr. and Mrs. Johnsonread better than a bare name. - Use "&" for "and" in long names:
Smith & Wesson Foundation. - Avoid all capitals:
John Smith, notJOHN SMITH. - Name the company, not a person, for corporate gifts:
Acme Corporation. - Keep it short: shorter names show larger. Prefer the common name over the full legal one.
- For families:
The Smith FamilyorMr. & Mrs. Robert Smith.
Also searched as: columns, required fields, CSV template, date format, headers.
Related articles
- Import donors from a spreadsheet Add or update many donors at once with a CSV file, what the import preview tells you, and where to see past imports.
- Recognition periods: why a donor appears or disappears How long a donor is shown, and what to check when a donor is missing from a screen.
- Donor recognition: from donor list to screen How your donor list feeds your Donor Recognition displays, and how to add, edit and find donors.
Still need help?
Our support team can walk you through it.