What to Do With Old Leads Sitting in a Spreadsheet

Short answer

A spreadsheet of old leads is usually one of the most valuable assets in a solar business. The work isn''t complicated: clean the file, fill in a few required fields, segment by intent and age, then reach out with prior consent in mind. Most installers stall because the cleanup feels boring, not because they don''t know what to do.

Step 1 — Clean and prepare the spreadsheet

Before anything goes out, get the file into a usable state.

Required fields

At minimum, every row should have:

• Full name
• Phone (mobile, in valid Australian format)
• Email
• Original enquiry source (Facebook lead, website form, comparison site, referral, walk-in)
• Quote date
• Salesperson who originally owned the lead
• Status (quoted / not quoted / went cold / signed elsewhere)
• Notes (any context that might matter)

Cleanup checklist

• Remove duplicates by phone number, not by name.
• Normalise phone numbers to E.164 format (e.g. +61412345678).
• Drop rows with no phone AND no email — they can''t be contacted.
• Flag any obviously bad numbers (too short, all zeros, landlines if you''re sending SMS).
• Check against any internal opt-out list you have.
• Remove anyone who already signed with you — they belong in a customer campaign, not a reactivation one.

Step 2 — Segment by intent

A 1,000-row spreadsheet is not one audience. It''s usually 4–6 audiences mixed together. Splitting them makes outreach far more effective.

Reasonable segments for an Australian solar list:

• Hot quotes (0–3 months old, didn''t sign): still in market, price-sensitive.
• Warm quotes (3–9 months old): circumstances may have changed, battery rebate may apply.
• Cold quotes (9–24 months old): treat as a fresh conversation, reference original enquiry.
• Enquired but never quoted: missed handoff. Often the highest-yield segment because they never got a real answer.
• Existing solar customers: battery upsell only, never re-pitch solar.
• Unknown / no source: isolate, contact last, with extra-light messaging.

Step 3 — Compliance check (important)

This is where most spreadsheet reactivations get into trouble.

Only contact people where there is a legitimate basis:

• The person originally opted in (form, enquiry, quote request, signed agreement).
• The contact details belong to them, not a third party.
• The relationship is still reasonably fresh — purchased lists are not compliant.

Every message must:

• Identify your business clearly.
• Include a working opt-out (Reply STOP to opt out works for SMS).
• Be sent at a sensible hour (avoid before 9am and after 8pm local time).

If a row has no clear consent, leave it out. One complaint to ACMA is much more expensive than the bookings you''d have generated from those contacts.

Step 4 — Reach out with a short, useful message

Once the file is clean and segmented, send a short, plain-language SMS that references the original context. Avoid discounts on the first touch. Ask one specific question. Always include the opt-out.

A simple template for the cold segment:

Hey {first_name}, it''s {sender} from {company}. You looked at solar with us in {month_year}. Quick one — are you still considering it for {suburb}, or has the plan changed? Reply STOP to opt out.

Step 5 — Handle replies properly

This is where spreadsheets stop being enough. Reply handling needs:

• Real-time classification (interested / question / opt-out / wrong number).
• Immediate suppression of opt-outs.
• A booking link sent to interested replies before they cool off.
• A way to hand warm conversations to the right salesperson.

Where this breaks manually

Cleaning a file once, in a quiet week, is fine. The problems show up the moment you try to operate the spreadsheet as a live system:

• Dedupe drift: new exports re-introduce old duplicates because the CRM never got updated.
• Phone formatting: half the file is 0412…, half is +61412…, some have spaces, some have hyphens. Bulk SMS providers reject the bad ones silently.
• Opt-outs: STOP replies arrive into a personal phone, not a system. Some get actioned, some don''t. That''s a compliance risk.
• Status tracking: no one updates the spreadsheet after the campaign, so the next round contacts the same opt-outs again.
• Retry timing: day-4 and day-10 messages get skipped because nobody set the timer.
• Reporting: "how did the campaign go?" becomes a manual count of highlighted rows.

Every one of these is solvable once. None of them stay solved.

When to automate

If the spreadsheet is bigger than about 200 contacts, or if you plan to run reactivation more than once, the operational overhead usually costs more (in missed bookings and compliance risk) than the automation does.

This is exactly the work Digital Rush AI is built for. We import the file, normalise the data, segment it, run the messaging, suppress opt-outs in real time, book warm replies straight into your Cal.com calendar, and hand you a report per cohort at the end.

You keep the relationship with the customer. We just remove the operational gap between "we have a spreadsheet" and "we have bookings".

Soft next step

If you''d like a free database review, send us a sample of the file and we''ll tell you honestly how clean it is, how many contacts are likely still in-market, and whether reactivation is worth the effort.