When should I import departments via Excel?
If you need to create or update multiple departments, we recommend using Woba’s Excel template instead of managing each department manually.
Departments should be created before employees and administrators, so employees can subsequently be linked to the correct departments.
The recommended order is:
Departments → Employees → Administrators
💡 Tip: If you only need to create individual departments, it may be easier to use Add Department directly in Woba Suite.
Download the Excel template
Log in to Woba Suite
Go to Organization and Employees
Select Organization
Go to Departments
Click Import Departments
Click Download Woba template
You can now fill in the Excel template with your department structure.
⚠️ Important: Do not delete columns or change the column headers in the original Excel template. Doing so may cause the import to fail.
Fill in the department template
The Excel template contains the following fields:
Department ID*
Department ID*
Enter a unique ID for the department.
The Department ID is used to identify the department in Woba and to connect the department with, among other things, subdepartments and employees.
This field is mandatory.
Name*
Name*
Enter the name of the department, for example Sales, Customer Service, or Finance.
This is the name that will be displayed for the department in Woba.
This field is mandatory.
Active (Yes/No)
Active (Yes/No)
Specifies whether the department should be active or inactive.
Yes = active
No = inactive
An inactive department can be activated again later.
Parent Department ID
Parent Department ID
Used to build the hierarchy of your organization.
Enter the Department ID of the department that should be the parent of the relevant department.
Example:
If Sales Denmark should be placed under Sales, enter the Department ID for Sales as the Parent Department ID for Sales Denmark.
If the department should not have a parent department, the field can be left blank.
Department Manager ID
Department Manager ID
Used to assign a department manager.
Enter the manager’s Employee ID.
The employee must exist in Woba before they can be assigned as a department manager.
Location
Location
Specify the location of the department.
For example:
CPHAarhusLondon
Language
Language
Specifies the department’s default language.
Use the relevant language code, for example:
dafor Danishenfor Englishnofor Norwegian
Average Yearly Salary
Average Yearly Salary
Enter the average annual salary for the department.
The information can be used in Woba’s calculations of financial impact.
Enter the amount as a number, for example: 20000
Benchmark ID
Benchmark ID
Used to specify the department’s benchmark group.
Enter the relevant Benchmark ID if the department should be linked to a specific benchmark group.
Upload the Excel file
Once the template has been completed:
Go back to Organization → Departments
Click Import Departments
Drag the Excel file into the upload field, or click Upload from device
Select the completed Excel file
Click Upload
Woba will then process the information in the Excel file and create or update the departments.
If there are errors in the file, these must be corrected before the import can be completed.
Check the departments after importing
Once the import has been completed, we recommend checking the department overview.
Check, among other things:
That all departments have been created
That the department names are correct
That active and inactive departments have the correct status
That parent and subdepartments are placed correctly
That any department managers are assigned correctly
That language and other information are correct
You can also use Your Organizational Chart to visually check that the department structure has been set up correctly.
Export existing departments
If you already have departments created in Woba, you can select Export Departments from the department overview.
This can be useful if you need to review or make larger changes to your existing organizational structure.
💡 Tip: For larger changes, it may be easier to start with an export of your existing departments rather than building the structure from scratch.
What is the next step?
Once your department structure is in place, you can continue by importing employees and linking them to the relevant departments.