Dating can get confusing — this makes it fun and clear. This dating spreadsheet lets you log every date, score it on five things that matter to you, note green and red flags, and see an automatic Top 5 of the people you’ve met.
Who this template is for
- Singles using dating apps
- Friends comparing notes
- Anyone who loves a good spreadsheet
Features
- Date log (200 lines): date, name or nickname, where you met, what you did and “see again?”.
- 5-point scorecard: rate conversation, humor, chemistry, kindness and shared interests from 1 to 5 — or rename the criteria to your own.
- Overall score and heart rating (♥♥♥♥♡) calculated for every date, with a color heat map.
- Green flags and red flags columns.
- Top 5 ranking by each person’s best date, updated automatically.
- Where you met, average score by place, criteria averages and a chart. No macros.
How to use it
- Download the file and open it in Google Sheets or Excel.
- Rename the criteria if you like.
- After each date, add a line and score it.
- Check your Top 5 on the Scorecard.
What’s included
- 1 .xlsx file with 3 tabs: Start Here, Scorecard and Date Log.
- Example dates (clear them to start fresh).
Compatibility
Works in Google Sheets and Microsoft Excel (desktop, Mac and online). No add-ons or macros — and your data stays in your own private file.
FAQ
Can I change what I score?
Yes. Rename the five criteria on the Scorecard and the log updates.
How is the Top 5 ranked?
By each person’s highest date score.
Is it a gift idea?
It’s a popular fun gift for single friends — just share the download.
Does it work in the free version of Google Sheets?
Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. A free Google account is all you need.
Can I use it on a Mac, iPad or phone?
Yes. It works in Excel for Mac and Windows, Excel online and the Google Sheets app. For editing, a computer or tablet is the most comfortable.
How do I get the file?
Right after checkout you get a download link on the confirmation page and by email.
More templates like this: Life & Event Planners.
This is a digital product. No physical item will be shipped.
Reviews
There are no reviews yet.