Skip to main content

Data Files

How do I create a tab-delimited text file? 

If you're usingUsing Microsoft Excel:

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

    If you're usingUsing Google Sheets:

    1.

    1. Open the File menu in the top top-left cornercorner.
    of the spreadsheet.
    2. Hover over theDownload. "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. How do I fix this?

    Correct your student file and import the fileit again. The system willmatches lookby for a matching studentStudent ID and then updateupdates the securitySecurity valueValue (birth date) field.field accordingly.

    My teacher (student)teacher/student names were reversed whenduring Iimport imported(First them.Name I had theand Last Name in the First Name column and vice versa. swapped).

    Correct your student file and import the fileit again. The system willmatches lookby for a matching studentStudent ID (or Teacher ID) and then updateupdates the First Name and the Last Name field.fields accordingly.