Import master data from Excel

Bring subjects, teachers, rooms, or classes in from an Excel table instead of entering them one by one.

Before you begin

You need an .xlsx file with Alias in column A, Name in column B, and no header row. Keep the source file and test with a few checked rows first.

Import starts as soon as you select or drop the file, with no preview or further confirmation. If an alias already exists, its name is replaced by the value in column B.

Open full-size image

Open the menu beside Create and select Import; you can also drag a file onto the table.

Download templates

Each file contains two fictional records, no header row, and only the two required text columns.

Contents	Download	Open in Stundenwerk
Subjects	Subject template (.xlsx)	Subjects
Teachers	Teacher template (.xlsx)	Teachers
Rooms	Room template (.xlsx)	Rooms
Classes	Class template (.xlsx)	Timetables → Overview

Try the sample data in an empty test project or replace it with your own data before importing. Do not import sample files into a working school project without reviewing them.

Structure the file

Use the first worksheet. The following table shows three examples, not the contents of the downloads. Its column headings are for explanation only; do not add them to the XLSX file.

Column A: Alias	Column B: Name
MAT	Mathematics
GER	German
ENG	English

• Column A: an alias using A–Z, a–z, 0–9, and -, unique within the file.
• Column B: a name; both values are required for each record.
• Additional columns: ignored. Target lessons, subject colors, lessons, and placements are not imported.

Fully blank rows are skipped. If column A or B contains a value, both must be filled in. Spaces at the beginning and end are removed. The file must contain at least one complete data row. Incomplete rows, invalid aliases, and duplicate aliases prevent the entire file from being imported.

Import the file

1. Open the destination

   Depending on the content, open Subjects, Teachers, Rooms, or Overview under Timetables. The open page determines what type of entries are created.

2. Start the import

   Open the menu beside Create and select Import. Choose an .xlsx file. Alternatively, drag it onto the table in any of the four destination areas. Import one file at a time and check the result before continuing.

3. Wait for processing

   Wait for Import completed before checking the entries.

4. Check the result

   Search for several imported aliases and compare their names with your table.

Note

If an alias already exists in the destination, the import updates only its name. Target lessons and subject colors are preserved. It does not create a second entry with the same alias.

If a teacher alias is already used for a room, or vice versa, the entire file is rejected without importing any rows. Choose another alias; importing cannot turn a teacher into a room or vice versa.

Result

After Import completed, check a few new and existing aliases. Their names should match the values in column B.

If it does not work

• For Invalid file, check that the file is actually saved in .xlsx format.
• Read the specific reason under Import failed; it identifies the affected alias where possible.
• For an empty workbook, check the first worksheet. Fully blank rows are allowed; if only the alias or name is missing, complete the row.
• Compare the file with the rules under Structure the file, especially for header rows and duplicate or invalid aliases.
• For a resource-type conflict, search for the alias under both Teachers and Rooms, then choose another alias.
• Try importing only the first data row to isolate the invalid row.

Next step

• Review and edit master data
• Prepare timetables and lessons
• Fix import problems