Home Features Tour Pricing
Blog Support Contact us
Call us today on +44 (0)1227 812932 Get your FREE Trial


View knowledge hub

Super Users can add from 1 to many staff using the 'Bulk Import' tool, this feature will save time entering your staff for your company to the system.

How to 'Bulk Import' tool staff to the system.

Sign in to WhosOff and click Administration

Administration page > in the Manage Staff Members section click Bulk Import Staff

Bulk Import New Staff page  there are 4 Steps

Step 1 - Download the staff template file from the link on the page

Step 2 - Complete the spreadsheet paying attention to the columns marked as below as 'required'. Save your template.

 Staff Code  E.g 001a NO  
 Title  Mr/Mrs/Dr etc. NO
 First Name  YES
 Last Name  YES
 Email Address Must be in a valid address format YES
 Password At least 4 characters, alpha numerics only YES
 Department The name of the department on WhosOff, if the entered department does not
 match, the staff member will be entered into the 'UNALLOCATED' department
 Approver The name of the staff members approver, FIRST NAME LAST NAME, e.g John Smith YES
 User Type  Select the user level to assign to the new staff member YES
 Allowance Type  Staff added via the Bulk Import tool, can only have an allowance type of DAYS YES
 This Year - Opening  The opening leave balance for this year, for this staff member YES
 This Year - Remaining  The remaining leave balance for this year, for this staff member YES
 Next Year - Opening  The opening leave balance for next year, for this staff member YES
 Next Year - Remaining  The remaining leave balance for next year, for this staff member


Step 3 - click the 'Browse' button and find the template on your PC / MAC. Click 'Prepare Upload' and your template will be uploaded to  WhosOff.

Step 4 - After the staff have been uploaded, the system will check for any issues i.e incorrect email format, duplicate emails. If you receive errors, you may either adjust your template locally and re-submit or continue to import staff (if do continue, any staff with errors will not be uploaded)

Import Staff - if you wish to send a welcome message to each new staff member check the 'Send welcome message' box. Then click the Import Staff button and all staff with that have passed the system tests will be imported onto your account. After the staff have been imported, a confirmation of how many staff will be displayed next to the 'Import Staff' button.

It is important not to change / add / remove any of the column headings or change the format of the spreadsheet, as the system will reject the upload.




bulk, multiple, import, staff, add

Similar articles

Booking a company day off

Using the bulk book leave tool in WhosOff you can quickly enter leave requests for multiple departments, or the whole company.

Add Staff - Bulk Import

Bulk importing staff is the easiest way to add multiple users at once.

Changing approvers in bulk

Super users can quickly change the approver for multiple staff, or a whole department using the bulk options.

How do I add allowances in bulk?

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.

How do I cancel a company day off?

Sometimes companies need to make amendments to any company days that have been booked, or even bank holidays.

Bulk change department

Super users can move multiple staff from one department to another using the bulk options.


Get your long FREE trial today!

No obligation and no payment setup required.
Sign up today and get until Monday, 26th August 2024 to try the full service, for Free!

Start Your Free Trial

Cookie settings for whosoff.com

We use cookies to improve our website experience, we also use cookies to help us undertand how our website is used, enhance site navigation and analyze site usage and advertising. For more information please refer to our Cookie Policy.

AdvertisingEnables storage related to advertising, for example, advertising campaign.
AnalyticsEnables storage related to analytics, for example, visit duration.
TargetingSets consent for sending user data to Google for online advertising purposes.
MarketingSets consent for personalized advertising.
Manage cookies