Free dating spreadsheet template

Our free dating spreadsheet template is a CSV file that opens in Google Sheets, Excel or Numbers. It has one row per person and columns for the little things they tell you, from pets and plans to the next question to ask. If you’d prefer cards to cells, our free in-browser board does the same job and exports a spreadsheet.

Download the template

• Download the dating spreadsheet template (CSV)
• Or use the Who am I talking to? board. It gives you one card per person, runs in your browser, uploads nothing, and exports a spreadsheet whenever you want one.

Dating spreadsheets had a viral moment on TikTok in 2023, and popular versions included columns for rating how each date went (The List). The need behind them is older and gentler. One dater with a few chats on the go joked that they needed a spreadsheet just to keep everyone sorted (r/datingoverforty).

This template leaves the ratings out. It’s built to help you remember people, and every column holds something they told you.

What each column is for

Column	What goes in it	Example
Name	First name, plus a nickname if two people share it	Sam
App	Where you met	Hinge
Where they live	Suburb or area	Paddington
Work	Their job, and how they feel about it	Nurse, nights this month
Kids	Names and ages, if they’ve shared them	None
Pets	Names count	Kelpie called Biscuit
Likes	Food, music, places, hobbies	Thai food, live music, bouldering
Dislikes	Things to steer clear of	Coriander
Plans	Anything coming up, with a date	Byron trip, 14 Nov
Next question to ask	One question for next time	How was Byron?
Last talked	Date of your last chat	2026-10-24
Status	A plain word for where things are	Chatting
Notes	Anything else worth remembering	Has a twin brother, Leo

For Status, a few plain words are enough: Chatting, Planning a date, Seeing each other, Ended. It’s a reminder of where things stand, so leave grades and labels about the person out of it.

How to use it kindly

1. Write what they told you. Facts they shared, in plain words. Keep your opinions about them out of it.
2. Fill it in after you talk. Never during a chat or a date.
3. Lean on “Next question to ask”. It’s the column that makes the rest useful. A question about their sister’s wedding shows you listened.
4. Glance at “Last talked”. If it’s been a week, reply, or close the chat kindly.
5. Let rows go. When it ends, set Status to Ended or delete the row. Some daters keep old rows because people sometimes come back months later (r/datingoverfifty). That’s your call.
6. Keep it to yourself. A sheet listing several people is awkward if someone finds it. One commenter described finding a partner’s spreadsheet that listed him next to another man, and calling it creepy (r/datingoverfifty).

Here’s how it works in practice. Priya fills in a row for Sam after their first chat: Hinge, Paddington, nurse, kelpie called Biscuit. A week later, the Plans column reminds her Sam was off to Byron on the 14th. On the 15th she asks how it went.

How to open it in Google Sheets

1. Download the CSV.
2. Open Google Sheets on a computer and open a spreadsheet, or create a blank one.
3. Click File, then Import.
4. Select the CSV file.
5. Under import location, choose Create new spreadsheet or Insert new sheets.
6. Leave the separator type on Detect automatically.
7. Click Import.

These steps follow Google’s own help page. Once it’s in, click Share and check that General access is set to Restricted, which means only people with access can open it (Google Drive Help).

How to open it in Excel

1. Download the CSV.
2. In Excel, go to File > Open and choose the file. If you can’t see it, set the file type to Text Files.
3. To add it to a workbook you already have, click a cell, then go to Data > From Text/CSV, choose the file, click Import, then Load.
4. Save it as an Excel workbook (.xlsx). When you save as CSV, Excel warns that only the current sheet is saved, and some features may be lost (Microsoft Support).

How to open it in Numbers on iPhone

1. Save the CSV to the Files app.
2. Open Numbers. In the document manager, tap Browse, find the file, then tap its thumbnail.
3. If the columns look wrong, tap the table, tap the Format button, then Table > Adjust Settings. On the Delimited tab, choose the comma.
4. Do any fixing before you start editing. Numbers won’t let you change import settings after you edit the imported table (Apple Support).

How to keep your dating spreadsheet private

A CSV is a plain text file, so it has no lock of its own. Import it, save it in your app’s own format, then delete the downloaded copy.

• Numbers on iPhone: open the sheet, tap the More button, then Set Password. Adding a password encrypts the file, and you can then open it with Face ID (Apple Support).
• Excel: go to File > Info > Protect Workbook > Encrypt with Password. Pick one you’ll remember, because Microsoft can’t recover a forgotten password (Microsoft Support).
• Google Sheets: keep General access on Restricted, and check the share list before you add anything personal (Google Drive Help).

A few habits help too:

• Give the file a plain name. “Notes” draws less attention than “Dating”.
• Skip surnames, numbers and photos. The template has no columns for them on purpose.
• Tidy as you go. Delete rows for people you’ve both moved on from.

When a spreadsheet stops working

On a phone, typing is the hard part. If rows are going stale, try a lighter habit: three facts and one question per person, written straight after the chat. Our guides to keeping track of dating app matches and remembering what someone tells you cover that in more detail.

Where Fond fits

Fond is an iPhone app for when typing rows gets old. Share a screenshot of a chat or profile to Fond, and it fills in a private note about that person on your iPhone: likes, dislikes, work, family, pets, plans and things to ask next time. Every fact links back to the screenshot it came from. There’s no account and no servers, the AI runs on the phone, and notes are locked with Face ID and kept out of iCloud backup. It’s free for up to 3 people. Get Fond on the App Store, or read how Fond handles privacy.