Skip to content
Screen Pulse Help Center

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
  1. Columns
  2. Dates
  3. Recognition period
  4. Relationship types and levels
  5. Display names that look good on screen

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 Smith or Mr. and Mrs. Johnson read better than a bare name.
  • Use "&" for "and" in long names: Smith & Wesson Foundation.
  • Avoid all capitals: John Smith, not JOHN 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 Family or Mr. & Mrs. Robert Smith.

Still need help?

Our support team can walk you through it.

Contact support

Type a question or a few words, such as "screen offline" or "import donors".