In this Article
- Step 1: Download datasheet template
- Step 2: Complete all three tabs of the datasheet
- Step 3: Download and save as .txt file
- Step 4: Upload yourself OR submit request to Finalsite Support
Use a datasheet template to fill out student and parent data in bulk for a faster, more efficient way to add them as constituents to your platform.
Step 1: Download datasheet template
Step 2: Complete all three tabs of the spreadsheet
Open the template in your favorite spreadsheet software, such as Google Sheets or Microsoft Excel.
"Students" tab worksheet
-
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" tab 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.
-
Enter the name and address of the student's primary household on the Households-Parents worksheet.
-
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.
-
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.
-
Enter the student's import ID in column B of the Relationships worksheet.
-
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.
-
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.
-
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.
-
If necessary, copy columns F through H for additional parents and update the column headers to Parent3, etc.
Step 3: Download and save as .txt file
Important Note:
- DELETE the instructions column before downloading.
Save As a .txt file from Excel
Select File > Save As > Text (Tab delimited) .txt
Download as .tsv file from Sheets THEN save filename as .txt
from .tsv to .txt
Select Download As from the File menu, and choose Tab Separated Values (.tsv)
Go to where you saved your .tsv file and manually change the extension to .txt.
Step 4: Upload the datasheet or submit to FS support
Option A: Follow the instructions in Upload constituent data to Constituent Manager to import the completed datasheet yourself.
Option B: Submit a Request to Finalsite Support. We'll update your site's database to include this information.
Comments
Please Sign in to leave a comment if you don't see the comment box below.