---
title: "How to populate the Employee Upload Template"
description: "Populating employee upload"
url: https://helpdesk.aanyahr.com/en/articles/68-how-to-populate-the-employee-upload-template
collection: "HRIS (Data Upload)"
updated: 2024-06-14
language: en
---

# How to populate the Employee Upload Template

Populating employee upload

## Populating Employee Upload Template.

1.  Open the Employee Upload Template using excel or any other spreadsheet type application.
    
    Sample Application that can be used  
    \- Google Sheets  
    \- **Microsoft Excel _(Recommended Application)_**  
    \- LibreOffice
    
    ![](https://staticfiles.gleap.io/ghelparticle/bktRrxmIzTPdZN3vkob55sdJyjk9xTRmVJcBtimXjXwL5QcaMEPSWELMmd3m9g7JN4ETlxPdo4T.png)
    
      
    Sample Template Opened using excel.
    
    ![](https://staticfiles.gleap.io/ghelparticle/nu1DbxxOFXXG8ImgZfLfwmnpzV4WagsgdJiz2RsQEWeCNsqYmHjMkSqHwx6tK2VpRYUKBVEOEJx.png)
2.  Once done opening the Employee upload template, check for the list of required columns to be populated.  
      
    **_Note:_** _Required to input field for Column Header with_ **_Req\*_** _on its name._  
    _Follow the format shown based on the column header format particularly birth date format._
    
    ![](https://staticfiles.gleap.io/ghelparticle/5P2yIEAAsqZZVdGjP42qzc9SYMXUvo3yccXg5ioiXIZSwvIJxbNrezvgVg5m6M9LwW58JiRRiTU.png)
    
    **Suggestion:** If possible, to input all the data within the template needed for us to maximize the use of template.
    
3.  Upon populating the template be mindful of the LEGENDS sheet. Which will be used to input on our template.
    
    **Ex.**
    
    ![](https://staticfiles.gleap.io/ghelparticle/Mw9Z7uV7LhXfHdATncKfeZCoINhL9Gg2X9QXZzBldDNg8izcxSd6MgD4lnLaQEG0mXr7RTfLh77.png)
    
    SAMPLE TEMPLATE with Data
    
    ![](https://staticfiles.gleap.io/ghelparticle/Mp7S5Gey91JXYLnvlwVkCeEhZ0a5Ql34Yvnatk5sXyHhgYvkm4b3AtjlYxa0E2w1oFZu4gQa8J1.png)![](https://staticfiles.gleap.io/ghelparticle/2sdakwPQzGJS2JKYNRppIc2HvvAXnsW4NcwQDioZtQHZFr57HZYrh8yLkqEvqH7ZlPLoELLzGvW.png)
    
    **Note:** Columns not included to the LEGENDS sheet will be inputted with actual data.  
      
    Ex.
    
    ![](https://staticfiles.gleap.io/ghelparticle/eqb8xrmvzGDp52QbTSmzdrDZwX8QVGbqGkDI0Wrll0cYKP4iuLhiz4Mc2owCobBAd9gjzpK3Nts.png)
    
4.  After populating the template, Double check the data encoded to the template.  
      
    Ex. Employee Upload with DATA
    
    ![](https://staticfiles.gleap.io/ghelparticle/lWZxIN17euw782av7mvn07qfmPpYcnvb6BE7Fj7yKmOC0DCuyYszpTV9gaqBIp53leFEVlbEfxQ.png)
    
    **Note:** Image shown above is compressed column headers of template.
    
5.  Before saving the file make sure to delete the Sheet 2 or Employee (2).  
      
    
    ![](https://staticfiles.gleap.io/ghelparticle/lblVc0WyhgEOKWe9Y6ieCyoAKfogFT1kG5UccF2SCieB3oDYJQm52UDeFwxCqy05FQFw5bhD41Y.png)
    
    Note: If we forgot to delete the Employee (2)/Sheet 2 system will always reflect _Upload Transaction Failed_.
    
6.  Proceed on uploading the template.