How to Build a Lead List for B2B Sales, Step by Step

Knowing how to build a lead list is one of the most practical sales skills a small team can have. A good B2B lead list is narrow, accurate and free of duplicates, and every row holds what you need to make contact: business name, type, address, phone, email and website. This step-by-step guide shows the columns to set up, how to search a city area by area, where to find published contact details, how to remove duplicates and how to keep the list fresh.

If you are still deciding who to target and which channels to use, start with our B2B lead generation strategy, then come back here to build the list itself.

The short answer

1. Write a one-line target: business type, place, and a signal you can check.
2. Set up your columns before you collect anything.
3. List the areas of the city and search them one at a time.
4. Add the contact details each business publishes.
5. Check every new row for duplicates as you add it.
6. Tag, sort and split the list into batches of 50 to 100.
7. Date every row and re-check leads before important campaigns.

Before you start: the columns your lead list needs

Decide the fields first. Adding a column after you have 2,000 rows means doing the work twice. This set suits most small sales teams, so copy it into a sheet as your lead list template.

Three settings make the sheet easier to work with: freeze the top row, turn on filters, and give the status column a drop-down list (Data, then Data Validation, then List) so everyone uses the same words.

How to build a lead list in six steps

Step 1: Write the target in one line

For example: "Interior fit-out companies in Dubai and Sharjah that have a website." The line decides which rows belong. When a business does not match, leave it out, however interesting it looks.

Step 2: List the areas, then search them one at a time

One search for a whole city shows a limited set of the best-known names, so work in smaller pieces. Make a second tab called Areas with three columns: area name, date searched, rows added.

1. Write down the areas and neighbourhoods of the city, business districts first.
2. Search your business type in the first area with two or three wordings, such as "fit-out company", "interior contractor" and "office interiors".
3. In tower districts, search each tower and business centre by name as well.
4. Add each result to the list and fill in the area column.
5. Mark the area as done, with the date, and move to the next one.

For small towns with few named areas, use streets, UK postcode districts (M1, M2, M3) or US ZIP codes as your areas. Say you pick 12 areas and each gives 30 to 60 businesses of your type: that is 360 to 720 rows before duplicates, from one city and one business type.

Step 3: Add the contact details each business publishes

Open the website and check, in this order: the footer, the contact page, the about page, then the business's Facebook, Instagram and LinkedIn pages. Copy the general email (info@, sales@, hello@) and any mobile number listed for enquiries, and note where you found it in the source column.

Do not guess addresses from a pattern such as firstname@company. Guessed addresses bounce, and bounces harm the reputation of your sending domain.

Step 4: Check for duplicates on every new row

The same business appears in two neighbouring areas, under two spellings, or with its phone written in three formats. Store numbers in international format and check each new row against the list before you add it. Match in this order: phone number, then website domain, then name plus address. In Excel, a helper column with =COUNTIF(E:E,E2)>1 flags repeated phone numbers in column E. Our guide on how to remove duplicate leads covers cleaning an existing sheet.

Step 5: Tag, sort and split into batches

Add a few tags you can filter on: has website, has email, rating band, area. Remove businesses marked as closed. Sort so the best fits come first, then split the list into batches of 50 to 100. Contact one batch, learn from the replies, adjust your message and move on to the next.

Step 6: Keep the list fresh

Businesses move, close and change numbers. Keep the date-found column, re-check a lead before any important campaign, and refresh each area every few months. A list built in January is a list to check in June.

Phone numbers and addresses by region

Formats cause most duplicate and dialling problems, so fix them when you enter the row.

• UAE (+971). Landlines start 04 in Dubai, 02 in Abu Dhabi and 06 in Sharjah; mobiles start 05. Drop the leading 0 and add +971. Keep the building name and office number, because many addresses are a tower plus a unit.
• Saudi Arabia (+966). Landlines start 011 in Riyadh, 012 in Jeddah and 013 in the Eastern Province; mobiles start 05. Keep English and Arabic names side by side, and match duplicates on the phone number, not the spelling.
• UK (+44). London numbers start 020, Manchester 0161, Birmingham 0121, mobiles 07. Note "Ltd" or "LLP" in the name, because the email rules differ for limited companies and sole traders.
• USA (+1). Ten digits after the country code. Keep the suite number, since many offices share one street address.

Before you contact anyone, check the rules for that country: clear consent for marketing messages in the UAE and Saudi Arabia, PECR in the UK, and the federal commercial email rules in the USA. This is general information, not legal advice; check the current rules for the country you send to.

Common lead list mistakes to avoid

• Starting too broad. "All companies in London" gives you a list you cannot write one good message for.
• Collecting before choosing columns. Notes end up in the wrong places and fields go missing.
• Mixing formats. "04 123 4567" and "+97141234567" look like two businesses.
• Cleaning at the end. Removing duplicates from a 3,000-row sheet takes hours; checking each new row takes seconds.
• No source or date. Without them, you cannot tell a fresh lead from a stale one.

Where Rovero fits

Steps 2 to 4 are where the hours go, and they are what Rovero does on your Windows PC. You type a business type in your own words and a city in any country, tick the areas you want from its area list, and Rovero searches them one by one, including inside towers, business centres and malls. For each business it checks the homepage, contact and about pages and its social pages, and keeps up to 3 emails and 5 extra mobile numbers that the business publishes. Every business is checked against everything you already saved, across all your searches, so the list stays free of duplicates. You choose the columns and export to Excel, CSV or JSON.

Rovero is not a people database: it finds businesses and the contact details they publish, not job titles or decision-maker names.

Frequently asked questions

What should a B2B lead list include?

At minimum: business name, category, area, address, phone, email, website and the date found. Add status and owner columns once outreach starts. Rating and review count help you decide who to contact first.

How long does it take to build a lead list by hand?

It depends on the city and the business type. As a worked example, if one area takes 30 to 45 minutes to search, check and clean, then 12 areas take a full working day or more.

Can I build a lead list for free?

Yes, by hand, with the steps above. The cost is your time, which adds up quickly in a big city.

How often should I update my lead list?

Re-check leads before every important campaign, and refresh each area every few months. Remove businesses that have closed as soon as you learn about it.

Next step

Copy the columns into a sheet, pick one business type and one city, and build your first 100 rows today. To have the area-by-area work done for you, see what Rovero does and start a free trial, no card needed.