Free Glastonbury ticket spreadsheet template for your group
A free spreadsheet template for a Glastonbury syndicate: one row per person with their registration number, postcode and status, and how to use it on ticket day.
Almost every guide to buying Glastonbury tickets as a group says the same thing: make a spreadsheet of everyone's names, registration numbers and postcodes. It's good advice for organising a syndicate. This page gives you a ready-made template, explains each column, and shows how to avoid the two ways spreadsheets go wrong on ticket day.
Download the template
Download the Glastonbury group template (CSV file). It's a plain spreadsheet file with no macros or links, so it opens in Google Sheets, Excel, Numbers or any other spreadsheet app. The one example row uses made-up details; replace it with your own group.
What's in it
| Column | What to put in it | Why it matters |
|---|---|---|
| Booking group | A, B, C and so on, up to six people each | One lead booker can book up to six people, so every row needs a group |
| Name | A first name you'd recognise | The booking page shows names back to you, so you can spot a wrong number |
| Registration number | Copied from their See Tickets email | One wrong digit and that person isn't added |
| Registered postcode | The postcode on their registration | It must match the registration, not where they live now |
| Photo accepted | Yes once they've seen the acceptance email | A submitted photo isn't an accepted one |
| Queueing on the day | Yes if they'll be at a screen at sale time | Each person queueing is another chance for the whole syndicate |
| Deposit paid back | Yes once they've paid the lead booker | So nobody is chasing money in April |
Opening it
- Google Sheets: open a new spreadsheet, then File, Import, and upload the file. Share it only with the people in your syndicate.
- Excel or Numbers: open the downloaded file directly, then save it in your app's own format so your changes are kept.
- On a phone: it's easier to set up on a laptop and view on the phone, because the cells are small.
Stop it changing the numbers
Spreadsheet apps like to treat a registration number as a number, not as text. That can drop a leading zero, or show a long number in a shortened form, and either way the number you copy out is no longer the one on the registration.
- Before anyone pastes a number in, select the Registration number column and set its format to plain text (in Google Sheets: Format, Number, Plain text).
- Paste numbers rather than typing them, and check each one against the person's email.
- Postcodes are safer, but check the space hasn't gone missing: the booking form needs the postcode as registered.
How a syndicate uses it
- Fill in a row per person as the details come in, and chase anyone whose photo isn't accepted yet.
- Sort by booking group, so each group of up to six sits together.
- Agree the order: the first person through books group A, the second books group B, and so on. Write it at the top of the sheet.
- On the day, whoever books a group marks it done in the sheet and posts in the chat, so nobody books the same people twice.
For the plan itself, see the Glastonbury syndicate guide. If someone can't find their registration number, see how to find a lost registration number.
On ticket day, use one page per group
A spreadsheet is the right tool for organising. It's the wrong one at checkout, on a phone, with a timer running: the cells are small, the sheet may ask you to sign in, and copying one cell at a time takes care.
So once a booking group's rows are complete, put that group on one page in Glasto Quick Copy. Select the group's rows in the sheet, copy them, and paste them into the tool's Set up your group box: it picks out each name, registration number and postcode, and shows them for you to check before saving. Then send that page's link to everyone who's queueing. At the front of the queue it's one tap per box, and the next box is highlighted for you.
Keeping it private
- Share the sheet only with your syndicate, not with "anyone with the link" if you can avoid it. Registration numbers and postcodes are what someone needs to book in your name.
- Don't post it in a public group or a big community chat.
- Delete it after the resale. There's no reason to keep everyone's details once ticket season is over.
Put a booking group on one page