As an added service for new schools, brightwheel will import your existing 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!
The preferred format for your roster is CSV or XLSX. These spreadsheet file types are universally recognized and will prevent potential errors that can occur when converting other file formats into a CSV.
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:
HiMama
Login to HiMama 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
💡 Review CuraCubby's specific help center article on this process here!
Open Curacubby and click Simple Reports
Click New Report, and type in the title (such as ‘Roster Export’)
Click Add Section and then click to expand the section
Type in the title, and type ‘all’ in the tag list to include all students
Click any of the checkboxes next to the information you want to include
For a roster export, you will need First Name, Last Name, Birth Date, Parent 1 Name, Parent 1 Mobile, Parent 1 Email, Parent 2 Name, Parent 2 Mobile, Parent 2 Email
You may also include Address, City, State, Zip, Doctor Name, and Doctor Phone if you would like
Click Create Simple Report - use the Eye icon to view the report, and use the ‘+’ to expand a row
Download the report as an XLS file by clicking the Download button at the bottom of the report
QuickBooks
💡 Review QuickBook's specific help center article on this process here (under Export Excel Files > Customer/Vendor/Payroll list and transactions)!
Open the Customer/Vendor/Payroll Center
Select the Excel dropdown
Choose Export Customer list
In the Export window, choose whether to create a new worksheet or update an existing one
Click the Export button (QuickBooks will open MS Excel)
Save the file
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
Unfortunately, we do not have instructions for Early Learning Ventures. We suggest you contact their support team to obtain the report called Active Children Report. This is the best report we know of for you to pull student information from this system.
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, then here are instructions on how to export the students from that previous school to get them imported into your new account. Please note that any students with a Removed, Withdrawn, or Graduated status will not be uploaded to the new account.
Export Roster From Old Brightwheel Account
*If you do not have access to the old brightwheel account yourself, then ask the previous owner to follow steps 1-6 so they can get the export sent to you.
Log into the old brightwheel account
From the menu on the left, click My School and then select Students
Click on the Export Roster button near the top right-hand side of the page
Under Select recipients, select or add the email address(es) the export should be sent to
Under Select columns, keep all of the fields checked so as much information can be included in the export as possible
Click Send (please note: the report is sent immediately, but if your school is large, this may take a few minutes)
Review Roster
Go to your email inbox, and download the roster that was sent to you (the email subject line will be “Your brightwheel roster export”)
Save the file to your Downloads folder, leaving it in its original spreadsheet format (as a csv)
Update the name of the file to match the name of the new school the information will be uploaded into
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 upper right-hand corner
Select the Upload roster option
Click on Submit your roster, and then select the brightwheel roster file you just saved