Data Files

How do I create a tab delimited text file?

Depending on which spreadsheet software you are using, follow the steps below to save your file in the correct format.

Using Microsoft Excel

1. Open the File menu and select Save As...

2. In the file destination window, look for the Save as type dropdown box.

3. Select the Text (tab delimited) (*.txt) option.

4. Click Save.

5. If Excel displays warning messages about formatting or features being lost, click OK or Yes.

Using Google Sheets

1. Open the File menu in the top-left corner.

2. Hover over the Download option.

3. Select Tab-separated values (.tsv, current sheet).

4. The file will automatically download to your computer.

 

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

This is a common issue during the initial setup, but fortunately, it is very easy to fix without creating duplicate records. Since the system uses the Student ID (or unique identifier) to recognize users, it will simply overwrite the existing names with the corrected versions.

---

How to Fix Reversed Names

To correct the name order for your entire roster, follow these steps:

1. Correct Your Source File

• Open your original spreadsheet (Excel or Google Sheets).

• Swap the First Name and Last Name columns so they are in the correct positions.

• Ensure your Student IDs (or email addresses, depending on your account setup) remain unchanged.

2. Re-Import the File

• Navigate to the Import section in your Admin UI.

• Select your corrected file and proceed with the import process as you did previously.