Skip to main content

Data Imports: Templates

Templates to help Site Managers prepare their data imports

Written by Brittany Crow
Updated today

Heads up! This article is only intended for Site Managers.

By the end of this article, you will be able to:

  • Identify the available import template types

  • Understand what each template is used for

  • Determine which columns to include when preparing your data

Available Import Templates

Use the following templates when preparing your data for import into your Get Connected site.

Agency or Program

Agencies (or Programs) are areas where Site Managers create volunteer Needs or Opportunities specific to their organization.

Common columns to include:

  • Agency or Program Name

  • Manager First Name & Last Name

  • Manager Email

  • Address

  • Phone Number

  • Directions

  • EIN

  • Facebook Link

  • Hours of Operation

  • What We Do

  • Who We Are

  • Twitter Link

  • Website URL

User Group

User Groups allow volunteers to be grouped under a shared “umbrella.” This makes it easier to track engagement and coordinate participation across a larger group.

Common columns to include:

  • User Group Title

  • Description

  • Allowed Email Domains

Users

Users are individuals who have accounts on your Get Connected site.

Common columns to include:

  • First Name

  • Last Name

  • Email

  • Address

  • Phone

  • Date of Birth

  • Tags

  • Company / Company Title

  • User Groups

Needs or Opportunities

Needs (Opportunities) are volunteer activities that users can respond to and participate in.

Common columns to include:

  • Need/Opportunity Title

  • Duration Type (e.g., ongoing, flexible, multi-date)

  • Date

  • Description

  • Address

  • Additional Notification Recipient Emails

  • Number of Volunteers Needed

Individual Hours

Individual Hours are imported as historical records. These are linked only to a user’s account and are not associated with Agencies/Programs or Needs/Opportunities.

Common columns to include:

  • User Email

  • Date Hours were Completed

  • Number of Hours Served

  • Description

Responses & Hours

Responses & Hours are imported to associate volunteer activity with both Needs/Opportunities and Agencies/Programs.

Common columns to include:

  • User Email

  • Agency ID

  • Need ID

  • Date Hours were Completed

  • Number of Hours Served

  • Description

FAQ

Q. I need to include every column listed?
A. No. These are examples of commonly used columns. Include only the fields relevant to your data.

Q. Can I customize my import templates?
A. Yes. You can tailor your columns to fit your organization’s needs, as long as required fields are included.

Did this answer your question?