Roster Exports from Other Systems
21 Aug 2024

If you're planning to import an existing roster into MyKidReports to get started more quickly, you're in the right place!
 

As an added service for new schools, MyKidReports will import your existing roster to save you time and help you get up and running faster. If you are transitioning to MyKidReports from another third-party system, please follow the relevant steps below to export your roster. No re-formatting is necessary—our team will handle everything else!
 

The preferred format for your roster is CSV or XLSX. These spreadsheet file types are universally recognized and help prevent potential errors that can occur when converting other file formats into a CSV.

 

Table of Contents

  • MyBrightwheel
  • Procare
  • Procare Connect
  • Lillio (formerly HiMama)
  • Sandbox
  • SmartCare
  • Seesaw
  • Childcare Sage
  • Jackrabbit
  • LifeCubby
  • Blackbaud
  • ChildWare
  • Dubsado
  • CuraCubby
  • QuickBooks
  • Playground
  • Early Learning Ventures



1. MyBrightwheel

 

  • Log in on the web
  • Click to expand My School and select Students
  • From the menu on the left, click My School and then Students
  • Use the filter options (Student's Name, Status, and Room) to narrow down the roster, if desired
    ​Please Note: The Roster defaults to show all Active students. Choose a different Enrollment Status to export the roster for students with different statuses.
  • Click the Export Roster button
  • Select or add the email address(es) the export should be sent to
  • Select/deselect the columns that should be included in the export
  • Make sure always to keep First Name, Last Name, and Homeroom selected! 
    ​Please Note: The reports are sent immediately, but if your school is large, this may take a few minutes. Once you receive the email, you can download the report and print.
  • Click the orange button at the bottom of the pop-up to send to all selected email addresses


 

 

  • The export can include any or all of the following fields:
  • *First Name
  • *Last Name
  • Student Id
  • Enrollment Status
  • Enrollment Date
  • Enrollment Additional Details
  • Toured Date
  • Desired Start Date
  • Paperwork Date
  • Rooms & *Homeroom
  • Sibling Attending
  • Birth Date (Or Expected Birth Date)
  • Ethnicity, Gender, and Race
  • Meal Type
  • Allergies & Medications
  • Doctor's Information
  • Address Information
  • Parent information for all parents: Name, Email, Mobile Phone Phone 1 & 2
  • Approved Pickup information for all contacts: Name, Email, Mobile Phone, Phone 1 & 2
  • Family contact information for all contacts: Name, Email, Mobile Phone, Phone 1 & 2
  • Emergency Contact information for all contacts: Name, Phone 1, and Relationship


2. rocare Software

 

1. 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 MyKidReports.


Please Note: MyKidReports will only upload students with an active status. Any withdrawn students or those without a status will not be imported to your MyKidReports 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.

 

2. 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


3. 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)

 

2. Click Create towards the bottom right of the screen to generate the reportOnce the report has been generated, click the down arrow next to the floppy disk on the bottom left and select Export as CSV


2. 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).

 

3. Do not edit this export; any changes made to this spreadsheet before sending it to MyKidReports 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:


 

3. Procare Connect


Review ProCare Connect's specific help center article on this process here!
 

  1. Login to ProCare Connect

  2. On the left-hand side, go to Reports

  3. Scroll down, under Management, and select Students & Family


  4. 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)

  5. Click Generate Report
  6. The report will be generated on the right side of Procare Connect, and then click to Download

    The report should look like the image below:


Lillio (formerly HiMama)

  1. Login to Lillio and open the Reports module

  2. Select the Child Profile section

  3. Scroll down to Filter data and select the Center, Classroom, and Status (choose Active) for which you want to export
  4. 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 MyKidReports one right after the other

     

  5. 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:

2. Sandbox Childcare Software
 

  1. Login to Sandbox and select Admin Reports
  2. Click on Child Roster
  3. Select Export to Excel
     

3. SmartCare


1. Login to SmartCare and select Reporting
2. 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)

3. Refresh the report

4. 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.

 

4. Seesaw Childcare Software
 

  1. Sign in to Seesaw as an Admin
  2. Click on the Classes tab
  3. Click on the [...] button
  4. Click on Download CSV of Class Rosters

 

Childcare Sage

💡 Review Childcare SE's specific help center article on this process here (page 12)!

  1. Sign in to Childcare Sage
  2. Open the Report Screen from the main screen
  3. Click where it says Contact Report


  4. 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
  5. Make sure that all of the fields are added to the Report Fields box by clicking the Add Field button
  6. Save as a CSV

 

Jackrabbit

  1. Go to the Students menu
  2. Select Student Reports or the Reports
  3. Select Families/Students from the left menu
  4. Choose Recommended, and then select the Student Detail Report.
  5. 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
  6. Click on Submit
  7. Click the three-dot More icon to export the data to Excel

 

LifeCubby

  1. Login to LifeCubby and select the Active Parents and Guardians Roster
  2. Click Manage My Program, and run the report as an Excel spreadsheet
  3. Go back and select the Active Student Roster
  4. 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 MyKidReports account.

 

Blackbaud

  1. Login to Blackbaud and select Classes to open a dropdown menu
  2. Select the specific courses from within this dropdown menu, then select the Roster tab
  3. Click Run Roster/Student Reports and select the Course Roster report
  4. Export this report as a CSV, Excel, or Numbers file
  5. From Run Roster/Student Reports, you can also select the Emergency Contacts report
  6. Export this report as a CSV, Excel, or Numbers file

 

ChildWare

  1. Login to ChildWare
  2. Click Reports/Docs in the blue bar along the top of the screen and select Reports from the drop-down menu
  3. Select Child/Family Reports
  4. Click Print to save the report as an Excel file

 

Dubsado

💡 Review Dubsado's specific help center article on this process here!

  1. To export all of the existing clients, head to Utilities >> Address Book
  2. 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!

  1. Open Curacubby and click Simple Reports
  2. Click New Report, and type in the title (such as ‘Roster Export’)
  3. Click Add Section and then click to expand the section
  4. Type in the title, and type ‘all’ in the tag list to include all students
  5. 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
  6. Click Create Simple Report - use the Eye icon to view the report, and use the ‘+’ to expand a row
  7. 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)!

  1. Login to QuickBooks
  2. Go to Reports
  3. Under the Sales and Customer section, select Customer Contact List
  4. 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
  5. Select the Export icon next to the Print icon, then choose Export to Excel

The report should look like the image below:

 

Playground

 

1. Navigate and click on the Students tab under My School.

2. 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.


3. 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.

3. 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.
 

4. 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.

 

 

Powered by
MyKidReports