---
title: Upload approved holiday bookings from a spreadsheet
description: "Follow this guide to upload holidays from a spreadsheet ## Add Holiday Data-feed **Setup**> **Report Definitions** > **Add...** ![](https://paiyroll.com/wp-content/uploads/2024/04/image-64-1024x485.png) On the **Create Report definition** view: - Select the **Company** - Select the **Template**: **Upload holiday bookings from CSV** - Clear…"
url: "https://paiyroll.com/kb/uploading-holidays-from-a-spreadsheet/"
updated: "2025-06-16"
category: Holiday pay
---

# Upload approved holiday bookings from a spreadsheet

Follow this guide to upload holidays from a spreadsheet

## Add Holiday Data-feed

**Setup**> **Report Definitions** > **Add...**

![](https://paiyroll.com/wp-content/uploads/2024/04/image-64-1024x485.png)

On the **Create Report definition** view:

- Select the **Company**
- Select the **Template**: **Upload holiday bookings from CSV**
- Clear **Dry-run**
- Select a **Test worker** with the Holiday pay Item
- Click **Add**

![](https://paiyroll.com/wp-content/uploads/2024/04/image-29-978x1024.png)

## Prepare the spreadsheet

The file will need to include one row for each holiday booking. Here is an example:

![](https://paiyroll.com/wp-content/uploads/2024/04/image-28.png)

Please note: if you are using Excel format, the works_id column needs to be formatted as text in Excel: Data > Text to Columns > Text

## Upload the file

Go to My data-feeds and click **Upload**

![](https://paiyroll.com/wp-content/uploads/2024/04/image-25-1024x349.png)

Choose the file and click **Start**

![](https://paiyroll.com/wp-content/uploads/2024/04/image-26.png)

## Check the Payslip

Go to the Pay Item Editor, select the employee and click **Update** to check the live payslip:

![](https://paiyroll.com/wp-content/uploads/2024/04/image-31.png)

## View Bookings

If you need to view the bookings, go to **My Processes**and Select **Book Holiday**and the **Year**:

![](https://paiyroll.com/wp-content/uploads/2024/04/image-27-1024x455.png)

If needed you can also delete the booking, for example, if you made an error
