Count Leads by Source (or Any Column) in a CSV, Without a Pivot Table

To count leads by source, pick the source column and count each distinct value, with case and stray spaces ignored. The count unique values in CSV tool gives the distinct count, a count and share for each value, the blanks, and the values that appear only once, in your browser. A formula gives you the number too, but it treats Webinar and webinar as different sources.

Sources: Microsoft Support, UNIQUE function; Google Docs Editors Help, COUNTUNIQUE. Read 3 November 2026.

Steps

1. Paste or upload the CSV and press Count values.
2. Pick the column. A lead source, status, country, tag or company column is suggested first if there is one.
3. If a cell can hold several values, choose the separator so each is counted on its own.
4. Read the table: distinct count, then each value with its row count and share, most frequent first.
5. Download the counts as CSV, or the distinct values as a plain list.

Why the spreadsheet count is off

=COUNTA(UNIQUE(B2:B5000)) in Excel 365 and =COUNTUNIQUE(B2:B) in Sheets treat a trailing or non-breaking space as part of the value. A source typed by hand in three forms and pasted from a form in two more becomes five rows in the report. The tool always ignores spaces at either end and ignores case by default. Switch on case-sensitive counting and it lists the spellings that differ only by case, which you can then fix in one go with find and replace in CSV and count again. Near-misses like Contoso Ltd and Contoso Limited still need a rule of their own; clean CSV columns before an import covers that pass.

Useful columns to count

Column	What the count tells you
Lead source	Where the list came from, before you decide what to mail
Status or lifecycle stage	How much of the list is customers, leads or unsubscribed
Country or state	Which rules apply to whom, and where a list is concentrated
Company or domain	How many contacts per account; too many in one place is a risk
Email	Distinct addresses vs rows: the gap is your duplicates

For blanks and distinct counts across every column at once, use the CSV fill rate checker; this tool counts one column at a time.

Count reachable contacts, not rows

A source that gave you 4,000 rows isn't worth more than one that gave you 2,000 if half the first set bounces. Verify the list, then count the source column in the valid file. That's the fair comparison, and it's the one test a new lead source recommends before buying more from the same place. For repeated emails, CRM duplicate leads from multiple sources explains which copy to keep.

Limits

Values are compared as text after trimming, so 1,000 and 1000 are different values. Only case and spacing differences are merged. Splitting on a comma also splits values that contain one. And the counts describe what's in the file, not which addresses deliver.

Where SimpleVerifier fits

Upload the list at /verify: every address gets a live mailbox check, and valid, risky and invalid download as separate files with the source column kept, ready to count again. The first 100 checks are free with a Google sign-in. Pro is $39 a month with the first 100,000 checks a month at full speed, then slower, never cut off, and one-time packs of 10,000 checks for $15 never expire. See pricing.