Guidelines and Requirements for CSV Uploads




VocabularySpellingCity Account Administrators have access to a number of sample CSV files that are used as templates for providing teacher and student data in order to create accounts and grant access to their school/district Premium Membership. To ensure a successful upload, the following guidelines should be followed when completing the templates.

Sample CSV Files:
Download Sample Teacher CSV
Download Sample Student CSV
Download Sample School/District CSV*

*School/District CSV must be submitted to the VocabularySpellingCity Implementation Team for uploading via email at implementation@spellingcity.com.

Guidelines for Completing CSV Files

  • Download a sample CSV template.
  • Do not delete or modify column headings.
  • Remove sample data from the CSV file.
  • Complete the file with your teacher or student data.
    • Do not include spaces or special characters (such as hyphens, apostrophes, etc.) of any type.
    • Carefully follow the requirements outlined below for the file of your choice.
    • Usernames must be unique, but passwords can be the same for all students/teachers.
  • Be sure to save the file as a CSV.
  • Teacher CSV and Student CSV files may be uploaded through Manage Teachersor Manage Students, accessible from the Account Administration page. If you wish, you can email your completed files to info@spellingcity.com, and our Client Services team will upload them for you.
  • School/District CSV files MUST be emailed to implementation@spellingcity.com to be uploaded by VocabularySpellingCity’s Implementation Team.

Requirements for Completing CSV Files

To ensure your CSV will be uploaded successfully, please adhere to the following guidelines:

Sample Teacher CSV Read MoreRead Less

  • teacher_username: Required A unique username for the teacher. If the username is already in use, a number will be appended to the end.
  • teacher_email: Required The email associated with current VocabularySpellingCity members’ accounts or the email of new teachers (which will be used to create accounts).
  • teacher_first_name: Required
  • teacher_last_name: Required
  • password: Recommended. If no password is entered, one will be generated by our system.

Sample Student CSV Read MoreRead Less

  • student_uid:Required A unique identifier (such as Student Number or Student ID) for the student.
  • student_user_name: Required May be the same as student_uid. If the username is already taken, a number will be automatically appended and you will be notified of the change.
  • student_password: Recommended. If no password is entered, one will be generated by our system.
  • student_first_name: Recommended.
  • student_last_name: Recommended.
  • student_email_address: Required only for use of Google Single Sign-On.
  • student_parent_name: Not required.
  • student_parent_email: Not required.
  • student_grade_level:: Recommended. Please use numbers only (or K for Kindergarten).

Sample School/District CSV Read MoreRead Less

  • district_id: Required The name of the district.
  • school_id: Required The name of the school.
  • teacher_id: Required A unique id value for each teacher.
  • student_id: Required Any unique student id value from the client that does not change.
  • student_first_name: Recommended.
  • student_last_name: Recommended.
  • student_username: Required The desired username for the student. If not available, username will be changed by adding a number to the end.
  • student_password: Recommended. If no password is entered, one will be generated by our system.
  • student_email: Required only for use of Google Single Sign-On.
  • student_grade_level: Recommended. Please use numbers only (or K for Kindergarten).
  • teacher_first_name: Required only for teachers who are not currently VocabularySpellingCity members or to update the first name of a current member.
  • teacher_last_name: Required only for teachers who are not currently VocabularySpellingCity members or to update the last name of a current member.
  • teacher_username: Required only for teachers who are not currently VocabularySpellingCity members or to update the username of a current member.
  • teacher_password: Required only for teachers who are not currently VocabularySpellingCity members or to update the password of a current member.
  • teacher_email: Required The email associated with current VocabularySpellingCity members’ accounts or the email of new teachers (which will be used to create accounts).
  • license_holder_id: Required The username of the primary Account Administrator.