Student and Parent datasheet template

Use this datasheet template to fill out student and parent data, then send it to Finalsite Support in a "Data Upload" ticket. We'll update your site's database to include this information.

Alternatively, follow the instructions in Upload constituent data to Constituent Manager to import the completed datasheet yourself.

How to use this datasheet

"Students" worksheet

  1. Fill in the "Students" worksheet with the data for the students to be uploaded. Use a unique import ID for each student, and take note of them. 

"Households-Parents" worksheet

This worksheet will create "Parent" constituents, and their households. A spousal relationship will be created between the first parent (columns I–AA) and the sp_ parent (columns AB–AS). If a parent lives in another household (e.g., divorced parents), they should be included in a new row.

  1. Enter the name and address of the student's primary household on the Households-Parents worksheet.

  2. Enter the data for the student's parent(s) living in the primary household on that household's line. Columns I–AA are for the first parent, and columns AB–AS are for that parent's spouse. Each parent must have a unique import ID.

  3. If there is a second household, enter that household's name and address on a new line, then enter that household's parent data as in step 3.

"Relationships" worksheet

This worksheet will define the relationships between the students on the first worksheet and the parents on the second worksheet.

  1. Enter the student's import ID in column B of the Relationships worksheet.

  2. Enter the import ID for the parent that lives with the student in column C. The student will be added to this parent's household. Enter that parent's relationship to the student (e.g., Mother, Father) in column D.

  3. If the first parent has a spouse in the same household, enter that parent's relationship to the student (e.g., Father, Step-Mother) in column E.

  4. If the student has a secondary household, enter the import ID of the first parent in that household in column F. Enter that parent's relationship to the student in column G and their spouse's relationship to the student in column H.

  5. If necessary, copy columns F through H for additional parents and update the column headers to Parent3, etc.

Save for upload

  1. Save each worksheet separately as a tab-delimited text file.

NOTE: Please be sure to check back here for the latest version of the spreadsheet.

Was this article helpful?
2 out of 3 found this helpful

Comments

0 comments

Please Sign in to leave a comment if you don't see the comment box below.