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

# How to populate the Employee Information Template

Populating Employee Information Template

## Populating Employee Information Upload Template.

1.  Open the Employee Information 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/p3oeqSwB5otov2571lVapFOMuUKERtpkzPmVzOQR9JRIScte7YydH53ty5X1uEQMJg9goYlewW4.png)
    
    Sample Template Opened using excel.
    
    ![](https://staticfiles.gleap.io/ghelparticle/CSx5Zh0f5BMF7s1hlAz00sED1CNp59z3noMaD3RTZDe18ikaiZXmc3PJkmgICtsmTR2eLdtPtK6.png)
2.  Once done opening the Employee information 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/xEenbjOuchyr5mVuJzCFf0oRJzSgcKXlM04NGUNhdQjXWTTKqMKg13j28YOiJ2B6jNBha9fwUdD.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.  
    
    ![](https://staticfiles.gleap.io/ghelparticle/llGiPQfRZZh04LIaA3GTKS423GD6PqboEohk7du6bgi2MKUzjrPb9FZb9yErPI6LmhaSZq3YPwC.png)
    
    SAMPLE TEMPLATE with Data
    
    ![](https://staticfiles.gleap.io/ghelparticle/mPRft5oCzKD19s0gss9i6lmgCLZajDUL6SAs6KnhKpK5hEpVp6td98WzFCVkZ7Re0OBVunjNb6O.png)![](https://staticfiles.gleap.io/ghelparticle/XaIxMyKlpyAoZbXzqJj3y4R3KtZ4HC03RWQaEZwaqjeJLMegaoJgLkdMgiAAtF9E1zovsTswq6t.png)
    
    **Note:** Columns not included to the LEGENDS sheet will be inputted with actual data.
    
    ![](https://staticfiles.gleap.io/ghelparticle/tfmf3Bc10bs8jgDrvuBNVoDwU1Qdlqx7b24aY4KqnXpTRVnr1Vz2dzwybjH8NIOtINZuEFcdwAG.png)
4.  After populating the template, Double check the data encoded to the template.  
      
    Ex. Employee Information Upload with DATA
    
    ![](https://staticfiles.gleap.io/ghelparticle/6bS1zOsRuFz85DvEhLm9H1XyGGm3bziTHpjc43PNPh1f4tH1HYcXAahdtlDWS8k212umeu7dguz.png)![](https://staticfiles.gleap.io/ghelparticle/AsREtp51TPA1WPNB9xlZwjR7OrAEfCne09TY4hmHxQu0xNLJ6qiXtbtChjswCGsHvJN8SCPRHY9.png)![](https://staticfiles.gleap.io/ghelparticle/X4KTVvxUGvexGs2yN0qz7LKOyz9QYOTaNN05rXHNJdAuBWpruWQUZyDJLS4sAAx9uOKbAskSXY6.png)![](https://staticfiles.gleap.io/ghelparticle/xjMxwHjs2mnfkEM2DUWKu4kPpe02oxrQqaUFcF3Pn6UGzA1uHpWZ0nrIiB3FNB5mgqgXL4XNz7l.png)![](https://staticfiles.gleap.io/ghelparticle/I3383j8uDulZiUL3FGNZWGKR987MkY5OqkHslCCOoiVe85hndY4pWlnvejOnv5obv3Y59Xkm37V.png)![](https://staticfiles.gleap.io/ghelparticle/gXNfusHQ1vAKZidOdQE2wwGDSVUHupyh6nEPLYEhsYzXljvEyDM59HVT5XG9BouwiAmKectjjxt.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/0BrOVFsbw8nlixg0GADkg1FksWNQl974C2Rb498gjVcy7T5vZMQNfrpkw9HN3G1bJKtABgPXwVn.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.