Migrating From Spreadsheets to a Roofing CRM: The 30-Day Playbook
It's Tuesday. A storm hit three counties over the weekend. You're at your desk with three spreadsheets open , one with lead contacts, another with active jobs with colors your office manager invented, a third with commissions nobody has updated in nine days. A rep texts asking whether a homeowner on Elm Street has been contacted yet. You search Gmail, find nothing, tell him to knock it. That night the homeowner calls, annoyed, because a different rep was already there on Saturday.
This is the wall. Spreadsheets worked fine at two reps. At six during a storm, they're a liability. This guide is the 30-day playbook to migrate your spreadsheet to a CRM without blowing up operations. If you haven't picked a tool yet, start with our CRM buyer's guide.
Signs You've Outgrown Spreadsheets
- Two reps knocked the same door this week.
- You can't tell me in under 60 seconds how many leads are in "awaiting inspection."
- Your office manager is the only person who understands the color coding.
- Commissions take more than an hour to calculate for one pay period.
- You lost a deal because follow-up fell through cracks.
- A rep quit and took the contact list with them.
- You're copy-pasting the same address across three sheets and a text thread.
Three or more = past the wall.
Pre-Migration Audit
Block a half day. Open every spreadsheet, every Gmail folder, every WhatsApp group. Answer in writing:
- What data do I have? Every tab, every column.
- What do I need? Cross out columns untouched in 90 days.
- What's garbage? Test rows, duplicates, 2023 leads.
- What's missing? Half the rows lack phone numbers? Solve now.
- What's in someone's head? "The Johnsons already have a deposit in." Write it down before the vet rep quits.
Document < 2 pages, or you're moving too much.
Data Cleanup
Garbage in, garbage out is not a cliché.
- Standardize addresses. "123 Oak St" vs "123 Oak Street" vs "123 oak st." Pick format, find-replace.
- Standardize phone numbers. Strip punctuation. Pick 555-123-4567 format.
- Dedupe on address, not name. Property is the constant.
- Kill dead leads. 12+ months no activity. Archive, don't import.
- Fix status values. "New" vs "new" vs "NEW" vs "fresh" = one status.
- Fill required fields or delete. Don't dump blanks.
Expect to cut 20-40% of rows. That's the point. For field structure: data fields guide.
Field Mapping
Two-column doc. Left: spreadsheet column. Right: exact CRM field. For unmapped items decide: custom field, combine, or drop.
Traps: American vs ISO date format. "Notes" columns that are really five fields mashed. Rep names as free text (map to actual user accounts). Tags that overlap ("hail damage" vs "storm damage" = pick one).
Import Order
- Contacts. Homeowners first. Foundation. Spot-check 10 random records.
- Leads. Live sales opportunities, attached to contacts.
- Jobs. Signed work, attached to contact + lead.
- Activities. Notes, calls, knocks, inspection reports. Historical trail.
Stop after each phase. Fix source and re-run if broken , not in-CRM.
Change Management: Reps Hate New Tools
The humans are the hard part.
- Pick a rep champion. Most organized one, not loudest.
- Train in person. 30 min at Monday meeting beats an emailed PDF.
- Mobile first. If reps can't log a knock in 3 taps from the driveway, they won't. Test yourself before training.
- No shadow spreadsheets. Day one, delete write access. If open, reps use it.
- Tie to pay. Commission calculated from CRM. If not in system, didn't happen.
For adoption depth: CRM adoption among roofing reps.
First 30 Days
Week 1: Office only. Office manager + admin run CRM for inbound leads, scheduling, status. Reps knock, report back. Catches data-model mistakes before field sees them.
Week 2: Reps view only. Reps get login, view their pipeline, can't edit.
Week 3: Reps log activities. Knocks, calls, notes. Daily huddle, 10 minutes, review issues.
Week 4: Full ownership. Reps own pipeline end-to-end. Office shifts to QC. You pull reports.
Trying to compress this to week one = thrown phones and resignations by day 10.
What to Leave Behind
- Leads 12+ months old, no response.
- Half-finished custom reports nobody used.
- The WhatsApp group (archive for legal).
- Commission workbooks with formulas nobody can read.
- The rep who refuses to adopt. The tool is the standard.
Archive to read-only. Reference for six months. Then delete.
Tooling Notes
CSV import with field mapping and preview. Bulk edit after import. Duplicate detection at import time. Sandbox for test imports. Roofing-specific field templates. Ask to see the import flow live before buying , not a demo video, the actual screen.
RoofKnockers was built by roofers , data model knows what a knock, lead, and storm territory are. Free trial + test import with a sample file before committing.
Migration is a 30-day operational shift. Audit, clean, import in order, run the 4-week adoption schedule, leave the dead stuff behind. At end of month you'll have one place where leads, jobs, knocks, commissions live.
Ready to grow your roofing sales operation?
Start Your 14-Day Free Trial