Add, update, deactivate or delete many users at once, and put them into groups, by importing one Excel or CSV file. Before anything changes, deskbird shows you a review of every new user, update, new group and deletion, and you choose what to apply. Users who aren't in your file are never changed.
- Before you start
- Prepare your file
- Upload and review your file
- Fix problems in your file
- Import groups and managed groups
- Users synced via SCIM or an HRIS
- FAQs
1. Before you start
- Role: only Global administrators can import users.
- File type: Excel (.xlsx) or CSV, up to 10 MB and 50,000 rows. CSV files can use a comma or a semicolon as the separator.
- Template: go to Admin > User management: Users, click Import users and then Download template. The template contains the column headers only.
- One import at a time: only one import can run per company. While you review your file, other admins can't start an import for 15 minutes.
💡 Tip: to update existing users, start from your current user list. Go to Admin > User management: Users and click Export CSV (see Exports). The export doesn't include groups or managed groups, so add those columns yourself if you need them.
2. Prepare your file
Each row is one user. The import reads these columns and ignores any other column:
| Column | When to fill it in | What to enter |
|---|---|---|
| Always | The user's email address. For existing users, enter it exactly as it is in deskbird: that is how the import finds the user. | |
| New email | Only to change an email address | The user's new email address. |
| First name, Last name | Required for new users | The user's name. |
| Role | Optional | Global administrator, Office administrator, Manager, Group manager or User. Empty for a new user: User. |
| Status | Optional |
active, inactive, provisioned or deleted (see below). Empty for a new user: provisioned. |
| Main office name | Optional | The name of an existing office, written as it is in deskbird. |
| Groups | Optional | The groups the user belongs to. See Import groups and managed groups. |
| Managed groups | Optional | The groups the user manages as Group manager. |
| License plates | Only if your company uses license plates for parking | The user's license plates, for example B ER 007; M UC 123. Learn more in License plate management. |
How cells are read:
- Empty cell: nothing changes for that field.
- A dash (-): clears the field.
- Several values: separate them with a semicolon (;).
- Groups, Managed groups and License plates are the complete list for that user. Values you leave out are removed, so a user's plates or groups that aren't in the cell are taken away.
Status values:
-
active: the account is active. -
inactive: the account is deactivated. Upcoming bookings and schedules are canceled, and assigned desks and spaces are unassigned. Past bookings stay in your data. -
provisioned: for new users only. The account exists and becomesactivewhen the user signs in for the first time. -
deleted: the user is deleted permanently, the same as deleting them in Admin > User management: Users. Upcoming bookings are canceled. This can't be undone.
⚠️ Important: you can't delete, deactivate, rename or change the role of your own account with an import.
3. Upload and review your file
- Go to Admin > User management: Users and click Import users.
- Drag your file into the upload area, or click browse to select it. deskbird checks the file. Large files can take a while: you can click Close drawer and come back later.
- If the file has problems, you see Issues found. See Fix problems in your file.
- If the file is valid, you see Review changes. The Summary tells you how many users and groups will be created, updated and deleted. Below it, the changes are grouped:
- New: New users and New groups.
- Updates: one entry per kind of change, for example Office change (old and new office) or Will become group member.
-
Delete users: users whose status is
deletedin your file. - Additional notes: values that won't be changed, and the number of users who aren't in your file or are already up to date.
- Untick any group of changes you don't want to apply.
- Click Import changes.
⚠️ Important: Delete users is unticked by default. Tick it only if you want to delete these users. Deleting can't be undone, and their upcoming bookings are canceled.
To use a different file instead, click Reupload. Uploading a new file discards the current review.
4. Fix problems in your file
deskbird imports nothing until every row in the file is valid. If a row has a problem, the Problems list shows each type of problem with the affected row numbers and values.
- Click Download problem file. You get a copy of your file with a Problems column that explains what to fix in each row.
- Correct the rows in your file.
- Click Upload again and select the corrected file.
Common problems:
- Invalid email: use a full email address, like name@company.com.
- Public email domain: addresses from public mail providers (such as @gmail.com or @yahoo.com) can't be imported. Use the user's company address, or invite the user manually instead.
- Unknown office: the main office name doesn't match any office. Write it exactly as it is in deskbird.
- Role: invalid value or Status: invalid value: use one of the values listed in Prepare your file, or leave the cell empty.
- Managed groups without group manager role: set the user's role to Group manager, or clear the Managed groups cell.
- Group name used twice: more than one group in deskbird has this name. Rename one of them so each name is unique.
5. Import groups and managed groups
The Groups and Managed groups columns use group names, not IDs:
- Names are matched regardless of upper or lower case and extra spaces.
- If no group has the name, the import creates a new group. New groups are created at the top level and have no office access yet. You can set up their access, hierarchy and members in Admin > User management: Groups. See Users and Groups.
- If two groups in deskbird have the same name, also as subgroups under different parents, the import stops until you rename one of them.
💡 Tip: a typo in a group name creates a new group. Check the New groups list in the review. If you untick it, deskbird doesn't create these groups and doesn't add anyone to them.
Groups sets the user's complete list of groups. Groups you list are added, and groups you leave out are removed. A dash (-) removes the user from all groups. Membership through a parent group isn't changed.
Managed groups works the same way for the groups a user manages. The user needs the Group manager role (in the Role column or already in deskbird). Managing a group doesn't make the user a member of it, and a manager of a parent group also covers its subgroups.
The import can't rename, nest or delete groups. Do this in Admin > User management: Groups.
6. Users synced via SCIM or an HRIS
If users or groups come from SCIM or an HRIS integration, your directory stays in charge of them:
- First name, Last name, Email and Status of synced users aren't changed. The review lists them under Additional notes: "This value comes from the user's sign-in or directory sync and will not be changed".
- Role, Main office name, License plates and groups created in deskbird can still be changed with the import.
- Groups synced from SCIM or an HRIS are never changed. Adding a user to a synced group, or removing them from one, is skipped. The rest of the row is still imported.
To change synced data, update it in your identity provider or HRIS. See SCIM Overview.
7. FAQs
Yes. The column names haven't changed, and the Groups and Managed groups columns are optional. One thing works differently now: a filled License plates cell is the complete list. Plates you leave out are removed, and their upcoming parking bookings are canceled. Leave the cell empty to keep the current plates.
No. The import only changes the users in your file. The review shows how many users aren't in the file or are already up to date.
Set their Status to deleted or inactive. To delete users, also tick Delete users in the review: it's unticked by default. Both cancel the users' upcoming bookings, and deleting can't be undone.
No. Imported users are created with the status provisioned (unless your file sets another status) and can sign in right away. Their status changes to active after their first sign-in.
The name in your file doesn't match any group in deskbird, often because of a typo. Untick New groups in the review to skip them, fix the names in your file, and upload it again.
Only one import can run per company. While another admin reviews a file, you can start your import after 15 minutes at the latest. While an import is being checked or applied, wait until it's finished.
No. Only Global administrators can import users. See System roles and permissions.