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 Teachers or Manage Students. 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

  • username: Required If the username is already taken, a number will be automatically appended and you will be notified of the change.
  • password: Recommended. If no password is entered, one will be generated by our system.
  • first_name: Recommended.
  • last_name: Recommended.
  • grade_level: Recommended.
  • email: Required only for use of Google Single Sign-On.

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.