Live demo — no login required
From Messy Lead List to Clean Sales Workspace
A real sample lead list — the kind you get from trade shows, scrapers, or manual entry. 18 contacts, duplicate pairs, missing emails, bad formats, and mixed casing. Watch how SheetApp cleans it, scores every lead, and surfaces your best prospects.
Step 1 — The Messy CSV: Before SheetApp
This sample has 18 leads with mixed column names, duplicates, missing emails, invalid email formats, inconsistent status values, and mixed casing — typical of any real-world import.
| Name | Company | Issues detected | |
|---|---|---|---|
| john doe | Acme Corp | (missing) | Missing email · Name not capitalized |
| Mary Smith | globex | mary.smith@globex.com | Extra whitespace · No phone |
| Mary Smith | Globex | mary.smith@globex.com | Duplicate of row above |
| Carlos Ramirez | Initech | carlos@initech.io | Clean |
| (missing) | Umbrella LLC | info@umbrella | Missing name · Bad email |
Showing 5 of 18 rows for illustration. The full interactive demo shows all 18 rows.
Step 2 — After SheetApp: Health Score & Stats
61
Lead Quality Score
Needs Cleanup
18
Total Leads
4 lead sources
3
Duplicate Contacts
6 rows to merge
4
Missing Emails
+ 2 invalid formats
AI Summary
This lead list has 18 contacts from 4 lead sources — Trade Show, LinkedIn, Referral, and Website Form. I found 3 duplicate contact pairs (Mary Smith/Globex, James O'Brien/Stark Industries, Rachel Zane + Harvey Specter from Pearson Specter overlap). There are 4 leads with missing emails and 2 with invalid email formats that won't reach the inbox.
The column headers are inconsistent — "co.", "Phone #", "ST" have been cleaned to Company, Phone, and State. Your top pipeline value comes from Trade Show and Referral sources, totaling $283,500. Start with James O'Brien (Stark, $120k Closed Won), Harvey Specter (Specter Litt, $85k Qualified), and Ahmed Hassan (Cyberdyne, $60k Qualified) — all have complete contact info.
Step 3 — Priority Leads
SheetApp ranks every lead by score. Here are the top contacts from this sample:
| Score | Name | Company | Title | Status | Deal |
|---|---|---|---|---|---|
| 91 | James O'Brien | Stark Industries | Procurement | Closed Won | $120,000 |
| 87 | Harvey Specter | Specter Litt LLP | Managing Partner | Qualified | $85,000 |
| 84 | Ahmed Hassan | Cyberdyne | IT Director | Qualified | $60,000 |
| 81 | Carlos Ramirez | Initech | CTO | Qualified | $45,000 |
| 76 | Grace Kim | Nakatomi Trading | Sales Manager | Qualified | $33,000 |
Step 4 — Ask This Data
Ask any question about the spreadsheet in plain English. SheetApp answers with citations.
Q: Which leads are missing contact info?
A: 4 leads have missing or invalid email addresses: John Doe (Acme Corp), the unnamed contact at Umbrella LLC, Lena Fischer (Wayne Enterprises), and Harvey Specter (Specter Litt — email domain doesn't resolve). I'd recommend enriching these before starting outreach.
Q: What's the total pipeline value from qualified leads?
A: Your qualified leads represent $243,500 in combined pipeline. Top 3 by deal size: James O'Brien at $120k (Closed Won), Ahmed Hassan at $60k, and Carlos Ramirez at $45k — all three have complete contact info and active deal status.
Q: Which lead source is bringing in the most value?
A: Trade Show leads account for $153,500 in pipeline (James O'Brien + Grace Kim). Referral leads are close behind at $130,000 (Harvey Specter + Donna Paulsen + Carlos Ramirez). LinkedIn adds $68,500.
No account required to analyze. See pricing for export options.