Data

Import and export

You can import students from a table instead of typing them one by one — and you can download your grades at any time as CSV, Excel, or PDF. This article shows each format with a sample and the usual pitfalls.

Import students (CSV)

When you create a new class, you do not want to type 28 names one by one. ClassCheck accepts a simple CSV list — that takes about 30 seconds.

Step by step

  1. Open the class (the student list).
  2. Click “Import CSV” (in the menu, or in the entry area at the end of the list).
  3. Paste the list in the dialog — one line per student.
  4. Click “Import”. The students appear in the list at once.

Accepted formats

ClassCheck recognizes two columns:

FormatExampleResult
First name only Maria First name: Maria, last name: empty
First name, last name Maria,Müller First name: Maria, last name: Müller
Last name, first name Müller, Maria Detected on import; you can switch the order in the dialog.
Sample CSV (copy it and paste it into the dialog): 
Anna,Berger
Ben,Hofer
Clara,Müller
David,Schneider
Emma,Wagner

Limits

  • At most 500 lines per import (enough for any class).
  • At most 1 MB for the CSV file.
  • Separator: comma. If your file uses semicolons (common in spreadsheet apps set to a European locale), find-and-replace first, or save as “CSV (comma)”.
  • For E2EE classes, names are encrypted in the browser before they are sent to the server.

Tips from Excel or LibreOffice

  • Select a column of first names and a column of last names, press Ctrl+C, and paste into ClassCheck — that works directly, because Excel copies tab-separated text. ClassCheck turns tabs into commas.
  • For multi-part last names (for example “von Müller”), use quotes if needed: "von Müller",Maria.

Import grades from ClassTests

If you use ClassTests (our companion product for online exams), ClassCheck fetches the released exam results for you — you start the import here in ClassCheck (you no longer need to export from ClassTests).

  1. Connect once: create a token in ClassTests and paste it in ClassCheck under Settings → “Connect ClassTests”.
  2. Open the subject → “ClassTests import” (or, in ClassTests after grading, “Import into ClassCheck”).
  3. Choose the exam and the target subject, check the name matching, and click “Import”.

Full guide: Import from ClassTests.

Export: CSV

CSV is the most portable format. It opens in Excel, Numbers, LibreOffice, and Google Sheets, and it can be imported into school administration software.

  1. Open a subject (the grade table).
  2. Click “Export ▾” in the toolbar.
  3. Choose “CSV export”.
  4. The file downloads at once — file name: [Class]_[Subject]_[Date].csv.

What is included: student names, every column with its date and grading system, the values entered, and the average per student.

Export: Excel

If you want the formatting done for you (column widths, a bold header row, color codes), use Excel.

  1. Click “Export ▾” → “Excel export”.
  2. The .xlsx file downloads.

Details:

  • Color codes for grades (green/yellow/orange/red for points and percent) are kept.
  • For E2EE classes the file is built in the browser — the ClassCheck server sees no data.
  • Column widths are set to fit.

Export: PDF

PDF is what you want for meetings, parent evenings, and grade conferences — or simply to print.

  1. Click “Export ▾” → “PDF export”.
  2. A preview opens where you can set options:
    • Show date: the print date at the top right
    • Orientation: portrait or landscape (landscape is better with many columns)
    • Show class comparison: optionally a row with the class average per column
  3. Click “Download”.
Tip for grade conferences: Make two PDFs — one with every column (to leaf through) and one with only the class tests (shorter for the conference folder). You choose that by temporarily hiding columns.

Grade reports for parents

If you want to give parents a written grade notice, there is a separate PDF with a school-data header and a signature line:

  1. Open a subject.
  2. Click the three-dot menu next to the student.
  3. Choose “Grade information”.
  4. The PDF opens in a new tab — ready to print.

A sample PDF is in the documentation.

Full GDPR data export

You can always ask for a copy of all data ClassCheck has stored for your account — that is GDPR Art. 15 (right of access).

  1. Open Account → Privacy and data export.
  2. Click “Download all my data”.
  3. You receive a JSON file with 16 data categories (account, classes, students, grades, notes, activity log, settings, license, and so on).

Common problems

“Excel shows only one column”

When you open the CSV in Excel: Data → From text/CSV, and choose comma as the separator. Double-clicking the file often uses a semicolon and packs everything into one column.

“Accented letters look wrong”

ClassCheck exports UTF-8. If Excel shows ä, ö, or ü incorrectly, open the file via Data → From text/CSV and choose character set UTF-8.

“The PDF is too wide”

Switch to landscape in the PDF preview. With a great many columns, an export per semester is also worth it (filter in the column menu).

Read next

← All guides