Spreadsheet vs CRM for promoters: when to switch
In this guide
A spreadsheet is fine for a promoter's contact list while you run a handful of events, send from one tool and have one person managing the data. It's time to switch to a CRM when you're merging lists from several sources, can't tell who consented to what, are copying data between tools to send emails and texts, or more than one person needs to work on the list. The tipping point usually isn't list size, it's the number of places your data lives.
This guide sets out what spreadsheets do well, where they break down for promoters, and how to make the move without losing data or consent records.
Key takeaways
- Spreadsheets are free, flexible and fine for early days, but they don't track consent, history or opt-outs well.
- The clearest signs you've outgrown one: duplicate contacts, uncertain consent, copying data between tools, and more than one person editing.
- A CRM's real value for a promoter is one record per person, showing where they came from, what they agreed to and what they've attended.
- Before moving, clean your spreadsheet and keep a record of where each contact's consent came from.
- Don't import contacts you can't show consent or a soft opt-in basis for.
What we mean by a CRM
A CRM (customer relationship management system) is a database built around people, where each contact has a single record that holds their details, consent, history and interactions. For a promoter, that means one record per fan with their sign-ups, ticket purchases, check-ins and messages, rather than the same person appearing in six different sheets. For a fuller explanation, see what is a music CRM?
What spreadsheets do well
Spreadsheets earn their place, especially early on:
- Free and familiar. Everyone knows how to use one.
- Flexible. You can add any column you like.
- Quick for one-off jobs. Merging a guestlist, totalling sales, sharing a running order.
- Easy to export. Every tool accepts a CSV.
If you run a few events a year, have a few hundred contacts collected through one sign-up form, and send emails from a single tool that handles unsubscribes, a spreadsheet as a backup or working list may be enough.
Where spreadsheets break down for promoters
Duplicates and messy merging
Promoters collect contacts from everywhere: ticket platform exports, sign-up forms, QR codes at the bar, Instagram DMs, guestlists, street team referrals. In a spreadsheet, the same person turns up several times with slightly different details. Merging them by hand is slow and error-prone, and it gets worse every event.
Consent you can't prove
UK GDPR requires you to be able to demonstrate consent. A spreadsheet column saying "opted in: yes" doesn't show when, where, or what wording someone saw, or whether they agreed to email, SMS or both. If someone complains, you need more than a "yes". See consent for marketing texts and emails in the UK.
Opt-outs that don't stick
When someone unsubscribes in your email tool, the spreadsheet doesn't know. Next time you upload the spreadsheet for a new campaign, they're back on. This is one of the most common ways promoters end up messaging people who've opted out.
No history
A spreadsheet row is a snapshot. It doesn't tell you that someone came to four of your last six events, bought on presale every time, and always brings three friends. That history is what tells you who your best customers are.
Copying between tools
If your email tool, your SMS tool and your door check-in each need their own upload, you're exporting and re-importing constantly. Every copy is another place data can go wrong, and another copy you need to secure and eventually delete.
Shared access and security
A spreadsheet emailed to a co-promoter or a door team is a copy you no longer control. Shared drive links get forwarded. There's rarely a record of who changed what. If a laptop or phone with the file on it goes missing, that may be a personal data breach.
Warning signs it's time to switch
You've probably outgrown the spreadsheet if three or more of these apply:
- You have more than one spreadsheet of contacts and aren't sure which is current.
- You've found the same person listed several times with different details.
- You can't say with confidence who agreed to receive texts.
- Someone has complained about getting a message after unsubscribing.
- You export and re-import contacts every time you send an email or text.
- More than one person needs to edit or use the list.
- You want to message people based on what they've attended, not just who they are.
- You run regular events and want follow-ups to go out automatically.
What a CRM gives a promoter
| Job | Spreadsheet | CRM |
|---|---|---|
| One record per person | Manual merging | Automatic de-duplication on email or phone |
| Consent records | A yes/no column | When, where, channel and wording |
| Opt-outs | Separate, easy to lose | Applied across all sends |
| Event history | Separate sheets per event | Purchases, check-ins and sign-ups on the contact |
| Segmenting | Filters and copies | Saved lists that update themselves |
| Sending | Export to another tool | Email, SMS and WhatsApp from one place |
| Team access | Share the whole file | Individual logins with permissions |
| Automations | None | Welcome messages, reminders, follow-ups |
In Backline, for example, ticket-platform imports, sign-up forms, QR codes, Instagram capture and door check-in all feed the same contact record, with consent tracked against it.
How to switch without losing anything
1. Gather every source
Collect every spreadsheet, export and paper sign-up sheet. List where each one came from and how the contacts were collected.
2. Work out the consent basis for each source
For each source, write down:
- What people were told when they gave their details.
- Which channels they agreed to.
- Whether it was consent or a soft opt-in situation.
- The date range.
If you can't establish a valid basis for a source, don't import it for marketing. That might mean leaving out an old list. It's better to start smaller and clean than bigger and risky.
3. Clean the data
- Remove obvious duplicates.
- Standardise phone numbers into one format (for example, starting +44).
- Fix or remove clearly invalid email addresses.
- Add a "source" column so each contact keeps its origin.
4. Import your opt-outs first
Import anyone who has unsubscribed as suppressed before you import anything else, so they can't be re-added by accident. See unsubscribes and STOP replies.
5. Import in batches and check
Import one source at a time and spot-check a few records. Make sure consent, source and tags have come through.
6. Retire the old copies
Once you're confident everything's in, delete or securely archive the old spreadsheets and exports. Leaving them around defeats the point and creates a security risk.
Keep using spreadsheets for what they're good at
Switching to a CRM doesn't mean abandoning spreadsheets. They're still great for budgets, settlement calculations, running orders and quick analysis. The change is that your contact list, consent and history live in one system, and you export from it when you need a sheet, rather than the other way round.
What it costs to stay on a spreadsheet
The spreadsheet is free, but the hidden costs add up: hours spent merging, campaigns sent to the wrong people, complaints from people who'd unsubscribed, and repeat customers you never spotted. If you're running events every month, it's worth costing that time honestly. For ways to put that history to work once it's in one place, see how to get ticket buyers to come back to your next event and how to segment your fan list.
Frequently asked questions
Is a spreadsheet good enough for a promoter's mailing list?
It can be at the start, with one sign-up source, a few hundred contacts and an email tool that handles unsubscribes. It becomes risky once you merge data from several sources, send on more than one channel, or have more than one person working on the list.
When should a promoter switch from a spreadsheet to a CRM?
Usually when you're collecting contacts from several places, can't easily prove who consented to what, keep re-uploading lists to send messages, or have had someone messaged after they unsubscribed. The number of data sources matters more than the size of the list.
Can I import my old spreadsheet into a CRM?
Yes, but only import contacts you have a valid basis to market to, such as consent or the soft opt-in. Clean duplicates first, import opt-outs as suppressed before anything else, and keep a note of where each contact came from.
Do I need a CRM to comply with UK GDPR?
No, the law doesn't require any particular software. But you do need to show consent, honour opt-outs, keep data secure and respond to requests, and a CRM makes those much easier than spreadsheets once your list grows. This is general guidance, not legal advice.
What should I still use spreadsheets for?
Budgets, settlements, running orders, quick analysis and one-off jobs. Treat the CRM as the source of truth for contacts and consent, and export to a spreadsheet when you need one.