Create a File Using the Comma Separated Values (.CSV) Format (Teacher)
Creating a .CSV (comma-separated values) file is a simple and effective way to organize and import student data into Typing.com. A .CSV file stores tabular data in plain text, making it easy to manage large lists of students. Follow these steps to create a .CSV file and get your students ready to start typing!
Pro-Tips:
- You must use a file in the .CSV format when you’re importing a list of students to one of your classes.
- An email address is not mandatory for each student, but the email field header must be included in the .CSV file.
- If creating a list from scratch, you can assign the same password to all students. When importing the .CSV file, you can choose if you want students to set their own names and passwords upon their first login. The options will appear in the "Force Account Update" section (shown in the image below).
Steps to Create a .CSV File
Step 1: If you already have a list of students, jump ahead to Step 3. If you don’t have a list, make a copy of the spreadsheet template HERE.
To make a copy:
- Go to File
- Click "Make a Copy"
Step 2: Once you created your own copy, ensure the titles of the columns in your spreadsheet match the following: (These fields are case sensitive)
- Student_Username
- Password
- First_Name
- Last_Name
Step 3: Fill in the spreadsheet with your student’s information if you haven’t already.
IMPORTANT:
- The Student_Username and Email fields must be unique and cannot have duplicate entries in our database.
- The Password can include letters, numbers, and symbols (e.g., “awesome123$”). This password can be the same for all students and can be changed later upon their first login if selected. (Note: Students can change it later upon their first log in, if you have selected this option.)
- Delete any empty rows at the bottom of the list. To do this, scroll to the bottom, select the first empty row, then use shift + command + ↓ for Mac or shift + ctrl + ↓ for PC to select all empty rows, right-click, and choose “Delete Rows ## - ##”.
- Ensure there is no white space below your last student.
Step 4: Once the spreadsheet is filled in, download it as a Comma Separated Values (.CSV) file.
- Go to File
- Select "Download As"
- Click "Comma Separated Values (.csv)"
That's it! You’ve created and downloaded a Comma Separated Values (.CSV) file. Your students are now ready to be imported into Typing.com.