The Dating Events Dashboard in Excel is a five-page reporting workbook for people who run speed dating nights, singles mixers, matchmaking dinners and virtual meetups as a business. It ships with 500 sample event records spanning 1 January to 28 December 2025, 30 data columns, 26 pivot tables, 20 charts and 4 synced slicers (Month, Event Type, City, Region) that filter every page at once. Open it, paste your own event log over the sample rows, hit Refresh All, and you have ticket revenue, seat fill, cost and match-outcome reporting without a subscription. Instant download, no macros, no add-ins, and it works in Excel 2016 or later and Microsoft 365 on Windows and Mac.
Key Features of the Dating Events Dashboard in Excel
- Five KPI cards on the Overview page – Total Ticket Revenue, Total Attendees, Total Events, Total Matches Made and Net Event Profit, all recalculating against whatever the slicers are set to.
- A Seat Fill % gauge that reads 65.0% on the sample data (21,192 attendees against 32,592 seats offered), so under-filling is visible before you look at a single chart.
- Six event types built into the model – Speed Dating, Singles Mixer, Themed Party, Matchmaking Dinner, Outdoor Social and Virtual Meetup – each with its own revenue, seat fill and satisfaction reading.
- Nine venue types from Rooftop Lounge and Cocktail Bar through to Online Platform, ranked by ticket revenue on the Type Analysis page.
- Eight cities across three regions (Europe, North America, Asia Pacific) with revenue-versus-cost bars, event counts and regional profit.
- A dedicated Match Outcomes page reporting matches made, second dates confirmed, match success rate by event type, and second dates by attendance band.
- Cost and profit columns, not just revenue – Event Cost and Marketing Spend sit alongside Ticket Revenue, so Net Event Profit is a real number ($208,165 on the sample year against $932,486 of revenue).
- A clean 30-column source table named TblData, so pasted rows extend the pivot range automatically.
- Age band and attendance band segmentation – 21-29, 30-39, 40-49 and 50+, plus Intimate, Medium and Large room sizes.
- No macros and no external connections – a plain .xlsx that opens without a security prompt and can go straight into a shared drive.
What’s Inside the Dating Events Dashboard in Excel
The download is a single ZIP containing Dating Events Dashboard in Excel.xlsx and an Excel Dashboard – User Manual.pdf. The workbook holds seven sheets: five dashboard pages, the Data sheet and a Support sheet that carries the pivot output the charts read from.
- Overview – the five KPI cards, the Seat Fill % gauge, Total Ticket Revenue by Event Type, Total Attendees by City and Total Events by Event Status (244 Completed, 157 Under-Filled, 45 Sold Out, 27 Cancelled, 27 Postponed on the sample data).
- Event Trend – Ticket Revenue vs Net Event Profit by Quarter, Total Events by Month, Attendees vs Seats Offered by Month, and Total Ticket Revenue by Age Group.
- Type Analysis – Total Attendees vs Seats Offered by Event Type, Avg. Satisfaction by Event Type as a star rating, Seat Fill % by Event Type, and Total Ticket Revenue by Venue Type.
- City Analysis – Total Ticket Revenue vs Event Cost by City, Total Events by City, Total Attendees by Region and Net Event Profit by Region.
- Match Outcomes – Total Matches Made vs Second Dates by Age Group, Total Matches Made by Host, Match Success % by Event Type and Total Second Dates by Attendance Band.
- Data – the TblData table, rows 4 to 503, with Event ID, Date, Event Name, Event Type, Venue Type, City, Region, Host, Age Group, Event Status, Seats Offered, Registrations, Attendees, Matches Made, Second Dates Confirmed, New Members, Ticket Revenue, Event Cost, Marketing Spend, Satisfaction Score, Month, Year, Quarter, five status counters and Attendance Band.
Dating Events Dashboard in Excel vs. Google Sheets vs. Paid Event SaaS – Where This Fits
| This Excel dashboard | A Google Sheets build | Eventbrite Pro / Meetup Pro tier | |
|---|---|---|---|
| Cost | One payment, yours permanently | Free tool, your build time | Monthly fee plus per-ticket cut |
| Platform | Excel 2016+, Microsoft 365, Windows and Mac | Browser | Browser and mobile app |
| Setup time | Paste your event log, Refresh All | Days of chart building | Account setup, then live only |
| Real-time team collaboration | Via OneDrive or SharePoint co-authoring | Yes, natively | Yes |
| Mobile access | Excel mobile, view-focused | Yes | Yes |
| Customisable fields | All 30 columns are yours to rename | Yes | Fixed schema |
| Share with a link | Via cloud storage | Yes | Yes |
| Year-1 cost at 5 users | The one-off price on this page | Your build hours | Recurring, and it grows with volume |
| Match and second-date reporting | Built in, on its own page | You would build it | Not offered – ticketing tools stop at attendance |
| Works offline on last year’s data | Yes | No | No |
Who This Template Is For – and Who It’s Not For
It fits speed dating organisers running a monthly circuit across several cities, matchmaking businesses that host paid dinners, singles-events companies with a venue mix, community and social clubs that charge admission, and anyone already keeping an event log in a spreadsheet who wants it read back as a dashboard.
It is not for you if you want a ticketing engine – it does not sell tickets, take payments or run a registration form. It is not a CRM or an attendee database, and it holds no attendee names, emails or phone numbers; the sample rows are event-level totals plus fictional host names. It does not connect to Eventbrite, Meetup or any booking platform, so numbers arrive by paste or export, not by sync. And it contains no matchmaking logic: Matches Made and Second Dates Confirmed are figures you record after the night, not something the workbook predicts or scores. If you do add personal data of your own to the Data sheet, handling it lawfully under GDPR, UK GDPR, CCPA or your local equivalent remains your responsibility.
How to Use the Dating Events Dashboard in Excel
- Unzip the download and open Dating Events Dashboard in Excel.xlsx. No macro prompt appears – there are none.
- Read the five pages against the sample year first so you can see what each chart is meant to answer.
- Go to the Data sheet and replace rows 4 to 503 with your own events, one row per event. Keep the 30 headers in row 3 as they are, or rename them and update the chart titles to match.
- Fill Month, Year and Quarter to match each Date, and set the five status counter columns to 1/0 – those columns feed the Event Status chart.
- Press Ctrl+Alt+F5 (Data > Refresh All). The workbook has no auto-refresh, so this step is not optional after a paste.
- Use the Month, Event Type, City and Region slicers on any page to narrow the whole report; clear them with the filter icon in each slicer header.
- Save a dated copy per quarter if you want a history – the workbook reports the rows currently in the table, it does not archive them.
Real-World Use Cases
Priya runs a speed dating circuit in four cities. Her Seat Fill % by Event Type chart shows Speed Dating filling only 60.5% of seats against Matchmaking Dinner at 69.5%, so she cuts room size on the speed nights rather than dropping the price, and the Net Event Profit card moves.
Marcus hosts themed parties and wants to know which venue actually pays. Total Ticket Revenue by Venue Type ranks Rooftop Lounge at $236.2K against Beach Club at $46.8K on his log, and the City Analysis page shows revenue next to event cost city by city, so he renegotiates two venue contracts before booking the next season.
Amelia manages a matchmaking business and reports to investors. The Match Outcomes page gives her matches made by host, second dates by room size and match success rate by format in one screenshot, which is the slide her quarterly deck needed and her ticketing platform never produced.
Frequently Asked Questions
Does this dashboard make matches or score compatibility?
No. There is no matching algorithm anywhere in the file. Matches Made and Second Dates Confirmed are counts you enter yourself after an event, and every chart on the Match Outcomes page simply aggregates those numbers.
Does it store attendee personal data?
Not as shipped. Each row is one event with totals – seats, registrations, attendees, revenue, cost – plus an event name, a city and a host name. There is no column for an attendee’s name, email or phone number. If you add one, that data becomes your responsibility under your own privacy obligations.
Do I need macros or any add-in?
No. It is a plain .xlsx built on pivot tables, slicers and standard charts. Nothing to enable, nothing to install.
Which Excel versions does it work in?
Excel 2016 and later, plus Microsoft 365, on Windows and Mac. Slicers need the desktop app; Excel for the web will display the pages but slicer behaviour is limited. Microsoft’s own guide to slicers covers the basics if they are new to you.
Will the charts update when I add more than 500 events?
Yes. The source range is an Excel table, so pasting below the last row extends it. Run Refresh All afterwards and every pivot and chart picks up the new rows.
Can I change the event types, cities or venues?
Yes – they are values in the data, not hard-coded lists. Type your own and refresh. Chart titles are text you can edit, so a “Singles Mixer” business and a “Corporate Networking” business can both use the same file.
Is the sample data real?
No. The 500 rows are realistic fictional records for a 2025 calendar year, there so you can see the dashboard working before your own numbers go in.
About the Author
Built by PK – Microsoft Certified Professional with 15+ years of Excel, Google Sheets, and Power BI experience. Founder of NextGenTemplates, reaching 300K+ subscribers across YouTube channels. Every template is hand-built and tested before release.
Explore Related Templates
If you run more than one kind of paid night, the same five-page structure exists for neighbouring venues: Nightclubs Dashboard in Excel for door and bar revenue, Music Festivals Dashboard in Excel for multi-day ticketed events, Private Clubs Dashboard in Excel for membership-led venues and Micro Breweries Pubs Dashboard in Excel for taproom events. If your bookings live in Google Sheets instead, the Banquet Hall Tracker in Google Sheets covers the venue side, and Concert Promoters Dashboard in Power BI is the Power BI equivalent for promoters. Browse the full Excel Dashboard category or everything under MS Excel.
Download the Dating Events Dashboard in Excel now and turn your event log into a report you can show a venue, a partner or an investor. Instant download, lifetime access, free bug fixes to this file.
Last updated: 29 August 2026.
Reviews
There are no reviews yet.