If you are adding students using one of our pre-made Roster templates or attempting to update student profiles via our Upload Tool, you'll see multiple columns of data where you can add student and family information.
Use this resource as a reference guide for definitions of each field and what to include.
Student Identification
brightwheel_id - Brightwheel assigns a unique ID to every student once they are created at a school. If creating new students, leave this field blank, and use the Roster Export to use these IDs to edit students in bulk. More on bulk editing here.
Note: This field is not viewable on the student profile but is used when exporting and importing roster uploads to update student information and prevent duplicating profiles. If a student is already in brightwheel, do not change or remove this column.
Personal Information
These fields pertain explicitly to the individual student. Please pay close attention to the descriptions, as our import tool requires specific formatting.
first_name - Student's first name.
last_name - Student's last name.
birthdate - Student's date of birth, formatted as M/D/YYYY.
gender - At this time, our system is limited to "male", "female", or "other".
race - This field allows for any combination of the following entries - if selecting more than use, separate with a semicolon: American Indian or Alaska Native, Black or African American, White, Chinese, Filipino, Asian Indian, Vietnamese, Korean, Japanese, Other Asian, Middle Eastern or North African, Native Hawaiian, Samoan, Chamarro, Other Pacific Islander, Some Other Race
ethnicity - Please enter either Hispanic, Latino or Spanish Origin OR Not of Hispanic, Latino or Spanish Origin
allergies - Enter all student allergies here. If there is a valid entry, allergy badges will appear on student profiles.
notes - Notes are a great way to document special needs or any other useful information about this student or family. This is a free-form field.
medications - This is a free-form field; enter any medications necessary here.
doctor_name - Doctor's full name.
doctor_phone - Doctor's phone number.
Enter the address where the student resides.
street_1 - Student's street address.
street_2 - Any other address information such as PO Box, suite, or apartment number.
city - City name
state - Please use the two-letter abbreviation for the state.
country - Please use the two-letter abbreviation for the country (ie: US).
zip - Student's zip code.
Rooms
Each student should be assigned to one homeroom, and they can also be assigned to additional rooms that they may be moved into and out of throughout the day.
homeroom - This is the student's primary room assignment; there can only be one homeroom assignment per student.
room_1 - Adding additional room assignments to students allows the students to be checked in/out and moved between rooms throughout the day. Simply add a new column to the sheet and use the room_1 header; this will allow as many rooms as needed by changing the 1 to a 2, or 3, 4, 5, etc in different column
School Details
The school details information will only be visible to staff members. This is where specific information can be input for reporting and tracking.
enrollment_status - Enter the student's status as Lead, Toured, Applied, Waitlist, Prospect, Active, Inactive, Graduated, or Removed. We cannot accept custom entries for this field at this time.
meal_type - Assigning a meal type is a big help for CACFP reporting. Choose one of the following entries: not_specified, free, reduced, paid, or leave the field blank.
student_id - Use this field to enter a student ID that the school has used in the past or wants to use in the future. This is a free-form field, so enter whatever is desired or leave it blank.
Enrollment Details
All the following fields relate to the student's enrollment and family's contact with the school.
first_contact_date - When the family first contacted the school (M/D/YYYY).
toured_date - When the family toured the school (M/D/YYYY).
paperwork_date - When all required paperwork was completed (M/D/YYYY).
desired_start_date - The date the family would like the student to start attending (M/D/YYYY).
enrollment_date - The date the student actually started attending (M/D/YYYY).
graduation_date - The date the student left the school (M/D/YYYY).
expected_birth_date - For expecting parents, enter the anticipated birthdate (M/D/YYYY).
sibling_attending - If the student has or will have a sibling attending, enter TRUE. Otherwise, enter FALSE
enrollment_additional_details - Enter any additional information needed regarding this student's enrollment.
Financial Details
This set of fields allows the ability to input family income and subsidy information for each student.
family_income - Choose one of the following options and enter as seen here: Below 25,000 per year, 25,000 to 50,000 per year, 50,000 to 75,000 per year, 75,000 to 100,000 per year, 100,000 to 125,000 per year, 125,000 and above
subsidy - If the student receives a subsidy, enter TRUE otherwise, enter FALSE
subsidy_details - Enter any additional information needed regarding this student's subsidy.
Student Contacts
Student contacts are not required when uploading a roster, but this makes a huge difference in student and staff involvement.
When adding this information, please enter the minimum of first and last name per contact and an email address or a valid, ten-digit US/Canadian mobile number. The other two phone number fields are free form, so any additional numbers can be listed there. Contacts are able to update or add to their personal contact information at any time.
💡 Tip: As many contacts as desired can be added to the roster template. To add more than one Parent, Family, Approved Pickup, or Emergency student contact, simply add extra excel columns for each new contact and change the 1 after the contact title to a 2, or 3, 4, 5, etc (E.g. To add a third parent contact, add new columns titled Parent 3: First Name, Parent 3: Last Name, Parent 3: Email, & Parent 3: Mobile).
parent_1_first_name
parent_1_last_name
parent_1_email
parent_1_mobile_phone
parent_1_phone_1
parent_1_phone_2
family_1_last_name
family_1_email
family_1_mobile_phone
family_1_phone_1
family_1_phone_2
approved_pickup_1_first_name
approved_pickup_1_last_name
approved_pickup_1_email
approved_pickup_1_mobile_phone
approved_pickup_1_phone_1
approved_pickup_1_phone_2
emergency_contact_1_first_name
emergency_contact_1_last_name
emergency_contact_1_phone
emergency_contact_1_relationship