How to Build a Personal CRM With No Code (Free Template)
Build a personal CRM in a spreadsheet in an afternoon. Copy the template, use the AI prompts, and set a weekly routine to keep your network warm.
For Recruiting, Sales and Managers

What is a personal CRM?
A personal CRM is a private system for tracking the people you know: who they are, how you met, what you talked about, when you last spoke, and when you should reach out next. It works like a sales CRM, but the "pipeline" is your network and nobody else sees it. You can build one with a spreadsheet, Notion or Airtable in an afternoon, with no code. The value is not the tool. It is the reminder that tells you who to contact this week.
TL;DR
- A personal CRM is a list of people with a next-touch date. If your list has no date column that triggers action, it is just an address book.
- You can build a working one in a spreadsheet in an afternoon, and the template below is ready to copy.
- Track fewer fields than you think you need. Last contact, next touch, open loop and one personal note do most of the work.
- AI is useful for cleaning your import, turning messy notes into rows, and drafting follow-ups. It should never invent facts about a person or send anything for you.
- Keep work data (candidates, customers, client contacts) in your company's approved systems. Your personal CRM is for relationships that belong to you.
- A 15-minute weekly review matters more than any feature. Most personal CRMs die because nobody opens them.
Who actually needs a personal CRM?
Anyone whose career depends on people remembering them and being willing to help. That covers more roles than you would guess.
- Recruiters keep in touch with silver-medalist candidates, past hires and referrers, long after a requisition closes.
- Salespeople and account managers track champions who change jobs, former customers and warm introductions.
- Managers track skip-level conversations, mentors, people they have promised to sponsor, and former teammates who are now at other companies.
- Marketers keep a bench of freelancers, agency contacts, speakers and peers they trade ideas with.
- Anyone job-hunting or planning to someday wants a network that does not have to be rebuilt from cold on the day they need it.
The common pattern: you meet far more people than you can remember, and the relationships that pay off are the ones you kept warm before you needed them.
Should you build a personal CRM or buy one?
Both are reasonable. Dedicated personal CRM apps exist, and some connect to your email, calendar and LinkedIn to fill in details automatically. Check each one's current pricing and privacy terms before you hand over your contacts, since both change often.
Building your own makes sense when:
- You want to decide exactly which fields matter for your work.
- You do not want a third party reading your email or syncing your contacts.
- You want to learn what you actually need before paying for anything.
- You plan to turn this into a team tool later (more on that at the end).
Buying makes sense when you have thousands of contacts, you want automatic enrichment, and you will not maintain a spreadsheet. A fair test: build the spreadsheet version first and use it for a month. If you keep opening it, you know what to look for in a paid tool. If you stop, no feature list would have saved you.
What should a personal CRM track?
Fewer fields than most templates suggest. Every column is a chore you have to maintain, so each one must earn its place. Here is the set that works.
| Field | Why it exists |
|---|---|
| Name | Obvious, but keep first and last in one column so sorting stays simple |
| Company and role | Lets you spot job changes and see who works where |
| How we met | The story you will forget in a year |
| Tier (A, B, C) | Decides how often you should reach out |
| Last contact | The date of your last real conversation |
| Cadence (days) | How many days between touches for that tier |
| Next touch | Calculated: last contact plus cadence |
| Open loop | Something you owe them, they owe you, or you promised to follow up on |
| Personal note | One thing about them as a person: a hobby, a kid's name, a marathon |
| Link | Their LinkedIn or email, so you can act in one click |
Tiers keep this honest. A reasonable starting point:
- A (close ties, mentors, key clients, sponsors): every 30 to 45 days.
- B (good professional relationships): every 90 days.
- C (weak ties, people worth not losing): every 180 days.
These are starting values, not science. Adjust them after a month of real use.
The template: copy this
Create a Google Sheet or Excel file with these headers in row 1, in this order:
A: Name
B: Company
C: Role
D: How we met
E: Tier
F: Last contact
G: Cadence (days)
H: Next touch
I: Open loop
J: Personal note
K: Link
Then set up three things:
- Next touch formula. In H2, enter
=F2+G2and fill it down the column. - Cadence from tier. In G2, enter
=IF(E2="A",45,IF(E2="B",90,180))and fill it down. Now changing a tier changes the schedule automatically. - Highlight what is due. Add conditional formatting to column H with the custom formula
=$H2<=TODAY(), and give it a bright fill. Anything due today or overdue lights up.
Add a filter on the header row so you can sort by Next touch with the oldest date at the top. That sorted view is your weekly to-do list.
If you prefer Notion or Airtable, the same ten fields work as a database. Use a Date property for Last contact, a Select for Tier and a formula property for Next touch. The logic is identical.
How do you build it step by step?
- Set up the sheet with the headers and formulas above. Ten minutes.
- Export your starting list. Pull contacts from your phone, Google Contacts, or the LinkedIn data export (LinkedIn lets you request a copy of your connections in your account settings). Do not import everything. You want the 50 to 150 people who matter, not 2,000 names.
- Pick your first 50. Scan your list and mark people you would be glad to hear from or would be glad to help. Delete the rest from this sheet. You can add more later.
- Assign tiers. Go fast. Gut feel is fine. Aim for roughly 10 A's, 25 B's and the rest C's so the weekly load stays manageable.
- Fill in Last contact with your best guess. Check your email or messages for the real date only for the A's.
- Add an open loop and a personal note for every A and B. This is the step people skip, and it is what makes the later message feel human instead of mechanical.
- Schedule the review. Put a recurring 15-minute block on your calendar, same day each week. Friday afternoon or Monday morning both work.
- Run the first review. Sort by Next touch. Contact the five most overdue people. Update Last contact as you go.
That is the entire system. The tool is a list; the habit is the review.
What does a filled-in row look like?
Here are three fictional examples, to show the level of detail that is useful.
| Name | Company | Role | How we met | Tier | Last contact | Cadence | Next touch | Open loop | Personal note |
|---|---|---|---|---|---|---|---|---|---|
| Dana Whitfield | Brightline Health | Director of Ops | Panel at a conference, 2023 | A | 2025-02-03 | 45 | 2025-03-20 | I promised to send my vendor scorecard | Training for her first half marathon |
| Marcus Oyelaran | Self-employed | Freelance designer | Referred by a coworker | B | 2024-12-10 | 90 | 2025-03-10 | He owes me a portfolio link | Moving to Lisbon in the spring |
| Priya Raman | Former team, now at a bank | Senior analyst | Worked together for two years | C | 2024-09-01 | 180 | 2025-02-28 | None | Just had a second child |
Notice what is missing: long notes, deal values, lead scores. A relationship does not need a funnel. It needs a prompt that reminds you what to say.
How can AI help build and run it?
AI is good at three jobs here: tidying messy input, turning notes into structure, and drafting a first version of a message. It is not good at knowing things about your contacts, so you supply the facts and it handles the wording.
Prompt 1: Clean up and map your import
Use this when you have a messy export. Remove anything you do not need, such as phone numbers, before pasting.
I'm building a personal CRM in a spreadsheet. Below is a list of contacts
I exported. Convert it into rows with these columns, separated by tabs so
I can paste into a spreadsheet: Name, Company, Role, Link.
Rules:
- Do not guess or fill in any information that is not in the data.
- If a field is missing, leave it blank.
- Flag any row where the name or company looks ambiguous.
Data:
[paste your list here]
Check: scan for rows where the model "helpfully" filled in a company or title that was not in your data. Blanks are correct. Invented details are not.
Prompt 2: Turn messy notes into a row
Use this right after a coffee or call.
Here are my rough notes from a conversation. Extract:
1. Open loop: anything I or they promised to do
2. Personal note: one personal detail worth remembering
3. Suggested tier (A, B or C) with a one-line reason
4. A draft follow-up message of 3 sentences or fewer, in a warm, plain tone
Use only what is in the notes. Do not add facts.
Notes:
[paste notes]
Check: that the open loop names the right person as the one who owes the action, and that the draft does not mention anything you did not say.
Prompt 3: Draft messages for the weekly review
Paste the rows that are due, not your whole sheet.
Below are the people I should contact this week. For each, write a short
message (2 to 4 sentences) that:
- references the open loop if there is one
- mentions the personal note naturally, only if it fits
- does not ask for anything unless the open loop says I owe or need something
- sounds like a person, not a template
Do not invent news about them or their company.
People:
[paste due rows]
Check: read every draft aloud. If it sounds like a greeting card, cut it in half. Then send it yourself.
Where AI should not be trusted
- Facts about people. Do not ask a chatbot "what's new with Dana at Brightline?" and use the answer. It may be out of date or wrong, and a confident wrong detail in a message is worse than no detail.
- Automatic sending. A message you did not read is a message that can embarrass you.
- Enrichment from scraping. Pulling data on people from around the web raises privacy and terms-of-service problems. Stick to what you know firsthand.
What about privacy and your employer?
Two points deserve care.
First, your contacts are other people's personal data. Keep your sheet in an account you control, with a strong password and two-step sign-in. Paste into an AI tool only what you need, and check the tool's data settings first. If your company has an approved AI tool, use that for anything touching work relationships.
Second, know whose data it is. Candidate records, customer lists and client contacts you gained through your job usually belong to your employer and often belong in the company's own system (an applicant tracking system or sales CRM). Your personal CRM is for relationships that are yours: mentors, former colleagues, peers, people you met at events. When in doubt, record the person and the relationship, and leave the confidential business detail in the company system. Check your employment agreement and data policy if you are unsure.
How do you keep a personal CRM alive?
Most fail in the first month. These habits help.
- Make the review small. Fifteen minutes, five messages, done. If it takes an hour you will skip it.
- Update right after each interaction. Thirty seconds of logging beats an hour of reconstruction.
- Reach out with a reason. Congratulate a promotion, share an article they would care about, make an introduction. "Just checking in" is the weakest version.
- Prune quarterly. Move people who never respond down a tier or off the list. A smaller, accurate list beats a large, stale one.
- Give before you ask. A personal CRM that is only opened when you need a job or a sale will feel like it.
How does a personal CRM lead to a tool at work?
Once you have used your own for a month, you will know exactly what a team version needs. A recruiting team might want a shared "alumni and silver medalists" list with a next-touch owner. A sales team might want champion tracking with job-change alerts. A manager might want a simple mentoring and skip-level tracker for their department.
The spreadsheet gives you something better than a feature wish list: a working design. You know which fields you used, which you ignored, and what reminder cadence fit your life. That is the brief for a team tool, and it is far easier to pitch internally than "we should get a CRM for relationships."
What if you want it as a real app instead of a spreadsheet?
A spreadsheet is enough to start, but it has limits: no real reminders by email, no clean mobile view, no sign-in for a teammate. If you outgrow it, you can describe the same ten fields and the weekly review to Remy in plain English and have it build a full-stack app with a database, sign-in and a live URL. Reminders could run as scheduled jobs. Remy works from a spec, you own the code in a git repo, and the platform is $99 a month (or $79 billed annually) with a 30-day free trial, plus AI usage billed at cost. Try the spreadsheet first, though. Remy is worth it only if you have proven you will use the system.
Frequently Asked Questions
Is a personal CRM the same as a sales CRM?
No. A sales CRM tracks deals, stages and revenue for a company, and managers see it. A personal CRM tracks relationships for you alone, with no funnel. The mechanics overlap (contacts, dates, notes), but the purpose is different: staying in touch, not closing.
What is the best free personal CRM?
For most people, a Google Sheet or Excel file with the template above. It costs nothing, you control the data, and you can move it to Notion or Airtable later. If you want automatic syncing with email and calendar, look at the dedicated apps and compare their current pricing and privacy terms yourself.
How many contacts should I put in my personal CRM?
Start with 50 to 150 people you would genuinely want to keep in touch with. A short, maintained list beats a huge, stale one. Add people as you meet them and drop those who no longer fit.
Can I use ChatGPT or another AI to run my personal CRM?
Yes, for cleaning data, structuring notes and drafting messages. Give it only the information you need, never let it invent details about a person, and read every message before you send it. Use your company's approved AI tool for anything related to work contacts.
Does it feel fake to use a system to keep in touch?
Only if the messages are generic. The system decides when to reach out. You still decide what to say, and the open loop and personal note are there so you can say something real. Most people find it makes them more attentive, not less.
How we source, write, and correct our articles. Editorial standards
Related articles

How to Write a Budget Request: Template and Example

How to Make a Presentation with AI in 20 Minutes

Meal Prep Plan for a Busy Week: Build One with AI in 5 Minutes
