---
title: How to bulk import employee payroll hours?
description: The bulk import hours feature allows you to edit the hours allocated to each pay code for every employee included in a pay run. To navigate to this option, click on the drop down menu on the pay run p
---

[Skip to content](https://knowledge.platoalpha.com/how-to-bulk-import#main-content)

English

Show submenu for translations

![PLATO-ALPHA-DARK.png\]](https://knowledge.platoalpha.com/hs-fs/hubfs/PLATO-ALPHA-DARK.png?height=40&name=PLATO-ALPHA-DARK.png)

- Home
- Products
- Pricing
- Blog
- Company

Open main navigation

Close main navigation

- Home
- Products
- Pricing
- Blog
- Company
- English
  
  Show submenu for translations
- Go to platoalpha.com

 Go to platoalpha.com

 Hello. How can we help you?

- There are no suggestions because the search field is empty.

1. [Help Center](https://knowledge.platoalpha.com/?hsLang=en)
2. [Triblock Admin](https://knowledge.platoalpha.com/triblock-admin?hsLang=en)
3. [Payroll](https://knowledge.platoalpha.com/triblock-admin?hsLang=en#payroll)

# How to bulk import employee payroll hours?

The bulk import hours feature allows you to edit the hours allocated to each pay code for every employee included in a pay run. To navigate to this option, click on the drop down menu on the pay run page.

**![](https://lh7-us.googleusercontent.com/TbqnqrJgITofPBRSofeIGEccI8lgijj7vpwynxlWDWg0LyHXQ_rpCsQHZu2tyrJ36YRMP3dUQLL9CzVErG-aSU4083xR_WSUKyINwEyWsGa65sPPdQkDng5u3bYgTs2f42-NnKeAQQlHHrrq3Wp9IWo)**

Next click on the 'Bulk Import Hours' button. It will take you to the page where you must now select the pay code and download the template. 

**![](https://lh7-us.googleusercontent.com/tlWJRgiWPCm5GAJ0gvqLAkx0x6_lmHttvBXt8gYX_EBzqj31UrUP3KkX7XcOwwsHFjNycnK4HUk2877xdol8EmbkPj_xbYVsHDcZrtwi2_S70eiavogvQmFQiwH89FyrCBBfgwNR4rmkUIHhbXxKoLA)**

The pay code is associated with the pay categories shown on the pay run and are what give the hours the rate (e.g. Holiday rate = 2x hourly wage). Once you select the pay code the template will be downloaded and from there you will need to input the hours for each employee. A photograph of the template is shown below:

**![](https://lh7-us.googleusercontent.com/FlvV6_ROx97FJSsAPDpO0LS713nPV3E3F0EmJSzjwK3eo3-jahUuzbeoE3VovoUSL8WBgjZ_WDu2nIMlscxvINthVwoMmQO7aOBR9QFi7IWwEY2fZiKxP3_AyS-KE8F5znzfKyGjCoFWws_iR34FplI)**

**The only column that needs to be filled in is the 'Amount' column. Input the hours for each employee that you wish to bulk update. For any employees that you wish to exclude, just leave their amount blank.**

Next, download the excel file, and upload the file by clicking on the 'Browse' button as shown below.

**![](https://lh7-us.googleusercontent.com/PbeOu3JpWql5C40URL2SK4B4gXF-nMWHoo__LhN3L3oftPxnKqJPUeABCo9ZieHPnsSJOxdt1Ak4sCbSrMF_b0WWW02Gv0Lz_jk7aoZSCdSW4Qg-v05iK-xvrkt7Prj9QDguE6z9uVh7ydPjAtpqcgI)**

When you click the import hours button, those hours will populate the pay run slots for whichever pay category the pay code that you would have selected is associated with.

 

 

 

- [TriblockHR ESS](https://knowledge.platoalpha.com/triblockhr-ess?hsLang=en#main-content)

    - [Getting Started](https://knowledge.platoalpha.com/triblockhr-ess?hsLang=en#getting-started)
    - [Documents](https://knowledge.platoalpha.com/triblockhr-ess?hsLang=en#documents)
    - [Payslips](https://knowledge.platoalpha.com/triblockhr-ess?hsLang=en#payslips)
    - [Rewards and Recognition](https://knowledge.platoalpha.com/triblockhr-ess?hsLang=en#rewards-and-recognition)
    - [Time & Attendance](https://knowledge.platoalpha.com/triblockhr-ess?hsLang=en#time-attendance)
    - [Reports](https://knowledge.platoalpha.com/triblockhr-ess?hsLang=en#reports)
    - [Miscellaneous](https://knowledge.platoalpha.com/triblockhr-ess?hsLang=en#miscellaneous)
    - [Recruitment](https://knowledge.platoalpha.com/triblockhr-ess?hsLang=en#recruitment)
- [Triblock Management](https://knowledge.platoalpha.com/triblock-management?hsLang=en#main-content)

    - [Time](https://knowledge.platoalpha.com/triblock-management?hsLang=en#time)
- [Triblock Admin](https://knowledge.platoalpha.com/triblock-admin?hsLang=en#main-content)

    - [Documents](https://knowledge.platoalpha.com/triblock-admin?hsLang=en#documents)
    - [Roles and Permissions](https://knowledge.platoalpha.com/triblock-admin?hsLang=en#roles-and-permissions)
    - [Employment Info](https://knowledge.platoalpha.com/triblock-admin?hsLang=en#employment-info)
    - [Payroll](https://knowledge.platoalpha.com/triblock-admin?hsLang=en#payroll)
    - [Performance](https://knowledge.platoalpha.com/triblock-admin?hsLang=en#performance)
    - [Recruitment](https://knowledge.platoalpha.com/triblock-admin?hsLang=en#recruitment)
    - [Settings](https://knowledge.platoalpha.com/triblock-admin?hsLang=en#settings)
    - [Shift Schedules](https://knowledge.platoalpha.com/triblock-admin?hsLang=en#shift-schedules)
    - [Time](https://knowledge.platoalpha.com/triblock-admin?hsLang=en#time)
    - [Reports](https://knowledge.platoalpha.com/triblock-admin?hsLang=en#reports)
    - [Learning](https://knowledge.platoalpha.com/triblock-admin?hsLang=en#learning)

- Home
- Products
- Pricing
- Blog
- Company

[![Chill listening crop-3](https://knowledge.platoalpha.com/hs-fs/hubfs/PLATO-ALPHA-DARK.png?width=93&height=24&name=PLATO-ALPHA-DARK.png "Chill listening crop-3")](https://knowledge.platoalpha.com/?hsLang=en)

platoalpha.com

<https://www.facebook.com/platoalphadesign> <https://twitter.com/plato_alpha> <https://www.instagram.com/plato_alpha> <https://www.linkedin.com/company/platoalpha> <https://www.youtube.com/@platoalpha7764>

Copyright © 2026, Plato Alpha Design