How do I use the Bulk Update tool in the school dashboard?

Admins can now make updates to students, teachers, classes, and families in bulk from the school dashboard! You can also use this tool to add new information and set up school rosters.

How do I make updates using the Bulk Update tool?

1. Log into your Seesaw for Schools administrator account at app.seesaw.me.

2. Go to the Classes, Teachers, Students, or Families tab, depending on what information you want to edit.

3. Click the 'Bulk Update' button in the upper left corner.

bulk_update_help_0.png

4. If you want to update existing information, click 'Download Current Data'.

5. If you only want to add new information, click 'Download Blank Template'.

⚠️ NOTE: There are different CSV templates for Classes, Teachers, Students, and Families. Do not try to use the same CSV template for all of them.

bulk_update_help_1.png

6. Once the CSV file has been downloaded, click 'Continue'.

7. Open the CSV file you just downloaded. Use your preferred spreadsheet editor to add or update the information for your classes, teachers, students, or families.

8. When adding or updating classes, ensure that each class takes up one line only. All teachers and students that you wish to have rostered in that class must be listed within one cell and comma-separated.

bulk_update_help_dos_and_donts.png

9. If copying student names from one spreadsheet to another, they may automatically be pasted onto separate lines. If this happens, you can use the following formulas to automatically place several student names into a single cell separated by commas.

After applying the formula, you can copy and paste this list of students into a new cell by using Paste Special> Values.

  • Excel: =TEXTJOIN(", ",TRUE, A1:A20)
  • Google Sheets: =JOIN(", ",A1:A10)

 

10. When you are done, export a .csv file with your updates.
⚠️ NOTE: If you are using Excel, make sure to save the CSV file as UTF-8 so that it can be processed (see example). 

11. In the modal, click ‘Upload CSV’ and select the .csv file you created.
bulk_update_help_2.png
12. Preview your changes and make sure that everything looks correct. Scroll down to the bottom to confirm all your changes.

13. Click the ‘Update’ button to import your .csv file and start your upload.
bulk_update_help_3.png

14. When the upload is complete, you’ll receive an email titled "Bulk Update Complete". In that email, click "Download Update Summary" to download a zip file containing the results, change log, and original data. Please check these files to make sure that the updates went through as you expected!

⚠️ NOTE: If you want to undo your changes, simply upload the "_original data.csv" file found in your "Bulk Update Complete" email.

bulk_update_help_fix-errors.png


To learn more about the specific ways you can use the Bulk Update tool, check out our guide here!
How do I set up my school rosters using the Bulk Update tool?

You can use the Bulk Update tool to set up Seesaw for Schools in 4 easy steps. Simply upload separate CSVs with your teacher, student, class, and family information. Don’t worry; you can add and update information later at any time if anything changes.

Step 1 — Set up Teachers

  • Go to the Teachers tab and click the 'Bulk Update Teachers' button.
  • Follow the instructions to upload a list of teachers.
  • ⚠️ NOTE: If you are using Excel, make sure to save the CSV file as UTF-8 so that it can be processed (see example).
  • All your teachers will now have access to Seesaw for Schools.

bulk_update_help_roster_1.png

Step 2 — Set up Students

  • Go to the Students tab and click 'Bulk Update Students'.
  • Follow the instructions to upload a list of students.

  • Students will be added to a school directory that is accessible to all teachers in your school.bulk_update_help_roster_2.png

Step 3 — Set up Classes (or ask teachers to)

  • If you want teachers to create their own classes, simply ask teachers to do so. Teachers can browse the school directory to add students to their classes.

  • If you want to create classes yourself, go to the Classes tab and click 'Bulk Update Classes'.

  • Follow the instructions to upload a list of classes.

bulk_update_help_roster_3.png

  • ⚠️ NOTE: Each class should take up one line only. All teachers and students that you wish to have rostered in that class must be listed within one cell and comma-separated.

bulk_update_help_dos_and_donts.png

  • TIP: If copying student names from one spreadsheet to another, they may automatically be pasted onto separate lines. If this happens, you can use the following formulas to automatically place several student names into a single cell separated by commas.

  • After applying the formula, you can copy and paste this list of students into a new cell by using Paste Special> Values

    • Excel: =TEXTJOIN(", ",TRUE, A1:A20)

    • Google Sheets: =JOIN(", ",A1:A10)

Step 4 — Connect Families (Optional)

  • To get the most out of Seesaw, connect family members to students. Families will be able to see student work and stay in the loop with their student’s learning.

  • Go to the Families tab and click 'Bulk Update Families'.

  • Follow the instructions to upload a list of family connections.

bulk_update_help_roster_4.png

 

CSV templates and field explanations for Bulk Update CSVs
For more information and templates for CSVs to use for bulk updates, refer to the CSV Templates & Field Explanations guide.

field_ex_classes.png
teacher_field_ex.png
students_field_ex.png
field_ex_families.png
⚠️ NOTE: In order for archived classes/students to show up in current downloaded class data, the 'Show ___ Archived Classes' must be toggled ON.
Troubleshooting the Bulk Update tool

I’m not seeing my download show up! 

  • You may need to “Allow popups” in your browser in order for downloads to work.

My CSV uploads but there are zero updates!

  • Try using Google Sheets or Numbers to save and upload CSVs if you are experiencing issues with getting your updates to go through.
  • If you are using Excel, make sure to save the file as UTF-8 so that it can be processed (example)

Help! I want to undo all my changes and go back to what I had before!

  • When your upload is complete, you’ll receive an email titled "Bulk Update Complete". In that email, click "Download Update Summary" to download a zip file containing the results, change log, and original data. To undo your changes, simply upload the "_original data.csv" file .

How do these CSVs work?

  • This sheet includes links to CSV Bulk Updates Templates as well as CSV Field Explanations
  • Data in your school will be updated to exactly match the data that you upload in your CSV files. 
  • For any information that you don’t want to update, you can remove rows or columns and the data will remain unchanged.

Tips for referencing classes, students, teachers in your CSVs: 

  • Downloads currently display unique Seesaw Identifiers to reference classes and schools, followed by the name of the class/school in parenthesis. The name is optional for uploads.
  • Downloads currently display Student IDs for students and Emails for teachers and families by default, but you should be able to use any unique identifier (email, student ID, ClassLink/Clever ID, Seesaw Identifier) in the upload. (ex. For the list of Students in the Classes CSV, you can use Student IDs to add students to the list.)
  • If a student has Student IDs in multiple schools, downloaded Student IDs may display a prefixed Seesaw Identifier for the school followed by ::: and the student ID for differentiation. When uploading new Student IDs or using Student IDs to reference students in your school, you do not need to include the prefixed Seesaw Identifier for the school.

 

 

 

 

 

 

Have more questions? Submit a request