Skip to main content

Member Data File Requirements for Academic Organizations

File Requirements

Your file must:

  • Be saved as a CSV file

  • Use UTF-8 encoding

  • Include a header row matching the field names below

  • Contain no quotes (") in column headers

  • Contain only one sheet

Sample CSV

Review our CSV template to understand correct formatting. The template includes:

  • All required, recommended, and optional fields with correct header names

  • Example data showing expected formats

Quick Reference

Start with the required fields, then add recommended fields based on what’s available in your organization’s CRM system. Each additional field improves matching quality and capabilities.

Required

Field Name

Example

Notes

First name

Jane

Field should be labelled "first_name (required)"

Last name

Doe

Field should be labelled "last_name (required)"

Email

Field should be labelled "email (required)"

Recommended

Field Name

Example

Notes

Program

Bachelor of Science

Field should be labelled "program"

Faculty

Consulting

Field should be labelled "faculty"

Class of

Also known as graduation year

2022

Field should be labelled "class_of"

Optional

Field Name

Example

Notes

Locale

Include this field to specify which members require other languages. English is the default language.

en-US

Field should be labelled "locale"

Use only: en-US, fr-CA, es-ES, ko, ja

Status

To deactivate and reactivate profiles in bulk

active

Field should be labelled "status"

Uses only: active, inactive

Did this answer your question?