Import Sites

Import site records and site demographics data in bulk using spreadsheet files.

PEARS supports two import workflows for site data: importing new site records from a spreadsheet, and importing site demographics data.

Permission required: Organization administrator or programming manager.

Import Site Records

Use this workflow to create multiple site records at once from a spreadsheet file.

1

Download the Import Template

From the site import page, click Download Template to generate an import template customized to your organization. The template includes columns for all site fields and a Key Mapping sheet listing valid values for city, state, area type, and setting fields.

2

Prepare the Spreadsheet

Fill in the template with your site data. The following columns are available:

Column	Required	Description
reported_by_email	No	Email of the user to assign as creator
site_name	Yes	Site name
address	Yes	Street address
address_2	No	Secondary address line
city	Yes	City name (must exist in the selected state)
zip_code	Yes	Zip code
state	Yes	State code (e.g., KS, IL)
area_type	No	Area type slug
setting	No	Setting name
is_organization	No	Yes or No
parent_site	No	Name of an existing organization site
external_id	No	External identifier
contact_name	No	Primary contact name
contact_email	No	Contact email
contact_phone	No	Contact phone number
is_ada_accessible	No	Yes or No
is_within_tribal_jurisdiction	No	Yes or No
tribal_name	No	Name of tribal organization
comments	No	Additional notes

3

Upload the File

Upload the completed spreadsheet file. PEARS will validate each row and report any errors such as missing required fields, unrecognized cities, or invalid parent site references.

4

Review and Confirm

Review the validation results. Rows with errors will not be imported. Correct any issues and re-upload if needed.

Import Site Demographics

Use this workflow to update demographic data for existing sites in bulk.

1

Export Current Demographics

From the site demographics import page, download the current demographics export. This provides a spreadsheet pre-filled with your existing site IDs, names, and any current demographic values.

2

Update the Spreadsheet

Fill in or update the demographic percentage columns:

Column	Description
site_id	Site ID (required, must match an existing site)
site_name	Site name (for reference)
pct_free_lunch	% eligible for free lunch
pct_reduced_lunch	% eligible for reduced lunch
pct_gender_male	% male
pct_gender_female	% female
pct_gender_non_binary	% non-binary
pct_age_lt5	% under 5 years old
pct_age_5to17	% ages 5-17
pct_age_5to7	% ages 5-7 (subcategory)
pct_age_8to10	% ages 8-10 (subcategory)
pct_age_11to13	% ages 11-13 (subcategory)
pct_age_14to17	% ages 14-17 (subcategory)
pct_age_18to59	% ages 18-59
pct_age_60to75	% ages 60-75
pct_age_76plus	% ages 76 and older
pct_hispanic	% Hispanic
pct_non_hispanic	% non-Hispanic
pct_amerind	% American Indian/Alaska Native
pct_asian	% Asian
pct_black	% Black/African American
pct_hawpac	% Native Hawaiian/Pacific Islander
pct_white	% White
pct_race_other	% Other race
pct_race_two_or_more	% Two or more races

NOTE: All percentages must be between 0 and 100. Within each category (gender, age, ethnicity, race, lunch), the sum cannot exceed 100%. The age 5-17 subcategory percentages must equal the total 5-17 percentage.

3

Upload the File

Upload the completed spreadsheet. PEARS will validate each row against the existing site records and demographic rules.

4

Review and Confirm

Review the results. Demographics are associated with the current open SNAP-Ed reporting period.