--- title: "Add shifts to your event rota from a spreadsheet | Guías de 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/es/guides/add-shifts-to-your-event-rota-from-a-spreadsheet" --- # Add shifts to your event rota from a spreadsheet | Guías de Ticket Fairy 1. [Ticket Fairy](https://www.ticketfairy.com/) 2. [Guías](https://www.ticketfairy.com/es/guides) 3. Add shifts to your event rota from a spreadsheet Gestionar la producción # 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. Para: Bringing a rota you planned in a spreadsheet into your event Dura: 5 minutos - [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) ## Antes de empezar - 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**. **Nota:** 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**. **Nota:** 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. **Nota:** 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. **Nota:** 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. **Nota:** 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. **Nota:** 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. ## Prueba estos pasos en tu propio evento Crea una cuenta gratis, monta tu evento y sigue los pasos de arriba en tu propio panel. Tarda unos minutos y no necesitas reservar una llamada comercial. Tu dirección de correo electrónico [Crear una cuenta gratis](https://manage.ticketfairy.com/welcome) [Reserva una demo](https://www.ticketfairy.com/es/event-ticketing/book-a-demo) Sin cuotas de alta. Sin cuota mensual obligatoria. Sin tarjeta de crédito. ## O deja que lo hagan por ti 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. ### En tu panel, con Fai Add these shifts to the rota at \: \ ## Deja que Fai lo haga por ti Fai trabaja dentro de tu panel de Ticket Fairy. Crea tu cuenta, abre Fai y pega la instrucción de arriba. [Crear una cuenta gratis](https://manage.ticketfairy.com/welcome) [Reserva una demo](https://www.ticketfairy.com/es/event-ticketing/book-a-demo) Sin cuotas de alta. Sin cuota mensual obligatoria. Sin tarjeta de crédito. ## Preguntas que puedes tener 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. ## ¿Todavía tienes una pregunta? Reserva una demo y te la respondemos en una llamada, sobre tu tipo de evento. O crea tu cuenta y compruébalo por ti mismo. [Reserva una demo](https://www.ticketfairy.com/es/event-ticketing/book-a-demo) [Crear una cuenta gratis](https://manage.ticketfairy.com/welcome) Sin cuotas de alta. Sin cuota mensual obligatoria. Sin tarjeta de crédito. ## Guías relacionadas - [Más formas de usar Ticket Fairy](https://www.ticketfairy.com/features) - [Build your event rota and check staff in](https://www.ticketfairy.com/es/guides/build-your-event-rota-and-check-staff-in) - [Offer open shifts on your event rota to crew and volunteers](https://www.ticketfairy.com/es/guides/offer-open-shifts-to-your-crew-and-volunteers) - [Aprobar las horas trabajadas por el equipo de tu evento y los voluntarios](https://www.ticketfairy.com/es/guides/approve-the-hours-your-crew-and-volunteers-worked) - [Gestiona tu evento desde su página Hoy](https://www.ticketfairy.com/es/guides/run-your-event-from-its-today-page) - [Encuentra cualquier artista, escenario o día de tu evento](https://www.ticketfairy.com/es/guides/find-any-performer-stage-or-day-on-your-event) - [Crea el orden de actuaciones del día del evento](https://www.ticketfairy.com/es/guides/plan-your-event-production) - [Registra cada contratación de artistas para tu evento](https://www.ticketfairy.com/es/guides/book-and-brief-your-artists) - [Mantén en marcha las tareas de tu evento](https://www.ticketfairy.com/es/guides/keep-your-event-tasks-on-track) - [Equilibra la carga de trabajo de tu equipo del evento](https://www.ticketfairy.com/es/guides/balance-your-event-teams-workload) - [Lee el correo de tu evento en un solo buzón](https://www.ticketfairy.com/es/guides/read-your-event-email-in-one-inbox) - [Toma notas de tus llamadas sobre eventos con Fai](https://www.ticketfairy.com/es/guides/take-notes-on-your-event-calls-with-fai) - [Elige qué hace Fai en tu evento](https://www.ticketfairy.com/es/guides/choose-what-fai-does-on-your-event) - [Elige cómo se ven los correos de tu evento](https://www.ticketfairy.com/es/guides/choose-how-your-event-emails-look) - [Mantén las listas y notas de los artistas de tu evento](https://www.ticketfairy.com/es/guides/keep-rider-lists-and-notes-for-your-artists) - [Crea una lista de compras para los camerinos a partir de los riders de tus artistas](https://www.ticketfairy.com/es/guides/build-a-dressing-room-shopping-list-from-artist-riders) - [Prepara a tus artistas antes del show](https://www.ticketfairy.com/es/guides/advance-your-performers-before-the-show) - [Configura las asignaciones de lista de invitados, hotel y comidas de cada artista para tu evento](https://www.ticketfairy.com/es/guides/set-each-performers-allowances-and-travel-party) - [Completa la información previa de cada artista para tu evento a partir de tour books, riders y correos electrónicos](https://www.ticketfairy.com/es/guides/fill-in-advances-from-tour-books-riders-and-emails) - [Controla dónde se alojan los artistas y el equipo de tu evento](https://www.ticketfairy.com/es/guides/book-travel-and-accommodation-for-your-artists) - [Comparte las listas de habitaciones de tu evento con hoteles y las recogidas con los choferes](https://www.ticketfairy.com/es/guides/share-rooming-lists-with-hotels-and-pickups-with-drivers) - [Planifica las recogidas de tus artistas con choferes y vehículos para tu evento](https://www.ticketfairy.com/es/guides/plan-artist-pickups-with-drivers-and-vehicles) - [Planifica el minuto a minuto y quién lo dirige](https://www.ticketfairy.com/es/guides/plan-your-run-of-show-and-who-calls-it) - [Revisa el minuto a minuto para detectar conflictos antes del día del evento](https://www.ticketfairy.com/es/guides/check-your-running-order-for-clashes-before-show-day) - [Comparte las hojas del día con los equipos de tu evento](https://www.ticketfairy.com/es/guides/share-day-sheets-with-your-on-site-teams) - [Pon tu espectáculo al aire el día del espectáculo](https://www.ticketfairy.com/es/guides/call-your-show-live-on-show-day) - [Reserva camerinos y planifica los días de montaje y desmontaje de tu evento](https://www.ticketfairy.com/es/guides/book-dressing-rooms-and-plan-build-and-break-days) - [Apartar fechas para espectáculos en tu espacio](https://www.ticketfairy.com/es/guides/hold-dates-for-shows-at-your-venue) - [Haz una oferta al agente de un artista para tu show](https://www.ticketfairy.com/es/guides/make-an-offer-to-an-artists-agent) - [Gestiona el contrato, la factura y los riders que envía el agente de un artista](https://www.ticketfairy.com/es/guides/handle-the-contract-invoice-and-riders-an-agent-sends-back) - [Liquidar un show con un artista después de tu evento](https://www.ticketfairy.com/es/guides/settle-a-show-with-an-artist) - [Enviar los contratos de tu evento y conseguir que los firmen online](https://www.ticketfairy.com/es/guides/send-contracts-and-get-them-signed-online) - [Crear órdenes de compra y hacer seguimiento de lo que debe tu evento](https://www.ticketfairy.com/es/guides/raise-purchase-orders-and-track-what-your-event-owes) - [Calcula la renta de backline y producción para tu evento](https://www.ticketfairy.com/es/guides/work-out-the-backline-and-production-to-hire-for-your-event) - [Envía tus listas de renta para el evento a los proveedores](https://www.ticketfairy.com/es/guides/send-your-hire-lists-to-suppliers) - [Acepta solicitudes de vendedores de comida, bebidas y mercados para tu evento](https://www.ticketfairy.com/es/guides/take-trader-applications-for-your-event) - [Revisa solicitudes de artistas y charlas para tu evento con tu equipo](https://www.ticketfairy.com/es/guides/review-act-and-talk-applications-with-your-team) - [Prepara a tus vendedores para el día del evento](https://www.ticketfairy.com/es/guides/get-your-traders-ready-for-show-day) - [Collect insurance and certificates from your event's outside teams](https://www.ticketfairy.com/es/guides/collect-insurance-and-certificates-from-your-outside-teams) - [Draw your event site map and share it](https://www.ticketfairy.com/es/guides/draw-your-event-site-map-and-share-it) - [Book delivery times for your event and check vehicles in at the gate](https://www.ticketfairy.com/es/guides/book-delivery-times-and-check-vehicles-in-at-the-gate) - [Issue accreditation passes for your event](https://www.ticketfairy.com/es/guides/issue-accreditation-passes-for-your-event) - [Let outside teams name their own people for event passes](https://www.ticketfairy.com/es/guides/let-outside-teams-name-their-own-people-for-passes) - [Choose who approves accreditation requests for your event](https://www.ticketfairy.com/es/guides/choose-who-approves-accreditation-requests) - [Recruit volunteers for your event](https://www.ticketfairy.com/es/guides/recruit-volunteers-for-your-event) - [Approve or decline accreditation requests for your event](https://www.ticketfairy.com/es/guides/approve-or-decline-accreditation-requests-for-your-event) - [Give your event volunteers their own page and track their hours](https://www.ticketfairy.com/es/guides/give-volunteers-their-own-page-and-track-hours) - [Hand out accreditation passes at your event desk](https://www.ticketfairy.com/es/guides/hand-out-accreditation-passes-at-your-desk) - [Give crew meals at your event meal desk](https://www.ticketfairy.com/es/guides/give-crew-meals-at-your-meal-desk) - [Report and handle incidents at your event](https://www.ticketfairy.com/es/guides/report-and-handle-incidents-at-your-event) - [Hand out radios and kit to your event crew](https://www.ticketfairy.com/es/guides/hand-out-radios-and-kit-to-your-event-crew) - [Let outside teams order kit and equipment for your event](https://www.ticketfairy.com/es/guides/let-outside-teams-order-kit-and-equipment-for-your-event) - [Handle lost property at your event](https://www.ticketfairy.com/es/guides/handle-lost-property-at-your-event) - [Get hire suppliers to confirm orders and count deliveries for your event](https://www.ticketfairy.com/es/guides/get-hire-suppliers-to-confirm-orders-and-count-deliveries) - [Keep a risk register for your event](https://www.ticketfairy.com/es/guides/keep-a-risk-register-for-your-event) - [Message the crew, volunteers and traders working on your event](https://www.ticketfairy.com/es/guides/message-the-people-working-on-your-event) - [Envía las listas de tu evento a tu equipo según un horario](https://www.ticketfairy.com/es/guides/send-your-event-lists-to-your-team-on-a-schedule) - [Publish your event line-up and set times](https://www.ticketfairy.com/es/guides/publish-your-line-up-and-set-times) - [Ask attendees for feedback after your event](https://www.ticketfairy.com/es/guides/ask-attendees-for-feedback-after-your-event) - [Plan next year's event from your attendee feedback](https://www.ticketfairy.com/es/guides/plan-next-year-from-your-attendee-feedback) - [Hold hotel rooms for your event's artists and crew](https://www.ticketfairy.com/es/guides/hold-hotel-rooms-for-your-artists-and-crew) - [Devuelve las habitaciones de hotel sin usar de tu evento antes de la fecha de liberación](https://www.ticketfairy.com/es/guides/give-unused-hotel-rooms-back-before-the-release-date) - [Vende habitaciones de hotel a tus compradores de boletos desde un bloqueo de habitaciones](https://www.ticketfairy.com/es/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/es/guides/copy-the-setup-of-your-last-event-into-your-next-one) - [Compare your ticket sales with your last event](https://www.ticketfairy.com/es/guides/compare-your-ticket-sales-with-your-last-event) - [Consulta el costo total de cada artista en tu evento](https://www.ticketfairy.com/es/guides/see-the-all-in-cost-of-each-act-on-your-event) - [See what your brand spends across its events](https://www.ticketfairy.com/es/guides/see-what-your-brand-spends-across-its-events) - [Show your traders in a directory on your website](https://www.ticketfairy.com/es/guides/show-your-traders-in-a-directory-on-your-website) - [Place your traders on pitches on your event site map](https://www.ticketfairy.com/es/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/es/guides/check-trader-takings-and-invoice-a-share-of-sales) - [Share a power sheet with your event electrician](https://www.ticketfairy.com/es/guides/share-a-power-sheet-with-your-electrician) - [Give exhibitors a lead scanner for their booth at your event](https://www.ticketfairy.com/es/guides/give-exhibitors-a-lead-scanner-for-their-booth) - [Permite que los expositores hagan seguimiento de sus contactos del evento y vean sus resultados](https://www.ticketfairy.com/es/guides/let-exhibitors-follow-up-their-leads-and-see-results) - [Envía paquetes de documentos del evento a tus artistas, comerciantes y equipo](https://www.ticketfairy.com/es/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/es/guides/send-contracts-to-many-performers-traders-or-suppliers-at-once) - [Find the crew and volunteers who work your events](https://www.ticketfairy.com/es/guides/find-the-crew-and-volunteers-who-work-your-events) - [Give your event crew one page for all their shifts](https://www.ticketfairy.com/es/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/es/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/es/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/es/guides/collect-crew-certificates-before-they-work-a-shift) - [Run a safety induction for everyone who works your event](https://www.ticketfairy.com/es/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/es/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/es/guides/charge-outside-teams-for-their-crew-meals) - [Registrar a los asistentes e imprimir gafetes con sus nombres en el mostrador de registro del evento](https://www.ticketfairy.com/es/guides/check-in-attendees-and-print-badges-at-registration) - [Set up a self-service check-in kiosk for your event](https://www.ticketfairy.com/es/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/es/guides/let-department-leads-approve-their-teams-hours) - [Let ticket holders pick the conference sessions they attend](https://www.ticketfairy.com/es/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/es/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/es/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/es/guides/share-a-private-site-map-with-emergency-services-and-suppliers) - [Handle trader requests to move pitch at your event](https://www.ticketfairy.com/es/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/es/guides/show-now-and-next-on-backstage-screens) - [Add your run of show to your team's calendars](https://www.ticketfairy.com/es/guides/add-your-run-of-show-to-your-teams-calendars) - [Show each act their whole stay and what changed](https://www.ticketfairy.com/es/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/es/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/es/guides/see-why-tickets-and-passes-were-refused-at-the-door) - [Agrega a todas las personas que envíen el formulario de tu evento a tus voluntarios, comerciantes o equipo técnico](https://www.ticketfairy.com/es/guides/add-form-applicants-to-your-event-teams) - [Todas las guías de Ticket Fairy](https://www.ticketfairy.com/es/guides) ## Hazlo en tu propio evento Crea tu cuenta, monta tu evento y sigue los pasos en tu propio panel. No necesitas reservar una llamada comercial. [Crear una cuenta gratis](https://manage.ticketfairy.com/welcome) [Reserva una demo](https://www.ticketfairy.com/es/event-ticketing/book-a-demo) ## Vende entradas con Ticket Fairy Todo lo que ves en estas guías está en tu panel desde el día en que te registras. - Monta tu evento en minutos - Los eventos gratuitos son gratis - Fai, tu copiloto, viene incluida [Crear una cuenta gratis](https://manage.ticketfairy.com/welcome) Sin cuotas de alta. Sin cuota mensual obligatoria. Sin tarjeta de crédito. ## Míralo en una llamada Reserva una demo y te mostramos cómo Ticket Fairy gestiona tu tipo de evento. [Reserva una demo](https://www.ticketfairy.com/es/event-ticketing/book-a-demo) [Más formas de usar Ticket Fairy](https://www.ticketfairy.com/features) ### Consejos para vender más entradas Consejos prácticos de organizadores que agotan entradas, y cada guía nueva en cuanto se publica. Respetamos tu privacidad. Cancela cuando quieras.