---
title: "Add shifts to your event rota from a spreadsheet | Ticket Fairy Guides"
description: "Drop the event rota spreadsheet your team already keeps, in CSV or Excel, and Fai works out which column has the day, the times, the department and the role. You check every row and fix any column before up to 500 shifts are added to your rota in one go."
canonical: "https://www.ticketfairy.com/guides/add-shifts-to-your-event-rota-from-a-spreadsheet"
---

1. [Ticket Fairy](https://www.ticketfairy.com/)
2. [Guides](https://www.ticketfairy.com/guides)
3. Add shifts to your event rota from a spreadsheet

Crew and volunteers

# Add shifts to your event rota from a spreadsheet

Fai, your AI teammate, can check sales, update your event or change a ticket when you ask.

You often plan your event's shifts in a spreadsheet long before the rota is set up. When you bring that spreadsheet in as it is, with Fai matching its columns, you don't type hundreds of shifts again, and every rota rule still applies to them.

Takes:  5 minutes

- [Open the import](#step-1)
- [Add the spreadsheet](#step-2)
- [Check what each column holds](#step-3)
- [Choose the date order](#step-4)
- [Fix the rows with a problem](#step-5)
- [Add the shifts](#step-6)

## Before you start

- You are an owner, admin or producer on the event. Only those roles can open the event's **Operations** page.
- Your spreadsheet has a heading row and one shift a row, with the day, the start and end times, and a department or role.

1. ## Open the import

   Open the event, select **Operations**, select **Shifts**, then select **Import from a spreadsheet**.

   **Note:** If an import is still being checked, the dialog offers **Carry on** to go back to it.

   ![The Add shifts from a spreadsheet dialog, with a place to drop a CSV or Excel file or paste the rows](https://www.ticketfairy.com/embeds/posters/marketing-event-small-items--import-shifts.png)    
   *Adding shifts from a spreadsheet.*
2. ## Add the spreadsheet

   Drop the file on **Drop the spreadsheet here, or choose it**, or paste the rows and select **Read the rows**.

   **Note:** A file can have up to 500 shifts and be up to 2 MB. We only read the first sheet of an Excel file.
3. ## Check what each column holds

   Under **What each column holds**, change any column Fai read wrongly.

   **Note:** Fai reads the headings and the first rows, and the rows update as you change a column. Choose **Leave out** for a column you do not need.

   ![Import of a bar rota spreadsheet, with what each column holds, the rows ready to add and a row with a problem](https://www.ticketfairy.com/embeds/posters/marketing-event-small-items--import-rows.png)    
   *The rows Fai read from the spreadsheet.*
4. ## Choose the date order

   Above the rows, choose whether the dates start with the day, the month or the year.

   **Note:** This matters for dates in numbers only, such as 03/10/2026.
5. ## Fix the rows with a problem

   Read the problem under each row, then fix it in your spreadsheet and add it again, or leave the row out.

   **Note:** We can't add a row without a day, a time, or a department or role. If the end time is before the start time, it's the next morning.
6. ## Add the shifts

   Select the button that shows how many rows are ready to add, such as Add 3 shifts.

   **Note:** We add the shifts to the rota ready for people, with every rota rule applied. Selecting Add again on the same import never adds them twice, but if you upload the same file again, they're added again.

## Or have it done for you

Fai reads rows you paste into the chat as a spreadsheet, shows you each shift and its problems, and adds the ready rows after you confirm. For an Excel file, use the dialog in Shifts.

### In your dashboard, with Fai

```
Add these shifts to the rota at <EVENT NAME>: <PASTED ROWS WITH A HEADING ROW>
```

## Questions you might have

**Does Fai read my whole spreadsheet?**

 Fai reads the headings and the first five rows to match the columns. If Fai isn't available, we match the columns by their headings, and you can change any of them.

**Can I stop halfway through?**

 Yes. Close the dialog and the import waits for you. Select **Carry on** next time, or **Close without adding** to drop it.

**What if two of us add the same import?**

 We only add the shifts once. The second person sees "These shifts were already added."

**Are formulas in my spreadsheet worked out?**

 No. We read the values saved in the cells. Save the file with its values if a column is worked out by a formula.

**Can a row be a night shift?**

 Yes. A shift whose end time is earlier than its start ends the next morning, up to 24 hours long.

## Still have a question?

Book a demo and we will answer it on a call, on your kind of event. Or create your account and see it for yourself.

   [Book a demo](https://www.ticketfairy.com/event-ticketing/book-a-demo) [Create a free account](https://manage.ticketfairy.com/welcome)

No setup fees. No monthly fee. No credit card required.

## Related guides

- [More ways to use Ticket Fairy](https://www.ticketfairy.com/features)
- [Build your event rota and check staff in](https://www.ticketfairy.com/guides/build-your-event-rota-and-check-staff-in)
- [Offer open shifts on your event rota to crew and volunteers](https://www.ticketfairy.com/guides/offer-open-shifts-to-your-crew-and-volunteers)
- [Approve the hours your event crew and volunteers worked](https://www.ticketfairy.com/guides/approve-the-hours-your-crew-and-volunteers-worked)
- [Recruit volunteers for your event](https://www.ticketfairy.com/guides/recruit-volunteers-for-your-event)
- [Give your event volunteers their own page and track their hours](https://www.ticketfairy.com/guides/give-volunteers-their-own-page-and-track-hours)
- [Give crew meals at your event meal desk](https://www.ticketfairy.com/guides/give-crew-meals-at-your-meal-desk)
- [Every Ticket Fairy guide](https://www.ticketfairy.com/guides)

## Do this on your own event

Create your account, build your event and follow the steps in your own dashboard. You do not need to book a sales call.

  [Create a free account](https://manage.ticketfairy.com/welcome) [Book a demo](https://www.ticketfairy.com/event-ticketing/book-a-demo)

## Sell tickets with Ticket Fairy

Start free with unlimited events and no monthly fee, and choose a paid plan when you need more.

- Set up your event in minutes
- Free events are free
- Fai, your AI teammate, is built in

 [Create a free account](https://manage.ticketfairy.com/welcome)

No setup fees. No monthly fee. No credit card required.

## See it on a call

Book a demo and we will show you how Ticket Fairy handles your kind of event.

 [Book a demo](https://www.ticketfairy.com/event-ticketing/book-a-demo) [More ways to use Ticket Fairy](https://www.ticketfairy.com/features)

### Tips for selling more tickets

Practical advice from working event organizers, and every new guide as it is published.

We respect your privacy. Unsubscribe anytime.

---

This page is on Ticket Fairy, a ticketing, marketing and operations platform for live events and the venues that host them: festivals, club nights, concerts, conferences and tours, and night clubs, beach clubs and concert venues. It grows revenue with fan rewards that turn an audience into a sales channel, and runs the money side with payments and payouts, Vault business banking, and working capital advanced against ticket sales. [How Ticket Fairy ticketing works](https://www.ticketfairy.com/event-ticketing) · [Ticket Fairy for AI assistants](https://www.ticketfairy.com/llms.txt)
