How to Export Leads to Excel and Actually Work Them

2026-07-21

You ran a search, you've got a list of companies with emails, phone numbers, and social handles. Now what? A raw lead list is potential energy. It does nothing until you turn it into a system you actually work through, one contact at a time.

The humble spreadsheet is where most of that work happens. Not a fancy CRM, not an expensive sales tool — Excel or Google Sheets. This guide walks through the whole flow: exporting cleanly, building the columns that matter, deduping and scrubbing, tracking outreach with a status column, batching your days, and the handful of formulas that save you real time. It's the boring, unglamorous part of prospecting, and it's exactly where deals get won or lost.

Get the list out cleanly: xlsx vs CSV

Before you can work a list you have to export it, and the format matters more than people think. You'll usually have two options: xlsx (native Excel) or CSV (plain comma-separated text).

xlsx keeps formatting, multiple sheets, and column types intact. Open it and it just looks right. Best when you're staying inside Excel or Google Sheets.
CSV is universal — every tool on earth reads it — but it's dumber. Leading zeros on phone numbers can vanish, long numbers turn into scientific notation, and non-Latin characters sometimes garble if the encoding isn't UTF-8. Best when you're feeding another system.

If your export mangles phone numbers, the fix is almost always to format the phone column as text before the data lands, or to import the CSV through Excel's data-import wizard and set that column to text manually. It's a two-minute habit that saves you from calling half-numbers all week.

A good lead tool hands you a file that's already clean — consistent columns, UTF-8, phone numbers intact. JustLeadIt exports xlsx and CSV that are ready to work immediately, which spares you the first hour of cleanup most raw scrapes demand.

The columns that actually matter

A lead sheet with forty columns is a lead sheet nobody uses. Strip it to what drives action. For most B2B outreach, this is the working set:

Company — the business name. Your anchor column; everything sorts and dedupes around it.
Contact name — a real person if you have one. "Hi there" converts worse than "Hi Maria."
Email — your primary channel for most markets.
Phone — for calls or SMS.
WhatsApp — increasingly the channel that actually gets read, especially outside North America.
Socials — Instagram, Telegram, or a LinkedIn handle. Sometimes the only door that opens.
Website — for a 20-second qualification glance before you reach out.
Status — where this lead sits in your pipeline. The single most important column you'll add yourself.

Add a Notes column too, and a Last contacted date. That's it. If a column doesn't help you decide who to contact next or what to say, it's clutter. You can always keep the raw export in a second tab and pull extra fields in later.

Freeze the header and format as a table

Two small moves make a sheet pleasant to live in. Freeze the top row so your headers stay visible as you scroll (View → Freeze in both Excel and Sheets). Then format the range as a table (Ctrl+T in Excel, or Format → Convert to table in Sheets) so you get instant filter dropdowns on every column. These take ten seconds and you'll use them a hundred times a day.

Clean and dedupe before you touch anyone

Never work a dirty list. Every duplicate is a chance to email the same company twice and look sloppy; every blank email is a row you'll waste time on. Spend fifteen minutes here and the whole week runs smoother.

Kill the duplicates

Duplicates creep in when you merge searches or pull the same company from two sources. In Excel, select your data and use Data → Remove Duplicates, choosing the email or website column as the key — those are more reliable than company name, which varies ("Acme", "Acme Ltd", "Acme Limited"). In Google Sheets, use Data → Data cleanup → Remove duplicates.

If you'd rather flag before deleting, a formula marks repeats without destroying anything:

Excel / Sheets: =COUNTIF(C:C, C2)>1 in a helper column returns TRUE for any email that appears more than once. Filter to TRUE, review, then remove.

Scrub the obvious junk

Trim stray whitespace with =TRIM(A2), which quietly breaks lookups and dedupes when left in. Normalize case on names with =PROPER(B2) so "maria SILVA" becomes "Maria Silva". Flag rows missing an email so you can route them to a different channel instead of skipping them silently:

=IF(C2="","no email","ok") in a helper column. Filter to "no email" and you've instantly got your phone-and-WhatsApp-only segment.

Do a quick sanity pass on emails too. =IF(ISNUMBER(SEARCH("@",C2)),"ok","check") catches anything without an @ sign — usually a scraping artifact or a placeholder. It won't validate deliverability, but it catches the garbage.

Build a status column that runs your pipeline

This is the move that turns a list into a machine. Add a Status column and give every lead one of a small, fixed set of values. Keep it short — six stages is plenty:

To contact — untouched, waiting in the queue.
Contacted — you've sent the first message.
Replied — they answered; the conversation is live.
Meeting — a call or demo is booked.
Won — closed, paying, done.
Dead — a hard no, wrong fit, or bounced. Mark it and move on.

The discipline that matters: use the exact same words every time. "Contacted" and "contact" and "reached out" are three different values to a spreadsheet, and they'll break every filter and count you build. Set up a dropdown so you can only pick from the list — Data → Data validation in both Excel and Sheets, with your six stages as the allowed values. Now updating a status is one click and it's always consistent.

Once statuses are clean, your sheet answers real questions in seconds. Filter to "To contact" for today's queue. Filter to "Replied" to see who needs a follow-up. Count how many sit in each stage with =COUNTIF(H:H,"Contacted") and you've got a rough funnel without any extra software.

Add a follow-up date

Replies and meetings die in the gap between "they said maybe" and "I forgot to follow up." A Follow-up date column fixes that. Put the next-action date in it, then sort or filter by that column each morning. Anything dated today or earlier is your callback list. This one habit recovers more deals than any clever email ever will.

Sort and filter by contact quality

Not all leads are equal, and you shouldn't work them in the random order they exported. Prioritize. A lead with a named contact and a direct email beats a generic info@ address with no name. A lead with WhatsApp and Instagram gives you three ways in instead of one.

A simple scoring column lets you sort the best to the top. Give a point for each channel present:

=COUNTA(C2)+COUNTA(D2)+COUNTA(E2)+COUNTA(F2) across your email, phone, WhatsApp and socials columns gives a rough "reachability" score. Sort descending and work the richest leads first.

You can get fancier — weight a named contact higher, dock generic role-based emails — but don't overthink it. The point is to stop treating a thin lead and a rich lead as interchangeable. Filter, sort, and spend your best energy where the odds are best.

Split into daily batches

Staring at a list of eight hundred leads is how prospecting stalls. It feels infinite, so you do none of it. The fix is to never look at the whole list — work it in daily batches.

Pick a number you can actually do well: maybe 20 to 40 personalized outreaches a day. Add a Batch column and number your leads in groups, or just filter to "To contact", sort by your quality score, and take the top slice each morning. When today's batch is contacted, you're done — close the sheet.

Batching protects your sending reputation. Blasting hundreds of cold emails or WhatsApp messages in an hour is how you land in spam or get a number flagged. Steady daily volume looks human because it is.
Batching keeps outreach personal. Twenty thoughtful messages beat two hundred copy-pasted ones every time.
Batching makes the work sustainable. A repeatable daily rhythm compounds; a heroic one-day blast followed by burnout does not.

The formulas worth knowing

You don't need to be a spreadsheet wizard. A handful of formulas cover ninety percent of lead work:

=COUNTIF(range, value) — count leads by status, flag duplicates, size each funnel stage.
=TRIM(cell) — strip hidden whitespace that breaks matching.
=PROPER(cell) — tidy up names and company casing.
=IF(condition, a, b) — flag missing emails, mark segments, build any yes/no logic.
=ISNUMBER(SEARCH("@", cell)) — a rough email sanity check.
=VLOOKUP or =XLOOKUP — pull data from another sheet, like matching leads against a "do not contact" list.

Learn those six and you can shape almost any lead list to your will. Everything past that is optimization, not necessity.

When to graduate from a spreadsheet to a CRM

A spreadsheet is the right tool right up until it isn't. It's free, flexible, and instant — perfect for one person working a few hundred leads. But there's a ceiling, and you'll feel it.

Signs you've outgrown the sheet:

More than one person is editing, and you're overwriting each other's updates.
You want automatic reminders and follow-up sequences, not a date column you have to check by hand.
You need email opens, replies, and history logged automatically instead of typed into Notes.
You're managing thousands of leads and the file has gotten slow and fragile.
You want reporting — conversion by source, pipeline value — without rebuilding it every week.

When two or three of those are true, move to a CRM. Until then, resist the urge. A CRM you don't need is overhead you'll spend more time configuring than selling through. Plenty of real businesses run entirely on a well-kept sheet. Graduate when the pain is real, not because a tool told you to.

Put it together

The workflow is simple and it repeats: export clean, trim the columns to what matters, dedupe and scrub, add a status and follow-up column, score and sort by quality, then work steady daily batches — updating each status as you go. Do that and your list stops being a static dump and becomes a living pipeline you can actually see moving.

The one part you shouldn't have to fight is the export itself. Starting from a clean, well-structured file is half the battle, and it's the half you can skip. If you'd rather begin with contacts that are already deduped, correctly formatted, and ready to drop straight into the workflow above, let JustLeadIt build your list and export it in one click — then open the sheet and get to work.