Live demo. No login required
From Messy Lead List to a Clear Sales Workspace
This sample lead list includes data like you might get from trade shows, scrapers, or manual entry. 18 contacts, duplicate pairs, missing emails, bad formats, and mixed casing. See how SheetApp flags issues, scores each lead, and highlights higher-scoring prospects for review.
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, which can happen in real imports.
| 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 | No issues flagged |
| (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: Health score and stats after SheetApp
61
Lead Quality Score
Needs Cleanup
18
Total Leads
4 lead sources
3
Duplicate Contacts
6 rows in duplicate groups
4
Missing Emails
+ 2 invalid formats
AI Summary
This lead list has 18 contacts from four sources: Trade Show, LinkedIn, Referral, and Website Form. I found three duplicate pairs: Mary Smith at Globex, James O'Brien at Stark Industries, and an overlap between Rachel Zane and Harvey Specter at Pearson Specter. Four leads are missing email addresses, and two email formats are invalid.
The column headers were inconsistent. SheetApp renamed "co.", "Phone #", and "ST" to Company, Phone, and State. Trade Show and Referral are your strongest sources, with $283,500 in combined pipeline. Start with James O'Brien (Stark, $120k Closed Won), Harvey Specter (Specter Litt, $85k Qualified), and Ahmed Hassan (Cyberdyne, $60k Qualified). Each has complete contact information.
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: Four leads have missing or malformed email formats: John Doe (Acme Corp), the unnamed contact at Umbrella LLC, Lena Fischer (Wayne Enterprises), and Harvey Specter (Specter Litt). Review and update their contact details before outreach.
Q: What's the total pipeline value from qualified leads?
A: Your qualified leads represent $243,500 in combined pipeline. The three largest deals are James O'Brien at $120k (Closed Won), Ahmed Hassan at $60k, and Carlos Ramirez at $45k. Each has complete contact information and an 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. Compare pricing and export options.