---
title: "Add shifts to your event rota from a spreadsheet | Panduan Ticket Fairy"
description: "Drop the event rota spreadsheet your team already keeps, in CSV or Excel, and Fai reads which column holds 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/id/guides/add-shifts-to-your-event-rota-from-a-spreadsheet"
---

# Add shifts to your event rota from a spreadsheet | Panduan Ticket Fairy

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

Menjalankan produksi

# Add shifts to your event rota from a spreadsheet

Crew managers and suppliers often plan a festival's shifts in a spreadsheet long before the rota is set up. Bringing that spreadsheet in as it is, with Fai matching its columns, saves typing hundreds of shifts again and keeps every rota rule applied to them.

Drop the event rota spreadsheet your team already keeps, in CSV or Excel, and Fai reads which column holds 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.

Untuk:  Bringing a rota you planned in a spreadsheet into your event

Perlu waktu:  5 menit

- [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)

## Sebelum mulai

- You are an owner, admin or producer on the event. The event's **Operations** page opens for those roles only.
- 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**.

   **Catatan:** If an import is still being checked, the dialog offers **Carry on** to go back to it.
          ![Ticket Fairy 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**.

   **Catatan:** A file can hold up to 500 shifts and 2 MB. Only the first sheet of an Excel file is read.
3. ## Check what each column holds

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

   **Catatan:** 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.
          ![Ticket Fairy 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.

   **Catatan:** 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.

   **Catatan:** A row without a day, a time or a department or role cannot be added. An end time before the start time is the next morning.
6. ## Add the shifts

   Select the button that counts the rows ready to add, such as Add 3 shifts.

   **Catatan:** The shifts are added to the rota ready for people, with every rota rule applied. Pressing Add again on the same import never adds them twice, but uploading the same file again adds them again.

## Coba langkah-langkah ini di acara Anda sendiri

Buat akun gratis, susun acara Anda dan ikuti langkah-langkah di atas di dasbor Anda sendiri. Hanya perlu beberapa menit dan Anda tidak perlu menjadwalkan panggilan penjualan.

    Alamat email Anda    [Buat akun gratis](https://manage.ticketfairy.com/welcome) [Pesan demo](https://www.ticketfairy.com/id/event-ticketing/book-a-demo)

Tanpa biaya pemasangan. Tanpa biaya bulanan wajib. Tanpa kartu kredit.

## Atau minta dikerjakan untuk Anda

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.

### Di dasbor Anda, dengan Fai

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

## Biarkan Fai mengerjakannya untuk Anda

Fai bekerja di dalam dasbor Ticket Fairy Anda. Buat akun Anda, buka Fai dan tempel perintah di atas.

   [Buat akun gratis](https://manage.ticketfairy.com/welcome) [Pesan demo](https://www.ticketfairy.com/id/event-ticketing/book-a-demo)

Tanpa biaya pemasangan. Tanpa biaya bulanan wajib. Tanpa kartu kredit.

## Pertanyaan yang mungkin Anda punya

Does Fai read my whole spreadsheet?:  Fai reads the headings and the first five rows to match the columns. If Fai is not available, the columns are matched 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?:  The shifts are added once. The second person sees "These shifts were already added."

Are formulas in my spreadsheet worked out?:  No. The import reads 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.

## Masih ada pertanyaan?

Jadwalkan demo dan kami akan menjawabnya lewat panggilan, sesuai jenis acara Anda. Atau buat akun Anda dan lihat sendiri.

   [Pesan demo](https://www.ticketfairy.com/id/event-ticketing/book-a-demo) [Buat akun gratis](https://manage.ticketfairy.com/welcome)

Tanpa biaya pemasangan. Tanpa biaya bulanan wajib. Tanpa kartu kredit.

## Panduan terkait

- [Cara lain menggunakan Ticket Fairy](https://www.ticketfairy.com/features)
- [Build your event rota and check staff in](https://www.ticketfairy.com/id/guides/build-your-event-rota-and-check-staff-in)
- [Offer open shifts on your event rota to crew and volunteers](https://www.ticketfairy.com/id/guides/offer-open-shifts-to-your-crew-and-volunteers)
- [Setujui jam kerja kru dan relawan acara Anda](https://www.ticketfairy.com/id/guides/approve-the-hours-your-crew-and-volunteers-worked)
- [Jalankan acara Anda dari halaman Hari ini](https://www.ticketfairy.com/id/guides/run-your-event-from-its-today-page)
- [Cari penampil, panggung, atau hari apa pun di acara Anda](https://www.ticketfairy.com/id/guides/find-any-performer-stage-or-day-on-your-event)
- [Buat susunan acara untuk hari acara Anda](https://www.ticketfairy.com/id/guides/plan-your-event-production)
- [Lacak setiap pemesanan artis untuk acara Anda](https://www.ticketfairy.com/id/guides/book-and-brief-your-artists)
- [Jaga pekerjaan di balik acara tetap berjalan](https://www.ticketfairy.com/id/guides/keep-your-event-tasks-on-track)
- [Seimbangkan beban kerja tim acara Anda](https://www.ticketfairy.com/id/guides/balance-your-event-teams-workload)
- [Baca email acara Anda di satu inbox](https://www.ticketfairy.com/id/guides/read-your-event-email-in-one-inbox)
- [Buat catatan untuk panggilan acara dengan Fai](https://www.ticketfairy.com/id/guides/take-notes-on-your-event-calls-with-fai)
- [Pilih tindakan Fai untuk acara Anda](https://www.ticketfairy.com/id/guides/choose-what-fai-does-on-your-event)
- [Lihat tampilan email acara Anda](https://www.ticketfairy.com/id/guides/choose-how-your-event-emails-look)
- [Kelola daftar rider dan catatan untuk artis di acara Anda](https://www.ticketfairy.com/id/guides/keep-rider-lists-and-notes-for-your-artists)
- [Buat daftar belanja ruang ganti dari rider artis acara Anda](https://www.ticketfairy.com/id/guides/build-a-dressing-room-shopping-list-from-artist-riders)
- [Majukan artis Anda sebelum pertunjukan](https://www.ticketfairy.com/id/guides/advance-your-performers-before-the-show)
- [Atur jatah daftar tamu, hotel, dan makan setiap penampil untuk acara Anda](https://www.ticketfairy.com/id/guides/set-each-performers-allowances-and-travel-party)
- [Isi advance setiap performer untuk acara Anda dari tour book, rider, dan email](https://www.ticketfairy.com/id/guides/fill-in-advances-from-tour-books-riders-and-emails)
- [Lacak tempat menginap artis dan kru acara Anda](https://www.ticketfairy.com/id/guides/book-travel-and-accommodation-for-your-artists)
- [Bagikan daftar kamar acara Anda ke hotel dan penjemputan ke pengemudi](https://www.ticketfairy.com/id/guides/share-rooming-lists-with-hotels-and-pickups-with-drivers)
- [Rencanakan penjemputan artis dengan pengemudi dan kendaraan untuk acara Anda](https://www.ticketfairy.com/id/guides/plan-artist-pickups-with-drivers-and-vehicles)
- [Rencanakan rundown dan tentukan pemandu cue](https://www.ticketfairy.com/id/guides/plan-your-run-of-show-and-who-calls-it)
- [Periksa rundown Anda untuk mencari benturan sebelum hari pertunjukan](https://www.ticketfairy.com/id/guides/check-your-running-order-for-clashes-before-show-day)
- [Bagikan lembar harian kepada tim di lokasi acara](https://www.ticketfairy.com/id/guides/share-day-sheets-with-your-on-site-teams)
- [Panggil pertunjukan Anda secara langsung pada hari pertunjukan](https://www.ticketfairy.com/id/guides/call-your-show-live-on-show-day)
- [Pesan ruang ganti dan rencanakan hari pemasangan atau pembongkaran untuk acara Anda](https://www.ticketfairy.com/id/guides/book-dressing-rooms-and-plan-build-and-break-days)
- [Tahan tanggal untuk pertunjukan di venue Anda](https://www.ticketfairy.com/id/guides/hold-dates-for-shows-at-your-venue)
- [Buat penawaran kepada agen artis untuk acara Anda](https://www.ticketfairy.com/id/guides/make-an-offer-to-an-artists-agent)
- [Tangani kontrak, faktur, dan rider yang dikirim agen artis untuk acara Anda](https://www.ticketfairy.com/id/guides/handle-the-contract-invoice-and-riders-an-agent-sends-back)
- [Selesaikan pembayaran pertunjukan dengan artis setelah acara Anda](https://www.ticketfairy.com/id/guides/settle-a-show-with-an-artist)
- [Kirim kontrak acara dan dapatkan tanda tangan secara online](https://www.ticketfairy.com/id/guides/send-contracts-and-get-them-signed-online)
- [Buat pesanan pembelian dan lacak utang acara Anda](https://www.ticketfairy.com/id/guides/raise-purchase-orders-and-track-what-your-event-owes)
- [Hitung backline dan produksi yang perlu disewa untuk acara Anda](https://www.ticketfairy.com/id/guides/work-out-the-backline-and-production-to-hire-for-your-event)
- [Kirim daftar sewa acara kepada pemasok](https://www.ticketfairy.com/id/guides/send-your-hire-lists-to-suppliers)
- [Ambil pendaftaran pedagang makanan, minuman, dan pasar untuk acara Anda](https://www.ticketfairy.com/id/guides/take-trader-applications-for-your-event)
- [Tinjau pendaftaran artis dan sesi bicara untuk acara Anda bersama tim](https://www.ticketfairy.com/id/guides/review-act-and-talk-applications-with-your-team)
- [Siapkan pedagang Anda untuk hari acara](https://www.ticketfairy.com/id/guides/get-your-traders-ready-for-show-day)
- [Kumpulkan asuransi dan sertifikat dari tim luar acara](https://www.ticketfairy.com/id/guides/collect-insurance-and-certificates-from-your-outside-teams)
- [Draw your event site map and share it](https://www.ticketfairy.com/id/guides/draw-your-event-site-map-and-share-it)
- [Pesan waktu pengiriman untuk acara Anda dan catat kendaraan masuk di gerbang](https://www.ticketfairy.com/id/guides/book-delivery-times-and-check-vehicles-in-at-the-gate)
- [Issue accreditation passes for your event](https://www.ticketfairy.com/id/guides/issue-accreditation-passes-for-your-event)
- [Biarkan tim luar menamai orang mereka sendiri untuk pas acara](https://www.ticketfairy.com/id/guides/let-outside-teams-name-their-own-people-for-passes)
- [Pilih siapa yang menyetujui permintaan akreditasi untuk acara Anda](https://www.ticketfairy.com/id/guides/choose-who-approves-accreditation-requests)
- [Rekrut relawan untuk acara Anda](https://www.ticketfairy.com/id/guides/recruit-volunteers-for-your-event)
- [Setujui atau tolak permintaan akreditasi untuk acara Anda](https://www.ticketfairy.com/id/guides/approve-or-decline-accreditation-requests-for-your-event)
- [Give your event volunteers their own page and track their hours](https://www.ticketfairy.com/id/guides/give-volunteers-their-own-page-and-track-hours)
- [Hand out accreditation passes at your event desk](https://www.ticketfairy.com/id/guides/hand-out-accreditation-passes-at-your-desk)
- [Give crew meals at your event meal desk](https://www.ticketfairy.com/id/guides/give-crew-meals-at-your-meal-desk)
- [Report and handle incidents at your event](https://www.ticketfairy.com/id/guides/report-and-handle-incidents-at-your-event)
- [Hand out radios and kit to your event crew](https://www.ticketfairy.com/id/guides/hand-out-radios-and-kit-to-your-event-crew)
- [Let outside teams order kit and equipment for your event](https://www.ticketfairy.com/id/guides/let-outside-teams-order-kit-and-equipment-for-your-event)
- [Handle lost property at your event](https://www.ticketfairy.com/id/guides/handle-lost-property-at-your-event)
- [Get hire suppliers to confirm orders and count deliveries for your event](https://www.ticketfairy.com/id/guides/get-hire-suppliers-to-confirm-orders-and-count-deliveries)
- [Keep a risk register for your event](https://www.ticketfairy.com/id/guides/keep-a-risk-register-for-your-event)
- [Message the crew, volunteers and traders working on your event](https://www.ticketfairy.com/id/guides/message-the-people-working-on-your-event)
- [Kirim daftar acara kepada tim sesuai jadwal](https://www.ticketfairy.com/id/guides/send-your-event-lists-to-your-team-on-a-schedule)
- [Publish your event line-up and set times](https://www.ticketfairy.com/id/guides/publish-your-line-up-and-set-times)
- [Ask attendees for feedback after your event](https://www.ticketfairy.com/id/guides/ask-attendees-for-feedback-after-your-event)
- [Plan next year's event from your attendee feedback](https://www.ticketfairy.com/id/guides/plan-next-year-from-your-attendee-feedback)
- [Hold hotel rooms for your event's artists and crew](https://www.ticketfairy.com/id/guides/hold-hotel-rooms-for-your-artists-and-crew)
- [Kembalikan kamar hotel acara yang tidak terpakai sebelum tanggal pengembalian](https://www.ticketfairy.com/id/guides/give-unused-hotel-rooms-back-before-the-release-date)
- [Jual kamar hotel kepada pembeli tiket dari blok kamar](https://www.ticketfairy.com/id/guides/sell-hotel-rooms-to-your-ticket-buyers-from-a-hotel-block)
- [Copy the setup of your last event into your next one](https://www.ticketfairy.com/id/guides/copy-the-setup-of-your-last-event-into-your-next-one)
- [Compare your ticket sales with your last event](https://www.ticketfairy.com/id/guides/compare-your-ticket-sales-with-your-last-event)
- [Lihat biaya total setiap artis di acara Anda](https://www.ticketfairy.com/id/guides/see-the-all-in-cost-of-each-act-on-your-event)
- [See what your brand spends across its events](https://www.ticketfairy.com/id/guides/see-what-your-brand-spends-across-its-events)
- [Show your traders in a directory on your website](https://www.ticketfairy.com/id/guides/show-your-traders-in-a-directory-on-your-website)
- [Place your traders on pitches on your event site map](https://www.ticketfairy.com/id/guides/place-your-traders-on-pitches-on-your-site-map)
- [Check your traders' takings after your event and invoice their share of sales](https://www.ticketfairy.com/id/guides/check-trader-takings-and-invoice-a-share-of-sales)
- [Share a power sheet with your event electrician](https://www.ticketfairy.com/id/guides/share-a-power-sheet-with-your-electrician)
- [Give exhibitors a lead scanner for their booth at your event](https://www.ticketfairy.com/id/guides/give-exhibitors-a-lead-scanner-for-their-booth)
- [Biarkan Exhibitors menindaklanjuti prospek acara dan melihat hasilnya](https://www.ticketfairy.com/id/guides/let-exhibitors-follow-up-their-leads-and-see-results)
- [Kirim paket dokumen acara kepada penampil, pedagang, dan kru](https://www.ticketfairy.com/id/guides/send-document-packs-to-your-performers-traders-and-crew)
- [Send contracts to many performers, traders or suppliers for your event at once](https://www.ticketfairy.com/id/guides/send-contracts-to-many-performers-traders-or-suppliers-at-once)
- [Find the crew and volunteers who work your events](https://www.ticketfairy.com/id/guides/find-the-crew-and-volunteers-who-work-your-events)
- [Give your event crew one page for all their shifts](https://www.ticketfairy.com/id/guides/give-your-crew-one-page-for-all-their-shifts)
- [Let event staff work a desk from their phone with a desk link](https://www.ticketfairy.com/id/guides/let-event-staff-work-a-desk-from-their-phone)
- [Check accreditation passes in and out at your event staff gates](https://www.ticketfairy.com/id/guides/check-passes-in-and-out-at-your-staff-gates)
- [Collect crew certificates and licences before they work an event shift](https://www.ticketfairy.com/id/guides/collect-crew-certificates-before-they-work-a-shift)
- [Run a safety induction for everyone who works your event](https://www.ticketfairy.com/id/guides/run-a-safety-induction-for-everyone-who-works-your-event)
- [Plan crew meal times and food needs for your event](https://www.ticketfairy.com/id/guides/plan-crew-meal-times-and-food-needs-for-your-event)
- [Charge outside teams for the crew meals they eat at your event](https://www.ticketfairy.com/id/guides/charge-outside-teams-for-their-crew-meals)
- [Check-in peserta dan cetak tanda pengenal di meja registrasi acara Anda](https://www.ticketfairy.com/id/guides/check-in-attendees-and-print-badges-at-registration)
- [Set up a self-service check-in kiosk for your event](https://www.ticketfairy.com/id/guides/set-up-a-self-service-check-in-kiosk-for-your-event)
- [Let department leads approve their team's hours at your event](https://www.ticketfairy.com/id/guides/let-department-leads-approve-their-teams-hours)
- [Let ticket holders pick the conference sessions they attend](https://www.ticketfairy.com/id/guides/let-ticket-holders-pick-the-sessions-they-attend)
- [Scan delegates into event sessions at the door and see who came](https://www.ticketfairy.com/id/guides/scan-ticket-holders-into-sessions-and-see-who-came)
- [Set pitch rules and let Fai plan your trader pitches at your event](https://www.ticketfairy.com/id/guides/set-pitch-rules-and-let-fai-plan-your-trader-pitches)
- [Share a private event site map with emergency services and suppliers](https://www.ticketfairy.com/id/guides/share-a-private-site-map-with-emergency-services-and-suppliers)
- [Handle trader requests to move pitch at your event](https://www.ticketfairy.com/id/guides/handle-trader-requests-to-move-pitch)
- [Show now and next on screens backstage and at the side of the stage](https://www.ticketfairy.com/id/guides/show-now-and-next-on-backstage-screens)
- [Add your run of show to your team's calendars](https://www.ticketfairy.com/id/guides/add-your-run-of-show-to-your-teams-calendars)
- [Show each act their whole stay and what changed](https://www.ticketfairy.com/id/guides/show-each-act-their-whole-stay-and-what-changed)
- [See which event pass holders have arrived and send a pass again](https://www.ticketfairy.com/id/guides/see-which-pass-holders-have-arrived-and-send-a-pass-again)
- [See why tickets and passes were refused at the door](https://www.ticketfairy.com/id/guides/see-why-tickets-and-passes-were-refused-at-the-door)
- [Tambahkan semua pengirim formulir acara ke relawan, pedagang, atau kru Anda](https://www.ticketfairy.com/id/guides/add-form-applicants-to-your-event-teams)
- [Semua panduan Ticket Fairy](https://www.ticketfairy.com/id/guides)

## Lakukan ini di acara Anda sendiri

Buat akun, susun acara, dan ikuti langkah-langkahnya di dasbor Anda. Anda tidak perlu memesan panggilan penjualan.

  [Buat akun gratis](https://manage.ticketfairy.com/welcome) [Pesan demo](https://www.ticketfairy.com/id/event-ticketing/book-a-demo)

## Jual tiket dengan Ticket Fairy

Semua yang ada di panduan ini tersedia di dasbor Anda sejak hari Anda mendaftar.

- Siapkan acara Anda dalam hitungan menit
- Acara gratis memang gratis
- Fai, kopilot Anda, sudah tersedia

 [Buat akun gratis](https://manage.ticketfairy.com/welcome)

Tanpa biaya pemasangan. Tanpa biaya bulanan wajib. Tanpa kartu kredit.

## Lihat lewat panggilan

Jadwalkan demo dan kami akan menunjukkan cara Ticket Fairy menangani jenis acara Anda.

 [Pesan demo](https://www.ticketfairy.com/id/event-ticketing/book-a-demo) [Cara lain menggunakan Ticket Fairy](https://www.ticketfairy.com/features)

### Kiat untuk menjual lebih banyak tiket

Saran praktis dari penyelenggara yang tiketnya habis terjual, dan setiap panduan baru begitu terbit.

Kami menghormati privasi Anda. Berhenti berlangganan kapan saja.