- Login to your WhosOff account
- Click on Administration on the Left Hand menu (you can also go via the + icon in the top right hand corner by selecting Add / Import staff)
- Then go to Admin Dashboard within the Administration section
- Click on Import Staff
- On the resulting page there are 3 steps to go through
Step 1 - Download Template - From here you can download the template import spreadsheet (in .XLSX format)
It is important not to change the format of this spreadsheet, or add / remove any columns.
- Staff Code - whilst you don't have to enter one, this could be used for their employee number as it shows up on Reports (Not Mandatory)
- Title - i.e. Mr/Mrs/Miss/Dr etc. (Not Mandatory)
- First Name
- Last Name
- Email Address - This becomes the user's Username, and any notifications sent out of the system will be emailed to this address
- Password - At least 8 characters long, can be generic as a Welcome Message can be sent out later
- Department - Must match any of the Departments already on your account
- Approver - The First and Last name of the user's approver
- User Type - Depicts the user's permissions on the system
- Allowance type - Either Days or Hours
- This Year - Opening - Enter the amount of leave entitlement the staff was entitled to at the beginning of this year
- This Year - Remaining - Enter the staff member's current amount of leave entitlement, if you are starting the year fresh on WhosOff, enter the same as the Opening Balance (This Year)
- Next Year - Opening - Enter the staff member's opening balance for Next Year
- Next Year - Remaining - Enter the staff member's remaining balance for Next Year
Step 3 - Upload your file - Once you've completed the bulk import spreadsheet, you can return to your WhosOff account and click on Choose File, this will allow you to select the specific spreadsheet you have worked on.
Once you've completed steps 1, through to 3, you can click on Prepare Upload. You will then see a preview of the information entered on the spreadsheet, along with indications as to whether required information as been entered i.e. their Department, Approver and Allowances.
This offers you the opportunity to go back and make any changes before you import your staff. Once you are ready you can click on Import Staff.
You will then see a breakdown of any successfully imported users, as well as if any weren't able to be imported. Hovering over the Green or Red indicators will provide further information as to why they were not imported.
PLATFORMS
Web / OnlineCATEGORIES
Bulk OptionsGetting Started
PHRASES
bulk, bulk import, bulk upload, upload, multiple, staff, add, add staff, add staff in bulkSHARE
Similar articles
Using the bulk book leave tool in WhosOff you can quickly enter leave requests for multiple departments, or the whole company.
Super users can quickly change the approver for multiple staff, or a whole department using the bulk options.
If you need to add allowances for all staff at once, or update their balance (for example to give everyone an extra day), then you can use the bulk balance administration page.
Sometimes companies need to make amendments to any company days that have been booked, or even bank holidays.
Super users can move multiple staff from one department to another using the bulk options.
Using an excel speadsheet you can add 1 or many staff to the system.
INSTANTLY REDUCE TIME SPENT ON LEAVE MANAGEMENT
Get your long FREE trial today!
No obligation and no payment setup required.Sign up today and get until Sunday, 26th January 2025 to try the full service, for Free!
