Skip to content

Can I Update Annual Holiday Allowances for my Staff in Bulk?

If you have multiple employees whose holiday allowances are changing (perhaps you increase their holiday based on length of service, for example), you can do so in bulk using the Staff Import function. 

To do this, click on the task bar (+) icon in the top right corner of your screen and select add staff. Then, select import. 

From here, click export your current staff under step 1. A spreadsheet will be downloaded containing the data for all active employees. 

Open the spreadsheet and delete all fields apart from:
  • Email Address
  • Title
  • First Name
  • Last Name
  • Holiday Allowance
Enter the new holiday allowances for each employee. If any allowances are to remain the same, you can just leave these as they are. Once done, save and close the spreadsheet. 

Go back to your Staff Squared window and upload the spreadsheet under step 4 on the same page. Then hit preview import followed by import staff on the next page. Once the import is complete, scroll to the bottom of the page and hit return to staff list. You can then use the Holiday Overview report to confirm that all allowances are correct. 

Feedback and Knowledge Base