Enriching Lead Lists: From Excel to Something That Works
Clean, enrich and prioritise your lead list instead of letting it go stale in Excel. A practical checklist, simple scoring, GDPR points and where AI can help.
Table of contents
What does enriching a lead list mean?
Enriching data means taking a list of names, companies and phone numbers and adding the information that makes the list usable: which industry the company is in, how big it is, who actually decides, and whether the information still holds. A lead list in Excel is a snapshot. It is already on its way to being wrong the day it is saved.
The problem is not Excel itself. A spreadsheet is fine for a small, new list. The problem arises when the list becomes a working tool for several salespeople over several months: someone corrects a number in their own copy, someone forgets to note that a contact said no, and nobody knows which version is the latest.
TL;DR:
- Contact data goes stale all the time. People change jobs, companies merge, numbers change.
- Clean first, enrich afterwards, prioritise last. The order matters.
- A simple, transparent scoring beats an advanced model nobody understands.
- The routine work (moving data, fixing duplicates, keeping track of who has been contacted) can be handed to AI. The decision about who to call should still be yours.
Why does Excel fail as a lead system when the list grows?
Five things typically go wrong:
1. Data goes stale without anyone noticing
People change jobs, companies change address and phone number, and some close down. How quickly this happens depends on the industry and the role. The best measure is your own: take 50 random rows from the list and check them one by one. See how many are still correct, so you know how far to trust the rest.
2. Enrichment is manual work
Who is the managing director now? How many employees does the company have? What is the industry code? Each answer requires a lookup, and lookups take a long time when done by hand.
3. There is no prioritisation
Excel can sort alphabetically or by number, but it cannot decide who is most worth calling today. The result is that salespeople call from the top of the list or the people they already know.
4. The information is scattered
What you know about a customer is in half a dozen places: in the spreadsheet, in an inbox, in a calendar, in a salesperson's notes. Nobody has the full picture, and the same question gets asked twice.
5. No traceability
GDPR requires that you can document why you hold a piece of information, where it came from, and that you can delete it if someone asks. A spreadsheet circulating by email cannot do that.
How do you clean the list before you do anything else?
Clean before enriching. Enriching wrong data simply gives you wrong data with more fields. A simple checklist:
- One phone format. Write all numbers with the country code, for example +45 12 34 56 78.
- Remove duplicates. Match on phone number, email and company name together. One contact can appear in the list under several spellings.
- Check the company name in the CVR register. The register at datacvr.virk.dk is public and free to search. It gives you the CVR number, industry code, address and status (whether the company still exists).
- Look for gaps. As a minimum, every row should have a company name, a contact person and a phone number or email.
- Remove private contacts if the list is for B2B use.
- Record where each contact comes from. Trade fair, referral, purchased list, website. This matters both for GDPR and for seeing which sources produce good customers.
- Record who has said no. A list where people who have asked not to be contacted are still called is both annoying and a legal problem.
If the list is large, free tools such as OpenRefine can help with duplicates and standardising values, and Power Query in Excel can automate repeated cleaning steps.
What must the list contain to be usable?
It is tempting to add as many columns as possible. Do not. Every field has to be maintained, and fields nobody uses are dead weight. Start with these:
| Field | Why |
|---|---|
| Company name and CVR number | The basis for every lookup |
| Contact person and title | Decides whether it is the right person to speak to |
| Phone and/or email | Without one of them you cannot make contact |
| Industry | Makes it possible to target the message |
| Size (employees) | Decides whether the company fits you |
| Source | GDPR and learning |
| Last contact and outcome | So nobody calls the same person twice |
How do you prioritise who to call first?
Start by writing down who your ideal customer is: industry, size, role, and what makes the timing right. Then use a simple scoring that you can explain yourselves:
- Does the company fit your ideal customer? (Industry, size)
- Is it the right person? (Title, decision-making role)
- Is the information fresh? (Last check)
- Has there been a sign of interest? (Visit to the website, reply to an email, an enquiry)
Give each category a few points, and divide the list into three: call now, follow up by email, or set aside and look again later. It is not advanced, but it is transparent. A scoring nobody understands is quickly abandoned.
What mistakes do companies make when they move the list out of Excel?
- They import dirty data. The errors come along into the new system.
- They skip enrichment and score on half the information.
- They have not defined their ideal customer, so the scoring cannot be calibrated.
- They create too many fields from the start. So nobody uses them.
- They forget to record who has said no.
- They stop looking at the source, so they cannot see which lead sources work.
- They give no feedback. Salespeople see that a lead score is wrong, but nobody corrects the rule.
What does GDPR say about a lead list?
This is not legal advice, but four points are worth knowing:
- You must have a lawful basis for processing the contact information, for example consent or a balancing of legitimate interests. You must be able to document it.
- You must inform the people you hold information about, also when you did not collect the information from them yourselves.
- You must be able to delete if someone asks you to, and respect objections to marketing.
- Keep only what is necessary, and only for as long as it is relevant.
The Danish Marketing Practices Act also regulates how you may contact people with marketing, including by telephone, email and SMS. Have a lawyer assess your specific use, especially if the list was bought or is very old. The Danish Data Protection Agency has guidance at datatilsynet.dk.
What can AI take over, and what should you keep yourselves?
AI is good at the repetitive, rule-based work that nobody wants to do:
- Standardising formats and finding duplicates, and marking those you must decide on yourselves.
- Looking up public registers and gathering the result into the list.
- Moving information from an email or a set of notes into the right fields.
- Updating the customer register when something happens, so the contact history is in one place.
- Suggesting an order according to the rules you have written down.
Your own judgement must still decide who is actually contacted, what is said, and what is sent. AI can propose, but it is you who answer for a wrong contact.
What can Agent360 do?
Agent360 builds AI solutions inside your own systems. We call it "Your AI department": a task you solve by hand today is built on top of the systems you already use, with you as the approver. The price follows the task and is agreed before we start.
For lead lists and customer data, these tasks are the most relevant:
- An end to typing the same thing twice: Information moved between your systems, with deviations gathered for you to decide. See automation.
- A customer register that updates itself: One page per customer, where emails, meetings and tasks land automatically. See customer register.
- Notes and fields after the meeting: See notes.
If you have a list that has outgrown Excel, we can look at it together with you and say what is worth building and what only needs tidying up. If you want to learn to use AI for the tidying yourselves, there is a personal AI mentoring programme.
Frequently asked questions
Q: How long does it take to clean a lead list? It depends on the size and how messy it is. The checklist itself is quick, but deciding on the rows that are unclear takes time. Plan time both for cleaning and for deciding which fields you want to keep.
Q: Can I use the CVR register to enrich my list? Yes. The register is public and gives, among other things, the CVR number, industry code, address and status. It is a good, free starting point before you consider purchased data.
Q: Should I buy an enrichment service? Not necessarily. Start with the free option, measure what is missing, and only buy data for the gaps that actually make a difference. Assess the source and the legal position before you buy.
Q: Will I lose my data if I move from Excel? Not if you keep the original file as a backup until you have checked that everything has come across.
Q: How do I get the salespeople to use the new system? Make it easier than Excel, not just different. When information moves by itself and salespeople do not have to type the same thing twice, the system gets used.
Q: Can I still use Excel alongside? For quick analyses, yes. But the lead list itself should live in one place. Two lists that have to be kept in step always end up different.
Conclusion: from spreadsheet to a list that works for you
A lead list is only as good as the upkeep it gets. Clean it, enrich what matters, prioritise by rules you understand yourselves, and let a machine take the routine work.
The three most important steps:
- Clean before you import. Data quality matters more than the tool.
- Write down your ideal customer, so the scoring has something to measure against.
- Make it easier to record than to skip. Otherwise the system goes back to Excel.
Book 20 minutes of free consultation with Agent360 and tell us where your customer data gets stuck. We will also tell you if the task is not worth building.
Also read: Automating sales processes.
Sources
Contents
Should your CRM keep itself up to date?
We build the layer that moves data into the CRM you already use, without anyone having to type it in. We look at your current set-up first.
Book a reviewShould your CRM keep itself up to date?
We build the layer that moves data into the CRM you already use, without anyone having to type it in. We look at your current set-up first.
How we built it · CRM & customer overview
Customer CRM that updates itself
An internal page per customer with contacts, the agreement, the projects and a timeline where emails, meetings, email drafts and tasks land by themselves. Above the pages sits the board with all customers, owner and latest contact, and the system suggests next steps based on fixed rules.
- Email, meeting, task
- Lands on the customer’s page
- You take the next step
Related articles

Sales Ops Automation in Python: Automating What No-Code Cannot
When is no-code not enough for sales ops? Three Python automation examples (bulk sync, scoring, reports), pitfalls, requirements and who should own them.

Headless Sales AI: What Happens When You Separate Intelligence from the Interface
What is headless sales AI? Separate the AI logic from the user interface so it works in CRM, Teams and email. Benefits, risks and when it is worth doing.

Webhooks for sales teams: how to build a real-time data pipeline
Webhooks for sales teams: what they are, webhooks versus polling, the most useful triggers, the five typical mistakes, and how to start without overbuilding.