Excel or event management software: when spreadsheets fall short
Excel is great for plenty. Here is where it starts costing you money, and what to ask of an event management tool.
Excel works for small, simple events run by one person. It falls short when the budget has several versions, when several people edit the same file, when you need to show the client something without showing your margins and, above all, on show day, when the run of show, seating and door change live. At that point you do not need a better template: you need a tool built for events that lives alongside your spreadsheets rather than banning them.
Let’s be honest about it, because everyone in production has lived on spreadsheets for years.
What Excel does well (and should keep doing)
There is no more flexible tool for thinking with numbers. We still use it for:
- Quick estimates before the brief is final: “what’s the cost per head if it’s 200?”.
- One-off analysis: comparing three hotels, crossing data from past editions, working out an average.
- Lists other people send you: the hotel, the client or a supplier sends their spreadsheet and that is that.
- The agency’s own financial models, which do not need to live inside an events app.
- Everyone has it and can open it. That matters.
If you run two dinners a year for 40 people, a good template is probably all you need. The trouble starts with volume, with a team and with live operations.
Where spreadsheets fall short for events
1. Versions: “budget_FINAL_v3_this_one.xlsx”
The client asks for cuts. You duplicate the tab or the file, change numbers, someone else does the same in their copy, and a week later nobody knows which one is right. When the client says “let’s go back to the earlier option”, you rebuild it from memory.
What you need: named versions inside the same project (initial, adjusted, final) that you can compare and restore.
2. Formulas that break silently
You insert a row and the SUM misses it. You copy a line from another budget and it drags a reference to a tab from an event two years ago. Someone types a number over a formula. Nothing throws an error: the total is just wrong, and you find out after invoicing.
What you need: totals, profit and margin that recalculate on their own, with no formulas anyone can overwrite.
3. VAT per line and the fee
An event mixes different VAT rates depending on the service, plus a fee that can be a percentage or a flat amount, plus commissions, plus room nights. In a spreadsheet you solve it with helper columns and nested IFs only their author understands. When that person is on holiday, you cross your fingers.
What you need: VAT per line, fee and commissions as proper fields, and margin always calculated before VAT.
4. Sharing with the client without showing margins
The classic: hide the cost and margin columns and send the file. Sooner or later someone unhides them. The alternative, copying by hand into a “client” sheet, doubles the work and creates another version that drifts out of sync.
What you need: a client document generated from the same budget, with no costs or margins, and a separate internal one.
5. Seating
A spreadsheet seating plan is a list of names per table. It works until you need to know whether table 12 fits next to the pillar, the client wants to move 30 people, catering asks for special meals per table and registration needs an alphabetical index. Every change is copied by hand into four documents.
What you need: tables on the real floor plan to scale, seating from a list, and exports for list by table, registration index and special meals from one place.
6. The live run of show
A spreadsheet run of show is perfect until 7pm on show day. Then the speaker is late, the cocktail runs long and the copy AV printed is already wrong. Nobody knows who confirmed what, or whether you are ahead or behind.
What you need: chained times that move on their own, a live mode with now and next, ticks with time and name, and separate links for the crew and the client.
7. Registration and the door
Generic form, export to a spreadsheet, clean duplicates, cross-check with the client’s list, pull dietary needs for the venue, print a door list. Every step is another copy of personal data travelling by email. And on the day, the printed list does not know who has already arrived.
What you need: form, emails, waitlist, dietary and allergen list, badges and check-in in one place, with data protection handled.
Spreadsheet vs event tool: quick comparison
| Task | Excel or spreadsheet | Event-specific tool |
|---|---|---|
| Quick estimate | Ideal | Fine |
| Budget with VAT per line, fee and margin | Possible, fragile | Ideal |
| Negotiation versions | Loose files | Versions inside the project |
| Client document without margins | Hidden-column risk | Generated separately |
| Seating for 100+ guests | Very manual | Plan to scale and auto-seat |
| Live run of show | Printed copy that expires | Live board with ticks |
| Registration and check-in | Several tools and copies | One flow |
| One-off data analysis | Ideal | Export to Excel and go |
What to ask of an event management tool
If you are comparing options, this is the list we would use. It applies to any tool:
- It understands events. Per-guest and fixed lines, staff, room nights, fee. If you have to bend a generic project tool, you are back to square one.
- It separates internal and client views for budget, run of show and seating.
- Sharing does not require accounts. Your client, your crew or the couple will not sign up for anything. A link, with a PIN if needed.
- Clear team permissions: view, comment or edit, and revoke whenever you like.
- It works on mobile, because nobody is at a desk on show day.
- It imports your spreadsheets: you are not retyping line items or guest lists.
- It exports to Excel and PDF: your data is yours and has to be able to leave.
- Backups outside the tool itself.
- Data protection for registration: consent boxes and a data processing agreement with the client.
- Fair price, no lock-in, so you can test it on a real event before deciding.
How Murphy OS handles it
Murphy OS was born from exactly those spreadsheets you dreaded opening. Each problem above has its app:
- Budget and versions: Planner covers income, per-guest costs, fixed costs, staff and extras, with VAT per line, fee and commissions. Totals, profit and margin update instantly. Duplicate versions to negotiate and export a client PDF without margins, an internal PDF and Excel. If your budget is already in a spreadsheet, import it (button or drag the file) and preview it before saving.
- Seating and floor plan: Scenes works on the venue plan calibrated to scale. Paste the list from a spreadsheet with group, meal and table, one button seats everyone, and you export the room plan, list by table, alphabetical index and special meals. The client can place guests from a link with no account.
- Live show: Run of show (Escaleta) chains times, pins the ones that cannot move and in Live mode shows now and next, with ticks per cue with time and name. The crew ticks from their phones and the client follows on their link. Import the agenda from Planner or paste a table from Excel or Google Sheets.
- Registration: Forms builds the landing page and form in the client’s branding, manages capacity and waitlist, sends the emails, produces the dietary and allergen list for the venue, prints badges and checks people in by QR from several phones.
Anything that is not live or shared can stay in your spreadsheet. Export whenever you need to.
Common mistakes when moving off spreadsheets
- Migrating everything at once. Start with one real event and one app, usually the budget.
- Copying your spreadsheet exactly. Use the move to drop columns nobody reads.
- Not walking the team through the new flow. If one person stays on the old sheet, you have two versions again.
- Forgetting the client. The change they notice most is the tracking link they receive.
- Expecting the tool to decide for you. Judgement is still yours: which line to cut, when to call plan B, who sits with whom.
What we would do tomorrow
- Open your last spreadsheet budget and count how many versions of the file are in the folder.
- Check the total by hand. If it does not add up, you know why you are reading this.
- Pick your next event with more than 80 guests and move only the budget into an event-specific tool. Import it from your spreadsheet instead of retyping.
- On that same event, try a live run of show with your crew. That is where the difference shows most.
- Keep Excel for what it does well: analysis, estimates and files other people send you.
Frequently asked questions
Can you run an event with just Excel?
Yes, especially if it is small, one person runs it and nothing needs sharing live. It gets hard with several budget versions, several people editing the file, seating for many guests or a show day that changes every five minutes.
What should event management software include?
A budget with VAT per line, fee and margin calculated automatically, versions, a client view without your costs, share links with no account, seating on a real floor plan, a live run of show, registration with check-in, and export to Excel and PDF.
Do I have to stop using Excel if I use event software?
No. Keep Excel for analysis and one-off calculations, and let the tool handle what gets shared and what changes live. A good tool imports and exports Excel without fuss.
What is the biggest risk of running events on spreadsheets?
Working from an outdated copy: the budget that was not the latest, yesterday's guest list or the run of show printed before the last change.
How much does event planning software cost?
It varies a lot. Murphy OS is €10.50 or US$12.50 a month with no minimum term and includes every app; Meteo Murphy is free for everyone.