As an added service for new schools, brightwheel will import your existing student roster to save time and get you up and running faster.
If you are coming to brightwheel from another third-party system, please follow the relevant steps below to export your roster. No re-formatting is necessary, our team will take care of the rest!
Table of Contents
Procare
Before exporting your ProCare file, please make sure that:
Your student list is up-to-date, and only the currently active students have an enrolled status. Please see below for a list of the ProCare statuses we process and what we upload them as in brightwheel.
Please Note: Brightwheel will only upload students with an active status. Any withdrawn students or those without a status will not be imported to your brightwheel account.
Ensure that the Relationship Type boxes are checked for all of the contacts associated with the active students. It is important for us to know the type of contact because of the various contact permission levels.
Open ProCare
Click on the Family Data & Accounting tab (located on the top of the screen), then click on Reports and select Data Viewer from the drop-down
Select Child Relationships, and on the right side of the screen, select today’s date in the As of Date field
If you do not see Child Relationships then click on Child Information (User Defined)
Click Create towards the bottom right of the screen to generate the report
Once the report has been generated, click the down arrow next to the floppy disk on the bottom left and select Export as CSV
You may be asked to save the export with a name — we suggest you name it the name of your school. Once you name the export, save it in a location that is easy for you to find (like your desktop).
Do not edit this export; any changes made to this spreadsheet before sending it to brightwheel may complicate our process of converting the file into a format that our system can process and can result in errors.
The report should look like the image below:
Procare Connect
💡 Review ProCare Connect's specific help center article on this process here!
Login to ProCare Connect
On the left-hand side, go to Reports
Scroll down, under Management, and select Students & Family
Select Custom (All Fields)
If you do not see the Custom (All Fields) option in the dropdown, select all the fields manually (being sure to select student first name, student last name, room, and any parent name and contact fields)
Click Generate Report
The report will generate on the right side of Procare Connect, and then click to Download
The report should look like the image below:
Lillio (formerly HiMama)
Login to Lillio and open the Reports module
Select the Child Profile section
Scroll down to Filter data and select the Center, Classroom, and Status (choose Active) for which you want to export
Select Generate Report, which will prompt the report to download as a .csv file (if you are unable to locate the file, check your Downloads folder)
* Please note that you can only export one room of students at a time, so you will need to follow these directions for each room in your center, then submit them all to brightwheel one right after the other
Save each report using the name of the classroom and how many classrooms you have. For example, if you have 5 classrooms and one of them is called Red, save the report as Red 1 of 5. Do the same for all five classrooms consecutively. This will help us ensure that we have all of your classrooms and that they are ready to be uploaded.
Each classroom report should look like the image below:
Sandbox
Login to Sandbox and select Admin Reports
Click on Child Roster
Select Export to Excel
SmartCare
Login to SmartCare and select Reporting
Select ONE of the following report types:
Click on Children List (With Custom Fields), then select all fields that apply (please include child first and last name, homeroom, primary account owner and their contact information at a minimum)
or
Click on Directory (Roster), then select all fields that apply (please include child first and last name, homeroom, primary account owner and their contact information at a minimum)
Refresh the report
Download this report as an XLS file
The Children List report should look like the image below:
The Directory (Roster) report should look like the image below:
Please Note: Sometimes in the SmartCare exports, the column headings may end up misaligned from the column bodies and column content may be merged. In this case, we can still accept the file.
Seesaw
Sign in to Seesaw as an Admin
Click on the Classes tab
Click on the [...] button
Click on Download CSV of Class Rosters
Childcare Sage
💡 Review Childcare SE's specific help center article on this process here (page 12)!
Sign in to Childcare Sage
Open the Report Screen from the main screen
Click where it says Contact Report
You will see a list of fields on the left side and a box that says Report Fields in the center. The fields will be listed in alphabetical order. We recommend you select the fields listed below, but you can click where it says “Add All”.
Address 1
Address 2
Birth Date
Category
City
Class Number
Enroll Date
Father
Father Cell
Father Email
Father Work
First Name
Last Name
Mother
Mother Cell
Mother Email
Mother Work
Notes
Pickup 1 Name *(there may be multiple)
Remarks
State
Zip Code
Make sure that all of the fields are added to the Report Fields box by clicking the Add Field button
Save as a CSV
Jackrabbit
Go to the Students menu
Select Student Reports or the Reports
Select Families/Students from the left menu
Choose Recommended, and then select the Student Detail Report.
You can filter your list of students using any or all of the available Search Criteria and Jackrabbit will compile a report of students who meet ALL of the criteria chosen
Click on Submit
Click the three-dot More icon to export the data to Excel
LifeCubby
Login to LifeCubby and select the Active Parents and Guardians Roster
Click Manage My Program, and run the report as an Excel spreadsheet
Go back and select the Active Student Roster
Click Manage My Program and run the report as an Excel spreadsheet
Please Note: Our team needs both exports to be submitted. If you are not able to provide both, our team will at least need the active parent roster and we recommend allowing parents to edit child information in their brightwheel account.
Blackbaud
Login to Blackbaud and select Classes to open a dropdown menu
Select the specific courses from within this dropdown menu, then select the Roster tab
Click Run Roster/Student Reports and select the Course Roster report
Export this report as a CSV, Excel, or Numbers file
From Run Roster/Student Reports, you can also select the Emergency Contacts report
Export this report as a CSV, Excel, or Numbers file
ChildWare
Login to ChildWare
Click Reports/Docs in the blue bar along the top of the screen and select Reports from the drop-down menu
Select Child/Family Reports
Click Print to save the report as an Excel file
Dubsado
💡 Review Dubsado's specific help center article on this process here!
To export all of the existing clients, head to Utilities >> Address Book
In the upper right, click Export and choose Email Addresses
This will generate a CSV file that contains the following fields for all of your clients: Client First Name, Client Last Name, Phone Number, Email Address, Street Address Line 1.
CuraCubby
Open CuraCubby and click Simple Reports (on the left hand side)
Click or search for Facility Roster
You may have two options; one reading ‘All Students’ and the other reading ‘Enrolled’
Click on the one that says ‘Facility Roster (Enrolled Students)’ and wait for it to process
After it loads, look over the preview and make sure all of the information is correct and includes your student and parent names/information
You can then download the report by going to the top right corner, under ‘Download formats’, and selecting the CSV or XLSX option
QuickBooks
💡 Review QuickBook's specific help center article on this process here (under Export Excel Files > Customer/Vendor/Payroll list and transactions)!
Login to QuickBooks
Go to Reports
Under the Sales and Customer section, select Customer Contact List
Note: You can modify this report by selecting the three vertical dots (⋮) icon, then Customize
Under Rows/Columns dropdown, select Change columns
Add your desired columns — make sure to include the name of the student, the name of the parents and their contact information
Then select Run Report
Select the Export icon next to the Print icon, then choose Export to Excel
The report should look like the image below:
Playground
Navigate and click on the Students tab under My School.
To select which columns you would like on your export, you will need to click on the settings icon on the right-hand side below the ‘Filters’ tab.
When you click on the settings icon, you will want to ensure that you display all your applicable columns by toggling the field next to the column name.
IMPORTANT: Please make sure that you toggle on the student first name, last name, and class fields, as well as the ones for parent names and parent contact information (email and/or phone number).
When the toggle is green, it means the column is enabled and will display on your export.
When the toggle is gray, it means that the column is disabled and will not display on your export.
Once you are done selecting all of the applicable fields, click the settings icon to close the menu and click on the blue Download view button above the gray heading bar. You will be prompted to select which columns you would like to download the data for in the Export data window.
You have the option to select all the fields you have information for in your Playground account, or only the selected columns you enabled on the settings icon previously that are currently showing on your dashboard. Once you have selected the proper data you would like to export, click Download. You will see your .csv file at the bottom of your screen.
Early Learning Ventures
Login to your Early Learning Ventures account
Click on Reports on the left hand side bar and click on Reporting
Select the Active Children Report
Once you have your report open, you will see a drop down for Report Format
Click the drop down and select Character Separated Value (CSV)
If your organization has more than one school, click on the Provider drop down and select the location you want to export for
Note: You will need to repeat this process if you want to export for your additional locations
On the right, you will see Room. Select this dropdown and make sure your rooms are correct for your location. Then, select All to ensure all students and homerooms are pulled over to your report
Download the report by going to the bottom right corner, and clicking the blue button that says Report
WonderSchool
Login to your WonderSchool account
Click on School Management on the left hand side bar
Click on Family and Contacts
On the right hand side, click the Download button
ChildPlus
Click on the Reports tab and choose Export
Select report 6501 - Data Export
Check Participants and Family
Choose the ASQ Export transformation record from the list
Click on the Participants and Family Information tab and check Enrollment
Click Export to XML
Choose the location on your computer where you want to save the export file
Save the export file as a .csv file — to do this, you will manually need to highlight the file's extension (this will be the last three letters of the file name) and type csv instead
Click Save
Other System
Unfortunately, we do not have instructions for systems other than the ones listed in this article. We suggest you contact that system's support team to obtain a spreadsheet containing at least students’ names, homerooms, parents’ names, and contact information.
Brightwheel
If you are taking over a school that already used brightwheel previously, the roster from the previous provider can be exported and then uploaded to the new account.
Step 1: Export Roster From Old Brightwheel Account
💡If you do not have access to the old brightwheel account yourself, we recommend contacting the previous owner to follow steps 1-6 so they can get the export sent to you. Please note that any students with a Removed, Withdrawn, or Graduated status will not be uploaded to the new account.
Log into the old brightwheel account
From the menu on the left, click My School and then select Students
Click on the Export Roster in the top right corner
Under Select recipients, select or add the email address(es) the export should be sent to
Click Send
💡If your school is large, the roster may take a few minutes to arrive.
Step 2: Review Roster
Navigate to your email inbox and download the roster that was sent
💡The email subject line will be “Your brightwheel roster export”Save the file to your device, leaving it in its original spreadsheet format (as a CSV)
Update the name of the file as needed
Step 3: Submit Roster to New Brightwheel Account
Login to the new brightwheel account
From the menu on the left, click My School and then select Students
Click on Add Students in the top right corner
Select the Bulk upload option
Click Choose files to select the brightwheel roster file you just saved
Once the correct file has been added, click Send files
Look for the green check mark to confirm the file was successfully submitted