---
title: "Bring your event spreadsheets into a spell, and download its lists | Ticket Fairy Guides"
description: "Turn the spreadsheets your event team keeps, such as a supplier list or a guest list, into a spell's lists in a few minutes: drop a CSV or Excel file, check how each sheet becomes a list, and add the entries. Any list downloads again as a spreadsheet that opens in Excel."
canonical: "https://www.ticketfairy.com/guides/bring-your-event-spreadsheets-into-a-spell"
---

1. [Ticket Fairy](https://www.ticketfairy.com/)
2. [Guides](https://www.ticketfairy.com/guides)
3. Bring your event spreadsheets into a spell, and download its lists

Fai, your AI teammate

# Bring your event spreadsheets into a spell, and download its lists

Most event teams start with a spreadsheet: the supplier contacts, the crew list, last year's sponsor deliverables. Bringing it into a spell puts those rows where your event team works, with statuses, history and Fai, and nothing stops you taking them out again.

Takes:  8 minutes

- [Select Start from a spreadsheet](#step-1)
- [Add your spreadsheet](#step-2)
- [Choose where the entries go](#step-3)
- [Check how each sheet becomes a list](#step-4)
- [Check each column](#step-5)
- [Update the preview](#step-6)
- [Add the entries](#step-7)

## Before you start

- Anyone on your brand's team who can open Spellbook can turn a spreadsheet into a new spell. Adding to a spell you already have needs you to be able to change it.
- Use a CSV file, tab-separated text or an Excel (.xlsx) file of up to 5 MB, with up to 20 sheets and 20,000 rows a sheet, and headings in the first row.

1. ## Select Start from a spreadsheet

   In Spellbook, select **Start from a spreadsheet** beside **Make it with Fai**.

   ![Start from a spreadsheet: Your spreadsheet (Drop a spreadsheet here, or choose one; CSV, tab-separated text or Excel (.xlsx), up to 5 MB, 20 sheets and 20,000 rows a sheet; Or paste rows; Read the pasted rows), then Your imports: Harbor Festival suppliers 2027.xlsx (Into a new spell, Suppliers, Waiting for you to check) and Volunteers.csv (Into Volunteers, Done)](https://www.ticketfairy.com/embeds/posters/marketing-spellbook--import.png)    
   *Drop a spreadsheet or paste rows, and see your imports.*
2. ## Add your spreadsheet

   Drop the file on **Drop a spreadsheet here, or choose one**, or select it to choose the file.

   **Tip:** To bring in only some rows, copy them from your spreadsheet, headings first, paste them under **Or paste rows** and select **Read the pasted rows**.
3. ## Choose where the entries go

   Under **Where the entries go**, keep **A new spell** and enter its name in **Name of the spell**, or choose **One of your spells**.

   **Note:** For a new spell, choose under **For** whether it is for **The whole brand** or **One event**.

   ![Harbor Festival suppliers 2027.xlsx waiting to be checked: Where the entries go (A new spell, Name of the spell Suppliers, For One event, Event Harbor Festival, Dates such as 03/04/2026 read as Day, month, year); Sheet: Suppliers (120 rows) with the line that Ticket Fairy already keeps suppliers on the event's Hire and shopping page and Open the event's Hire and shopping page, Name for one entry, Name for the list, Column that names each entry; 5 columns with Field name and Kind of value (Short text, Email address, Phone number, Choice with its choices, Date); Preview: 118 of 120 rows become entries, 2 problems with Row, Column and What to change, two sample rows, the line that 2 rows are left out; Discard, Update the preview and Add 118 entries](https://www.ticketfairy.com/embeds/posters/marketing-spellbook--import-check.png)    
   *Check where the entries go and how each column comes in, before anything is added.*
4. ## Check how each sheet becomes a list

   For each sheet, check **Name for the list**, **Name for one entry** and **Column that names each entry**. Untick **Add this sheet** for a sheet you don't need.

   **Note:** If a sheet holds something Ticket Fairy already keeps, such as suppliers or artists, the sheet says where it lives and gives you a button to open that page, such as "Open the event's Hire and shopping page". Add them there instead, or keep the sheet as a list of its own when it tracks something different.
5. ## Check each column

   For each column, check its **Field name** and **Kind of value**, such as **Date** or **Choice**. Untick **Add this column** to leave it out.

   **Note:** Going into a list you already have, choose what each column **Goes into**: one of the list's fields or a new field.
   **Tip:** If your dates are numbers only, such as 03/04/2026, choose how to read them in **Dates such as 03/04/2026 read as**.
6. ## Update the preview

   Select **Update the preview**. The preview says how many rows become entries and lists each problem with its row, its column and what to change.

   **Note:** Nothing is added yet. Fix a problem in your spreadsheet and add it again, or leave the row out.
7. ## Add the entries

   Select the button that adds them, such as "Add 118 entries", check what goes where, and select **Add the entries**.

   **Note:** You can leave the page while the entries come in. When they are in, the import says how many were added, and **Open the spell** opens it. A new spell is private to you until you share it.

## Or have it done for you

Drop the file into a conversation with Fai and ask her to make it a spell or add it to one of yours. She shows you the lists and fields she would make, a preview of the entries and anything left out, and adds nothing until you agree.

### In your dashboard, with Fai

```
Make this supplier spreadsheet into a spell for <EVENT NAME>, with a status for each supplier
```

## Add a spreadsheet to a spell you already have

1. ### Open Add from a spreadsheet

   On the spell's page, select **Add from a spreadsheet** and drop or paste your spreadsheet.

   **Note:** Ticket Fairy matches each sheet to one of the spell's lists and each column to one of its fields, and you check every match before anything is added.
2. ### Choose live or practice entries

   In **Add them to**, choose **Live** for the entries your team sees, or **Practice** to try them first.

   **Note:** Live lists take only the fields they already have. To add a field, add it in Practice and share the spell first.

Fai matches a spreadsheet to one of your spells, shows you where each sheet and column goes and adds the entries after you agree.

### In your dashboard, with Fai

```
Add this spreadsheet of extra suppliers to <SPELL NAME>
```

## Stop or discard an import

1. ### Stop an import that is adding entries

   Under **Your imports** on the Start from a spreadsheet page, open the import and select **Stop**, then confirm.

   **Note:** The entries added so far stay, and you can delete any of them. The rest of the rows are not added.
2. ### Discard an import you no longer need

   Optional: Open an import that is waiting for you to check and select **Discard**, then confirm. The spreadsheet you added is deleted.

Fai tells you how far an import got and stops or discards it after she asks.

### In your dashboard, with Fai

```
Stop the supplier import I started
```

## Download a list as a spreadsheet

1. ### Open Download a list

   On the spell's page, select **Download a list** and choose the list in **List**.

   **Tip:** Open **Only some entries** to keep only one status or the entries with certain words.

   ![Download a list from "Suppliers" window: the line that each download is recorded, List Suppliers, Only some entries open with Status Contract sent and With these words, Close and Download](https://www.ticketfairy.com/embeds/posters/marketing-spellbook--download.png)    
   *Download a list's entries as a spreadsheet, all of them or only some.*
2. ### Make and download the file

   Select **Download**. The file downloads as soon as it is ready, and the window says how many entries it holds.

   **Note:** The file opens in Excel, and you can download it again for 30 days. Every download is recorded, so your team can see who took a copy.

Fai makes the file of a list with the filters you ask for and gives you a link to the spell's page, where you download it.

### In your dashboard, with Fai

```
Download the suppliers in <SPELL NAME> that are still waiting for a contract
```

## Questions you might have

**Who can download a spell's lists?**

 The people who can change the spell. Everyone else who opens **Download a list** reads "Only people who can change this spell can download its lists. Ask whoever looks after it for a copy."

**Who sees my import?**

 Only you see an import you start, with how far it got. The entries it adds are like any others: in a new spell only you see them until you share it, and in a spell your team uses they show where your team sees them.

**Do imported entries start automations?**

 No. Entries an import adds start no automations, so nobody gets a reminder or an approval request for each row.

**What if my spreadsheet has more than one sheet?**

 Each sheet becomes a list of its own, up to 20 sheets. Leave out any sheet you don't need, and each list keeps up to 20,000 entries.

**Does anything in my spreadsheet run?**

 No. Formulas don't run and links aren't followed: only the values in the cells come in. Each entry remembers which file and row it came from.

**Why can't Ticket Fairy read my file?**

 It reads CSV, tab-separated text and Excel (.xlsx) files of up to 5 MB. Save an older .xls file as .xlsx first, and split a bigger file or save it as CSV. You can also paste the rows instead.

## 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/spellbook)
- [Build a spell with Fai for your event team](https://www.ticketfairy.com/guides/build-a-spell-with-fai)
- [Make a spell do your event team's follow-up work by itself](https://www.ticketfairy.com/guides/make-a-spell-do-your-follow-up-work)
- [Add an event spell from the Grand Spellbook, or share yours with other event teams](https://www.ticketfairy.com/guides/add-or-share-event-spells-in-the-grand-spellbook)
- [Ask Fai about your event](https://www.ticketfairy.com/guides/ask-fai-about-your-event)
- [Teach Fai how your team runs its events](https://www.ticketfairy.com/guides/teach-fai-how-your-team-runs-its-events)
- [Make a spell page public for the artists, suppliers and volunteers at your event](https://www.ticketfairy.com/guides/make-a-spell-page-public-for-people-outside-your-event-team)
- [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/spellbook)

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