Submit a ticket My Tickets
Welcome
Login  Sign up

Appogee HR: CSV Upload Guide

Applicable plans Leave HR Essentials HR Success


Required Roles Team Manager HR Manager Administrator ADU Manager


A CSV file is a type of file which is used to store tabular data. To use this tool, it's best if you have a spreadsheet software such as Google Sheets or Microsoft Excel to fill out the template.



CSV Upload


To upload your users by CSV go to Add Employee > Import from CSV. 


Download the template of the CSV and input the data about your employees. The CSV tool will only import a maximum of 100 users at once. If you are looking to import more than 100 users you will have to do this in stages. The Template will map the data in each column with the fields in Appogee HR to create an employee's profile. The template has the following titles: 




Those marked with asterisks are mandatory.


Mandatory ColumnsOptional Columns
Employee Email AddressTeam Name
Employee First NameWork Profile
Employee Last NameStart Date

Job Title

Office Location 




NOTE: it's not possible to create Teams or Work Profiles using the CSV import tool, so these will need to be created before you initiate an upload. 


When you've filled out the CSV template, make sure to save a copy as .csv file, upload it using the Upload & Import button. The system will validate the CSV file and look for any discrepancies or errors. 




Once validated, the next page will give you a summary of the upload - how many users the tool has found on the CSV file, any users with validation errors and users you are able to import. The spreadsheet must be uploaded as a CSV file.



Errors which deem users are not importable are as follows: 

Missing Email Address

Missing First Name

Missing Last Name

Email Address is already taken by another user in the system

Email Address domain has not been verified


Fixable issues are as follows: 

Team missing 

Team does not exist/is not recognised

Work Profile missing

Work Profile does not exist/is not recognised

Job Title Missing 

Start Date Missing

Access Leave/HR/Goals is missing 

Access Leave/HR/Goals is not 'Y' or 'N'


Assign Team


The next step is to Assign Employees to their Team and Work Profile. If you input this information in the CSV template already, this page can just be used to check if it's all correct. Make changes by clicking the pencil icon.


Select Teams and Work Profiles using the dropdowns.



If you have a large number of people in one Team or Work Profile, you are able to use the buttons to assign them all at once. Select the users by ticking the boxes on the left and then click either Assign Team or Assign Work Profile.



A pop-up will appear where you can choose the Team or Work Profile from the dropdown and then click OK. 


When all users have been assigned a Team and Work Profile, click Next.


Profile


Optionally add employees' Job Titles and Start Dates. 


This can be completed later, however it is advised that correct start dates are added for employees as this will aid the leave calculations for them. 


If the employee has a start date which falls in the current Leave Year and you have the Pro-Rata formula enabled, you will see that their allowance changes to accommodate this. 



When you're happy with the changes on this page, click Next. 



Configure Login


Choose whether the employees have access to login straight away or activate their log in at a later date. You can also optionally send a Welcome Email, which will invite them to log in. If you choose not to enable login or send a Welcome Email, you can do this another time from Roles & Access. 




Once you're happy with the changes on this page, click Next. You will see a dialog asking you to confirm if you're happy to import your users. Once done your employees will then be added to the system. 



Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.