IMPORT – EXCEL Import (Ziber Format)
Easily perform a custom data import using the Ziber-format Excel file.
Excel (Custom Import)
Download the Excel definition file at the bottom of this page.
- The file must be saved in
.XLSXformat. - Each worksheet must have column headers in the first row.
- Do not change the names of the worksheets or the column headers.
- For supported languages, use the codes listed in: Available Languages.
⚠️ Note: The Excel import feature can only be used after coordination with Ziber.
Content Structure
The Excel file contains three worksheets:
1. groups worksheet
| Column Name | Description | Rules |
| id | Unique ID of the group | Required, must be unique within the worksheet |
| name | Name of the group | Required |
| subgroup | Name of the subgroup (e.g., grade level such as "1") | Optional |
2. students worksheet
| Column Name | Description | Rules |
| id | Unique ID of the student | Required, must be unique within the worksheet |
| first_name | First name of the student | Required |
| preposition | Student's initials or prefix | Optional |
| last_name | Last name of the student | Required |
| date_of_birth | Student's date of birth | Required, format: DD/MM/YYYY |
| group_ids | Groups the student is associated with | Optional, separated by commas or semicolons; must exist in groups worksheet |
| parent_1_id | Unique ID of parent 1 | Optional |
| parent_1_email | Email address of parent 1 | Required if parent_1_id is provided |
| parent_1_language | Language of parent 1 (used for invitation language) | Optional, default: NL. See Available Languages for codes |
| parent_2_id | Unique ID of parent 2 | Optional |
| parent_2_email | Email address of parent 2 | Required if parent_2_id is provided |
| parent_2_language | Language of parent 2 (used for invitation language) | Optional, default: NL. See Available Languages for codes |
3. teammembers worksheet
| Column Name | Description | Rules |
| id | Unique ID of the team member | Required, must be unique within the worksheet |
| first_name | First name of the team member | Required |
| preposition | Initials or prefix of the team member | Optional |
| last_name | Last name of the team member | Required |
| language | Language of the team member | Optional, default: NL |
| Email address of the team member | Required | |
| group_ids | Groups the team member is linked to | Optional, separated by semicolons; must exist in groups worksheet |
Importing the Excel File into Ziber Team
To import the file into Ziber Team:
- Go to the Dashboard.
- Navigate to Kwieb.
- Click the Import button.
- Upload your Excel file and schedule the import.
Download
[Download the Excel definition file here.]