CRM Nahi Use Karte? Yeh Excel Hack Karo Pehle

“Bhai yaar, kaunse lead ka kya status tha?” “Wo Gurgaon wali lead — unka number kahan save kiya tha?” “Is mahine kitne site visits hue total?”

Agar yeh sawaal tumhare saath regularly hote hain — tumhare paas lead management ka koi system nahi hai. Aur iss wajah se tum deals miss kar rahe ho daily.

Problem: CRM software expensive lagta hai aur complex. Salesforce, HubSpot — sab 2000-5000 rupye per month.

Solution: Google Sheets mein ek solid system banao — free mein, phone se access karo, aaj se start karo.

Yeh sirf spreadsheet nahi hai — yeh tumhara virtual office assistant hai.

---

Kyun Google Sheets — Excel Pe Advantages

Feature	Google Sheets	Excel (Local)
Cost	Free	MS Office subscription
Phone access	Haan, app se	Limited
Real-time update	Instant	Manual save
Sharing	Link share karo	File bhejna padta
Google Forms link	Automatic lead capture	Manual entry
Backup	Automatic cloud	Manual
Collaboration	Multiple editors	Version issues

Clear winner hai Google Sheets — especially solo broker ya small team ke liye.

---

Step 1 — Google Sheet Create Karo

Google.com/sheets pe jao → New Sheet → “Lead CRM 2026” naam do

Ab yeh exact columns create karo (Row 1 mein):

A: ID | B: Name | C: Phone | D: Source | E: Area | F: Config |
G: Budget (L) | H: Status | I: Last Contact | J: Next Follow-up |
K: Notes | L: Site Visit | M: Booked? | N: Commission (Rs)

Column-by-Column Explanation:

A — ID: Sequential number. Lead 001, 002, 003. Simple tracking ke liye.

B — Name: Full name. “Rahul” nahi — “Rahul Sharma” likho. Call pe name dhundna easy ho.

C — Phone: Primary number. +91 ke saath format. Multiple numbers: C aur D column use karo.

D — Source: Kahan se lead aaya:

• MagicBricks, 99acres, Housing.com
• Meta Ads, Google Ads
• Referral (kiske se — naam bhi likho)
• Walk-in, Cold call, YouTube, Instagram

E — Area: Specific area preference. “Noida” nahi — “Noida Sector 137” better.

F — Config: 1BHK / 2BHK / 3BHK / Plot / Commercial.

G — Budget (L): Number only — likhna: 55 (matlab 55 lakh). Filtering easy ho jaaye.

H — Status: Yeh sabse important column hai. Options:

• Hot — Site visit ready, decision making
• Warm — Interested, follow-up chal raha
• Cold — Inactive, 2+ weeks no response
• Site Visit Done — Aaye the, karar nahi
• Negotiation — Pricing discuss chal raha
• Booked — Deal done!
• Lost — Competitor se book kiya ya interest khatam

I — Last Contact: Date of last meaningful interaction. dd/mm/yyyy format.

J — Next Follow-up: Tumhara next action date. Yeh column sort karke daily task list banao.

K — Notes: Free text. Keewhat to remember about this person:

• “Wife ki pasand ka puchhna hai”
• “Metro distance important hai unhe”
• “Budget thoda stretch kar sakte — max 60L”

L — Site Visit: Date of site visit, ya “Pending”, ya “Refused”.

M — Booked?: Yes/No/Lost.

N — Commission (Rs): Expected ya actual commission amount. Financial tracking ke liye.

---

Step 2 — Conditional Formatting (Colors!)

Yeh Google Sheets ki superpower hai. Status column ko color-coded banao taaki ek nazar mein sab dikhey.

Setting up conditional formatting:

1. Column H select karo (Status column)
2. Format → Conditional Formatting
3. Rules add karo:

Text Contains	Background Color	Text Color	Meaning
”Hot”	Red (#FF0000)	White	Urgent — aaj karo
”Warm”	Orange (#FF9800)	White	This week follow
”Cold”	Blue (#2196F3)	White	Monthly check
”Booked”	Green (#4CAF50)	White	Done!
”Lost”	Grey (#9E9E9E)	White	Archive
”Negotiation”	Yellow (#FFEB3B)	Black	Active
”Site Visit Done”	Purple (#9C27B0)	White	Follow needed

Result: Sheet open karo — red cells = aaj immediate action. Zero mental effort.

---

Step 3 — Google Forms Integration (Lead Auto-Capture)

Yeh game-changer hai. Manually data entry nahi karni padegi.

Ab kya hoga: Koi bhi form bhare → Automatic Google Sheet mein entry → Phone pe notification.

Manual entry bhi karo: Website inquiry ya phone call wale leads manually add karo — 30 seconds ka kaam.

---

Step 4 — Mobile View Setup

Google Sheets mobile app phone pe best kaam karta hai agar theek se set karo.

Mobile-friendly tips:

Column width: A, B, C, H, J — yeh columns phone screen pe dikhne chahiye. Baki scroll hoti rahein.

Freeze rows: Row 1 (headers) freeze karo: View → Freeze → 1 Row Ab scroll karo toh bhi header dikhta rahega.

Filter view create karo:

• “Hot Leads Today” filter: Status = Hot
• “Follow-up Today” filter: Next Follow-up = TODAY()
• “Site Visit Pending” filter: Site Visit = Pending

Shortcut: Phone pe filter save karo — ek tap mein relevant leads dikho.

---

Step 5 — Daily Workflow Integration

Google Sheets ko daily routine mein kaise use karein:

Morning Routine (10 min):

1. Sheet kholo
2. "Next Follow-up" column sort karo by today's date
3. Yeh hai aaj ki priority list
4. Hot leads pehle, phir Warm, phir Cold
5. Status update karo har contact ke baad

After Every Lead Interaction:

Immediately update karo:
- Last Contact = aaj ki date
- Notes = kya baat hui (30 word summary)
- Status = update karo (Hot/Warm/Cold)
- Next Follow-up = kab contact karein

---

Advanced Formulas — Optional But Powerful

Formula 1: Days Since Last Contact

Column add karo “Days Idle”:

=TODAY() - I2

Iska format: Number. Agar 7 se zyada — follow-up overdue hai.

Formula 2: Monthly Revenue Tracking

=SUMIF(M:M, "Yes", N:N)

Total commission from booked deals — automatically calculate.

Formula 3: Source Performance

=COUNTIF(D:D, "MagicBricks")

Har source se kitne leads — manually check karo conversion.

Formula 4: Hot Leads Count

=COUNTIF(H:H, "Hot")

Dashboard pe dikhao — kitne active hot leads hain.

---

Dashboard Tab — One-Page Overview

Sheet mein ek alag tab banao: “Dashboard”

Dashboard mein yeh numbers rakho:

Metric	Formula
Total leads this month	=COUNTA(Sheet1!B:B)-1
Hot leads	=COUNTIF(Sheet1!H:H,"Hot")
Site visits done	=COUNTIF(Sheet1!L:L,">"&DATE(2026,2,1))
Deals closed	=COUNTIF(Sheet1!M:M,"Yes")
Total commission earned	=SUMIF(Sheet1!M:M,"Yes",Sheet1!N:N)
Best lead source	Manual check

Weekly: 10 minutes mein pata chal jaata hai business kaisa chal raha hai.

---

Lead Source Tracking — Within The Sheet

Source column (D) ko properly use karo:

Detailed source tracking:

MagicBricks-Organic
MagicBricks-Paid
99acres-Organic
99acres-Featured
Meta-Ads-Noida
Meta-Ads-Gurgaon
Google-Ads
Referral-Ravi Gupta
Referral-Priya Shah
Walk-in-Office
Instagram-Story
YouTube-Video

Monthly analysis: D column filter karo source-wise, count karo leads aur conversions.

Example findings:

• MagicBricks: 30 leads, 2 deals = 6.6% conversion
• Referral: 8 leads, 3 deals = 37.5% conversion
• Meta Ads: 45 leads, 1 deal = 2.2% conversion

Decision: Referral pe zyada invest karo. Meta Ads campaign review karo.

---

Sharing With Team — Collaborative CRM

Agar tum ek partner ke saath kaam karte ho:

Share settings:

• File → Share → Add partner’s email
• Permission: Editor (update kar sake)

Kab use karo:

• Ek broker site visits karta hai, doosra calls
• Both ko same data chahiye real-time

Color-coding for team:

• Column add karo “Assigned To” — partner vs tumhara
• Different colors by owner

---

When To Upgrade To Real CRM

Google Sheets kaafi hai until:

Signal	Matlab
300+ active leads	Sheets slow hone lagti hai
3+ team members	Collaboration complex hoti hai
Multiple cities/projects	Organization difficult
Automated emails needed	Sheets nahi kar sakti
Advanced reporting needed	Manual hota hai

Toh upgrade karo to: Zoho CRM (free tier 3 users tak), PropertyPulse, or Sell.Do — India-focused real estate CRMs.

But pehle Sheets pe system banana seekho — phir CRM easy lagega.

---

Quick Setup Checklist

[ ] Google Sheet create kiya — naam diya
[ ] 14 columns setup kiye (A se N)
[ ] Row 1 frozen (header)
[ ] Conditional formatting set kiya (colors)
[ ] Sample data enter kiya (5 test leads)
[ ] Google Forms linked kiya
[ ] Mobile app download kiya
[ ] Filter views create kiye:
    [ ] Hot leads today
    [ ] Follow-up today
    [ ] This week's site visits
[ ] Dashboard tab banaya

Estimated setup time: 45-60 minutes. One-time effort.

---

Template Download Alternative

Agar khud banana nahi chahte — yeh columns copy karo Google Sheet mein:

ID | Name | Phone | Alternate | Email | Source | Area | Config | Budget(L) | Status | Last Contact | Next FU | Visit Date | Notes | Booked | Commission

Row 2 se data start karo. Save as template — duplicate karo every month (fresh sheet per month).

---

MZZI Digital broker teams ke liye customized CRM templates, lead tracking dashboards aur automation systems design karta hai. Agar tum ready-made solution chahte ho — yahan se start karo aur hum aapke liye proper system set up karenge.