Skip to main content

Data Files

How do I create a tab-delimited text file? 

If you're using Microsoft Excel:

    1. Open the File menu and select the Save as... command.
    2. In the Save as type drop-down box, select the Text (tab-delimited) (*.txt) option.
    3. Select the Save button. If you see warning messages pop up, select the OK or Yes button.

If you're using Google Sheets:

1. Open the File menu in the top left corner of the spreadsheet.
2. Hover over the "Download" option in the dropdown menu.
3. Select "Tab-separated values (.tsv, current sheet)" from the side menu. This downloads the currently selected sheet as a .tsv file.

The birth dates for my students were imported incorrectly. 

Correct your student file and import the file again. The system will look for a matching student ID and then update the security value (birth date) field. 

My teacher (student) names were reversed when I imported them. I had the Last Name in the First Name column and vice versa. 

Correct your student file and import the file again. The system will look for a matching student ID and then update the First Name and the Last Name field.