School administrators
How do I download the list of students, teachers or classes?
Written by the TestFLE team.
In short
Each of the “Students”, “Teachers” and “Classes” screens has a “Download CSV” button; “Teachers” also offers a teacher’s list of students as PDF or CSV. The headers and values of the three CSV files stay in English, whatever the language.
Who this is for, and what you need first
- Who this is for
- School administrators who want a list in a spreadsheet or on paper.
- What you need first
- The accounts or classes to export, already created in TestFLE.
- A spreadsheet program that opens CSV files.
The steps
- In the left-hand menu, open the screen you want: “Students”, “Teachers” or “Classes”.
- Prepare the list on screen: search (on “Students” only), sorting by a column, and the “Also show archived students” box (or its equivalents for teachers and classes) if you want to include archived items.
- At the top right, next to the add button, click “Download CSV”.
- Open the file in your spreadsheet program:
students.csv,teachers-admins.csvorclasses.csv.
The file contains exactly the rows displayed, in the current sort order. On “Students”, a search therefore makes a shorter file: clear it to export everything. Archived items are only included if the box that shows them is ticked.
A teacher’s list of students
On the “Teachers” screen, the “Student list” column has two buttons per row, “PDF” and “CSV”. They give the students of this teacher’s classes, grouped by class. The PDF is for printing; the CSV, for working in a spreadsheet.
- Open “Teachers”.
- On the teacher’s row, click “PDF” or “CSV” in the “Student list” column. Clicking these buttons does not open the teacher’s sheet.
- The browser downloads the file, named after the teacher.
Both buttons are greyed out when the teacher has no students. Their tooltip then says “No students in this teacher’s classes.” If the download fails, the row shows “The list could not be downloaded. Please try again.”
Going further
Understanding the exports
What do the three CSV files contain?
All fields are in quotation marks, separated by commas, and the first row gives the headers. No password appears in them.
students.csv. One row per student, with the columnsEmail,Name and username,Account status,School reference,Class,Age,Last level,Last test date,Previous level,Test accessandNon-reader.teachers-admins.csv. One row per teacher, administrators included, withTeacher,Classes count,Student countandAdmin.classes.csv. One row per class, withName,Student count,Average levelandTeacher. TheTeachercolumn lists the whole team, separated by commas.
A missing piece of data appears as a hyphen. A class without a teacher has the value No teacher assigned.
The headers and the values are never translated
The headers of these three files are in English, and so are the values: Active, Inactive, Pending first connection for the account status, Yes or No for Admin, yes or no for Non-reader, Locked, Unlocked: One-time, Unlocked: Unlimited or Unlocked via class: … for test access. The date of the last test is written YYYY-MM-DD, in universal time. Whether you use TestFLE in French, Spanish or Chinese, the file is identical: the school’s software has only one format to recognise.
A teacher’s list of students is the exception. Its PDF follows the language of your screen and dates its production in your local time. The columns of its CSV also follow the language of your screen.
The exports do not replace the import template
The headers of an export are not those of the import template. To create or update accounts from a file, start from the template on the “Imports” screen (creating accounts by import), not from an exported file.
Accented letters display badly in the spreadsheet
The files are encoded in UTF-8, without a byte order mark. Some spreadsheet programs then open them with another encoding, and accented letters become unreadable. In that case, import the file with the spreadsheet’s text import function and choose the UTF-8 encoding.
The PDF of a teacher’s list
The PDF and the CSV of a teacher’s list give the same rows as that teacher’s “My students” table in their own area, sorted by class then by name. The PDF has the teacher’s name as its title, the number of classes and students as its subtitle, and the date and time of production. One section per class gives, for each student, their name, their school reference, their email address, their age, their last level and their progress. Non-reader students and inactive accounts carry a label.
What cannot be exported from the school
The screen offers no export of the whole school, and no reset: contact the TestFLE team. Archived or deactivated accounts can be found in the lists (deactivating or archiving an account or a class).
Related articles
- How do I deactivate or archive a student, a teacher or a class?Deactivating a student closes tests to them while leaving them their results; archiving a student, a teacher or a class removes them from the lists without deleting anything. “Reactivate” and “Unarchive” take you back, but unarchiving does not restore the attachments.
- How do I create several accounts at once from a CSV file?The “Imports” menu creates the accounts of students, or of teachers and administrators, in one go from a CSV file: template, preview, corrections, confirmation. No password is created: everyone activates their account with “First connection”.
- How do I print a student’s report for their family?In “Students”, the printer icon in the “Actions” column produces the learning report for the family, or the detailed report “for me” or “to hand over”. The PDF is downloaded: the school hands it over itself, and the platform sends no email.
- How do I change the school’s default language?The “Default language” block, at the bottom of the home screen of the administrator area, sets the TestFLE language for anyone who has not chosen their own, from the sign-in screen onwards. The choice is saved at once, and “No setting” removes it.