Admin CSV

Bulk Edit Tool

A Guide for Seesaw Administrators

Overview

​

If you are trying to create NEW classes, please follow our CSV Rostering Guide.

​

The Admin CSV Bulk Edit Tool allows Seesaw Administrators to update user accounts and classes across their school. Here you will find instructions for how to best use the CSV Bulk Edit Tool. �

Classes Tab

• Editing Class Information
• Archiving or Restoring Classes
• Updating Teacher Access to Classes

Teachers Tab

• Creating New Teacher Accounts
• Editing Teacher Account Information

Students Tab

• Creating New Student Accounts
• Editing Student Account Information
• Add Existing Students to Classes
• Remove a Student from a Class
• Update Student Passwords
• Remove a Connected Family Member

Families Tab

• Creating New Family Member Accounts
• Updating Family Account Information

Uploading & Approving Your CSV Updates�

Admin CSV Bulk Edit Tool

2

Best

Practices

​

The following best practices apply to all Admin CSV Bulk Edit Tool changes:

​

• If you are trying to create NEW classes, please follow the CSV Rostering Guide.
• You must be signed in to your Seesaw Administrator account to use the Admin CSV Bulk Edit Tool.
• When you download the current data .csv file, do not edit the original file. Instead, save a copy of the original .csv and edit the copy.
• Only make edits to data you want to be changed in Seesaw.
• Only cells that you make changes to will be updated in Seesaw. All unedited cells will remain the same.
• You can remove rows or columns you do not want to be updated. This will not delete the data from Seesaw.
• Do NOT rename the column headers for data you are changing.
• Do NOT remove the ‘ID’ column - Seesaw Class ID, Teacher Person ID, Student Person ID, or Family Person ID. Removing this column will create duplicate users or classes.
• The Admin CSV Bulk Edit Tool works best for making changes in individual school dashboards and not at the district level. Students and teachers can be moved between classes across schools in a district using student IDs and teacher emails as long as the students and teachers are first added to the new schools, before adding them to new classes in new schools.

Admin CSV Bulk Edit Tool

3

Update Class Name

Update Grade Level

Change Sign-In Mode

Admin CSV Bulk Edit Tool

​

With the Admin CSV Bulk Edit tool, you can make the following changes to existing classes:

Archive Classes

Restore Classes

Update Teacher Access to Classes

4

Classes: Editing Class Information

Admin CSV Bulk Edit Tool

Admin CSV Bulk Edit Tool

Downloading Existing Class Data

​

These steps are for existing classes. If you are trying to create NEW classes, please follow the CSV Rostering Guide.

​

To make changes to your existing classes in bulk, you will first need to download current class data:

​

1. Sign in to your Seesaw Admin Account
2. Navigate to your school dashboard
3. Tap the ‘Classes’ tab
4. Tap ‘Add or Edit Classes In Bulk’
5. Tap ‘EDIT existing classes’
6. Select whether you would like to include archived classes in your download
7. Tap the ‘Download Current Class Data’ button

​

A pop-up will appear letting you know a .csv file is being downloaded. You can exit out of this window if you prefer the .csv file be emailed to you.

​

​

​

Editing Class Information

6

Admin CSV Bulk Edit Tool

Edit Class Name, Grade Level, or Sign-in Mode for Existing Classes

​

1. Open the downloaded .csv file and make a copy of the .csv file for edits
2. Edit the information in the Class Name, Grade Level, or Sign-In Mode columns to reflect changes you would like to make
1. Sign-In Mode options: Class Code, Class Code Shared Device, Email or SSO
2. Grade Level options: Pre-K, K, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, Other
3. Note: You can delete any columns that you are not editing. However, leave the ‘Seesaw Class ID’ column as is
3. Save updated file as a .csv
4. For upload instructions, click here

​

​

Making Changes to Class Information

7

Classes: Archive or Restore Classes

Admin CSV Bulk Edit Tool

Admin CSV Bulk Edit Tool

To Archive Classes:

1. Open the .csv of current class data you have downloaded
2. Change the text in the ‘Is Archived?’ column from FALSE to TRUE
1. Note: You do not need to edit any other cells to archive a class
3. Save file as a .csv
4. For upload instructions, click here

​

​

To Restore Classes:

1. Open the .csv of current class data you have downloaded
2. Change the information in the Is Archived? column from TRUE to FALSE
2. Note: You do not need to edit any other cells to restore a class
3. Save file as a .csv
4. For upload instructions, click here

​

​

​

​

Archive or Restore Classes

9

Classes: Updating Teacher Access to Classes

Admin CSV Bulk Edit Tool

Admin CSV Bulk Edit Tool

​

1. Navigate to your school dashboard
2. Tap on the ‘Classes’ tab
3. Tap ‘Add or Edit Classes in Bulk’
4. Tap ‘EDIT existing classes’
5. Tap ‘Download Current Class Data’
1. Data for all classes at the school will download in a .csv file
6. Open the downloaded .csv file and make a copy of the .csv file for edits.
7. To add a teacher to a class, add the teachers’ email addresses to the ‘Teacher Emails’ cell, separated by commas
1. Note: Do not delete the existing teacher information as this will remove the original teacher from the class
2. Example: teacher_1@school.edu, new_teacher@school.edu
8. To remove a teacher from a class, delete the teacher’s email address from the ‘Teachers Emails’ cell. Leave any teacher emails that should remain connected to the class.
9. For upload instructions, click here

​

Updating Teacher Access to Classes

11

First Name

Last Name

Display Name

Email Address

Teacher Mobile Number

Admin CSV Bulk Edit Tool

​

With the Admin CSV Bulk Edit tool, you can create new teacher accounts or update the following existing teacher account information:

12

Teachers: Creating New Teacher Accounts

Admin CSV Bulk Edit Tool

Creating New Teacher Accounts

.

1. Navigate to your school dashboard
2. Tap on the Teachers Tab
3. Tap ‘Add or Edit Teachers in Bulk’
4. Tap ‘Add NEW teachers’
5. Tap ‘Download Microsoft Excel Template’ OR ‘Copy Google Sheets Template’ to navigate to the Bulk Updater Templates
6. Fill out your copy of the template with teacher information from your SIS:
1. First Name
2. Last Name
3. District-assigned email address

7. Save file as a .csv

8. For upload instructions, click here

​

​

​

​

Admin CSV Bulk Edit Tool

​

14

Teachers: Editing Teacher Account Information

Admin CSV Bulk Edit Tool

Admin CSV Bulk Edit Tool

1. Navigate to your school dashboard
2. Tap on the ‘Teachers’ Tab
3. Tap ‘Add or Edit Teachers in Bulk’
4. Tap ‘EDIT existing teachers’
5. Tap ‘Download Current Teacher Data’
1. Data for all connected teachers will download in a .csv file
6. Open the downloaded .csv file and make a copy of the .csv file for edits.
7. Update the appropriate columns to change teacher First Name, Last Name, Display Name, or Email Address
8. Save the edited sheet as a .csv and navigate back to the ‘Teachers’ tab to upload your changes
1. Note: You can delete any columns you are not editing; except for Teacher Person ID!
9. For upload instructions, click here�

​

Editing Teacher Account Information

16

First Name

Last Name

Display Name

Email Address

Student ID

​

Add Student to a Class

Remove Student from a Class

Update Student Passwords

Remove Connected Family Members from Student

​

Admin CSV Bulk Edit Tool

​

With the Admin CSV Bulk Edit tool, you can create new student accounts or update the following existing student account information:

17

Students: Creating New Student Accounts

Admin CSV Bulk Edit Tool

Creating New Student Accounts

.

1. Navigate to your school dashboard
2. Tap on the Students Tab
3. Tap ‘Add or Edit Students in Bulk’
4. Tap ‘Add NEW students’
5. Tap ‘Download Microsoft Excel Template’ OR ‘Copy Google Sheets Template’ to navigate to the Bulk Updater Templates
6. Fill out your copy of the template with user information from your SIS.

For students, you will need:

• First Name
• Last Name
• Student ID
• District-assigned email address (optional)
• Password (required if email is assigned)
• Note: Students given an email need a password unless they log in SSO. SSO accounts do not require a password.

7. Save file as a .csv

8. For upload instructions, click here�

​

​

​

​

Admin CSV Bulk Edit Tool

​

19

Students: Editing Student Account Information

Admin CSV Bulk Edit Tool

Admin CSV Bulk Edit Tool

• Navigate to your school dashboard
• Tap on ‘Students’ Tab
• Tap ‘Add or Edit Students in Bulk’
• Tap ‘EDIT existing students’
• Tap ‘Download Current Student Data’
• Data for all connected students will download in a .csv file
• Open the downloaded .csv file and make a copy of the .csv file for edits
• Update the appropriate columns to change student First Name, Last Name, Display Name, Email Address, or Student ID.
• Save the edited sheet as a .csv and navigate back to the ‘Students’ tab to upload your changes
• Note: You can delete any columns you are not editing; except for Student Person ID!
• For upload instructions, click here�

​

Editing Student Account Information

21

Students: Add Existing Students to Classes

Admin CSV Bulk Edit Tool

Admin CSV Bulk Edit Tool

1. Navigate to your school dashboard
2. Tap on the ‘Students’ Tab
3. Tap ‘Add or Edit Students in Bulk’
4. Tap ‘EDIT existing students’
5. Tap ‘Download Current Student Data’
1. Data for all students will download in a .csv file
6. Open the downloaded .csv file and make a copy of the .csv file for edits.
7. In the Seesaw Class IDs column, enter in the Class IDs for each existing class where you would like the student enrolled
2. If you’re adding the student to multiple classes, separate the Class IDs with commas
3. Class IDs can be found in the URL of the class or in the ‘Seesaw Class ID’ column of the ‘Existing Classes’ .csv file from your school dashboard.
8. For upload instructions, click here

Add Existing Students to Classes

23

Students: Remove a Student from a Class

Admin CSV Bulk Edit Tool

Admin CSV Bulk Edit Tool

Removing a student from a class

• Navigate to your school dashboard
• Tap on the ‘Students’ Tab
• Tap ‘Add or Edit Students in Bulk’
• Tap ‘EDIT existing students’
• Tap ‘Download Current Student Data’
• Data for all students will download in a .csv file
• Open the downloaded .csv file and make a copy of the .csv file for edits
• In the Seesaw Class IDs column, remove the Class IDs for each existing class where you no longer want the student enrolled.
• Do not delete Class IDs for the classes where the student should remain actively enrolled.
• For upload instructions, click here

Remove a Student from a Class

25

Students: Update Student Passwords

Admin CSV Bulk Edit Tool

Admin CSV Bulk Edit Tool

1. Navigate to your school dashboard
2. Tap on the ‘Students’ Tab
3. Tap ‘Add or Edit Students in Bulk’
4. Tap ‘EDIT existing students’
5. Tap ‘Download Current Student Data’
1. Data for all students will download in a .csv file
6. Open the downloaded .csv file and make a copy of the .csv file for edits
7. Create a new column with the heading: Student Password
2. NOTE: You will not see this column on the Current Student Data download, you must add this new column manually to make password changes
8. Add the updated student passwords in the Student Password column
3. ⚠️ NOTE: Use our strong password requirements to avoid any errors
9. For upload instructions, click here

​

Update Student Passwords

27

Students: Remove a Connected Family Member

Admin CSV Bulk Edit Tool

Admin CSV Bulk Edit Tool

• Navigate to your school dashboard
• Tap on the ‘Students’ Tab
• Tap ‘Add or Edit Students in Bulk’
• Tap ‘EDIT existing students’
• Tap ‘Download Current Student Data’
• Data for all students will download in a .csv file
• Open the downloaded .csv file and make a copy of the .csv file for edits
• In the Family Members column, remove the email address of the family member you no longer want connected
• Do not delete Family Member emails for users that should remain connected to the student.
• For upload instructions, click here

​

If you need to make bulk changes to connected family member at your school, follow these steps.

Remove a Connected Family Member

29

Add Email Address

Add Mobile Number

Add or Remove Connected Students

Admin CSV Bulk Edit Tool

​

With the Admin CSV Bulk Edit tool, you can create new family member accounts or update the following existing family member account information:

30

Families: Creating New Family Member Accounts

Admin CSV Bulk Edit Tool

Creating New Family Members

With the CSV Bulk Edit tool, you can create accounts for NEW Family Members without inviting families one-by-one.

​

To create new family members:

1. Navigate to your school dashboard
2. Tap the Families tab
3. Tap ‘Add or Edit Families in Bulk'
4. Tap ‘Add NEW families’

​

​

​

Admin CSV Bulk Edit Tool

​

32

Admin CSV Bulk Edit Tool

Creating New Family Members

• Tap ‘Download Microsoft Excel Template’ OR ‘Copy Google Sheets Template’ to navigate to the Family CSV Templates.
• Fill out your copy of the template with user information for students’ family members.
• For family members, you will need:
• Email Address AND/OR Mobile Number (at least one field is required).
• Connected Student IDs (Required; must be an email address or Student ID associated with an existing student at your school).
• Note: You can locate existing student information in the Student Download file.
• Note: Multiple students can be listed in the Connected Student IDs, each separated by a comma.
• Save file as a .csv
• For upload instructions, click here

33

Families: Updating Family Account Information

Admin CSV Bulk Edit Tool

Admin CSV Bulk Edit Tool

• Navigate to your school dashboard
• Tap the Families tab
• Tap ‘Add or Edit Families in Bulk'
• Tap ‘EDIT existing families’
• Tap ‘Download Current Family Data’
• Data for all families will download in a .csv file
• Open the downloaded .csv file and make a copy of the .csv file for edits
• For existing family member accounts, you may only ADD a mobile number or email address if no existing mobile number or email address is present
• NOTE: Family members may manage their existing email addresses or mobile numbers from their own Account Settings
• For existing family member accounts, you may ADD or REMOVE connected students in bulk by making changes to the Connected Student IDs column
• Do not delete Student IDs for users that should remain connected to the family member
• For upload instructions, click here

Updating Family Account Information

35

Uploading & Approving Your CSV Updates

Admin CSV Bulk Edit Tool

Admin CSV Bulk Edit Tool

• Save your updated file as a .csv
• Note: If you have not already copied your original .csv file, save a copy of your edited file by using the ‘save as’ feature. This will ensure that you have a copy of the unedited original document.
• To avoid errors, double-check you are uploading your .csv to the correct school tab (Classes, Teachers, Students, or Families).
• Tap ‘Add or Edit Classes/Teachers/Students/ Families in Bulk’
• Tap ‘Continue’ to move on to uploading your .csv
• Tap ‘Select CSV from Computer’ and select your saved .csv
• Tap ‘Upload and Preview’
• Preview the pending changes and check for any data warnings or errors
• Confirm your changes and tap ‘Make Updates’ in the bottom right to confirm updates.

​

​

​

​

​

How to Upload Your CSV Updates

37

Admin CSV Bulk Edit Tool

​

That’s it! You will receive an email when your update is complete.

​

If you need to upload additional Bulk Edit .csv files, you will need to refresh Seesaw in your browser to continue.

​

If you have additional questions, please check out our Help Center resources, or contact Seesaw Support for assistance. �

​

​

​

​

How to Upload Your CSV Updates

38

FAQs

Admin CSV Bulk Edit Tool

FAQs

How do I find the Org ID?

• You can find the Org ID of a school in the URL of the school dashboard beginning with org.

​

How do I find the Class ID?

• You can find the Class ID on your classes download in the ‘Seesaw Class ID’ column.

Can the Admin CSV Bulk Edit Tool be used to update administrator accounts?

• The CSV Bulk Edit tool can not be used to update administrator accounts. If you need to add or remove admin at your school, please follow the instructions here.

​

If we use Clever or ClassLink to roster our classes, can we still use these features?

• Yes, you can use this feature to update Clever and ClassLink classes, but we highly recommend that any enrollment changes are managed through your SIS and rostering partner.

​

Can we edit the Clever or ClassLink ID on user accounts or classes?

• No, at this time the CSV Bulk Edit tool cannot update Clever or ClassLink IDs. If an ID needs to be updated please contact Seesaw Support.

​

For more information, check out our Help Center!

Admin CSV Bulk Edit Tool

40

FAQs

Why isn’t my download file showing up?

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

​

Why does my updated CSV file show zero updates when I upload?

• 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 correctly (instructions).

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.

​

Tips for references classes, students, and teachers in your CSVs

• Downloads currently display unique Seesaw Identifiers to reference classes and users, followed by the name/user 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, Seesaw Identifier) in the upload. (Example: For the list of Students in the Classes CSV, you can use Student IDs to add students to the list.)

Admin CSV Bulk Edit Tool

41

Need more help?

​

Find more setup steps and resources here, or contact Seesaw Support to assist you with CSV uploads.