✦ HireWebScraper · Guides · Free PDF tools · Lead lists
Updated 2026-10-25
Creating a B2B lead list can feel expensive, but with the right free tools you can gather, clean, and export leads straight into Excel. This guide walks you through the process, from data sources to compliance checks.
Start by defining the exact profile of the companies you want to target. Think about industry, company size, revenue, and geographic location. Write down a list of keywords that capture these attributes—e.g., “software development,” “mid‑size,” “$10M‑$50M revenue,” “North America.” These keywords will guide your searches and help you filter results later.
Use public databases, LinkedIn, and business directories to pull company names that match your criteria. When you export the data, keep the company’s website URL, contact email, and phone number in separate columns. This makes it easy to import into HireWebScraper’s Smart Scraper Studio for further refinement.
Remember to respect privacy regulations. If you plan to email prospects, ensure your list complies with GDPR in Europe and CAN‑SPAM in the U.S. That means you should have a legitimate interest or prior consent before sending marketing messages. Keep a record of how you verified each contact’s eligibility to receive outreach.
Gathering accurate contact details is the first step toward a usable B2B lead list. Start by identifying the websites of your target companies—usually their “About Us” or “Contact” pages contain useful information. Use HireWebScraper’s free in‑browser PDF tools to pull the entire page into a single PDF, then open it in the Smart Scraper Studio app. From there, you can highlight email addresses, phone numbers, and names, and export the data directly to Excel. This method keeps the process simple and avoids the need for coding or paid services.
Always check that the data you collect complies with privacy regulations such as GDPR in Europe and CAN‑SPAM in the United States. If a company’s contact information is protected or the website’s terms forbid scraping, respect those boundaries and look for publicly available directories instead. This approach gives you a clean, ready‑to‑use lead list without breaking any rules.
Once your scraper has finished collecting the data, the next step is to get it out of the browser and into a usable file format. In HireWebScraper, click the “Export” button that appears after the scrape completes. From the dropdown, choose “CSV (Comma‑Separated Values)”. The tool will bundle the raw rows—each with the company name, contact email, phone number, and any custom fields you selected—into a single .csv file. Save it to a folder you can easily find, such as “LeadLists/2024_Q4”.
After the download, open the CSV in Excel or Google Sheets. You’ll notice that each column is correctly labeled, but the email addresses may include a trailing space or a hidden character. Use the TRIM function to clean them: `=TRIM(A2)` and copy down. If you plan to send outreach, double‑check that the emails comply with privacy regulations. Under GDPR, you must have a lawful basis for contacting individuals, and under CAN‑SPAM, you need a clear opt‑in or a prior business relationship. Mark any contacts that lack consent in a separate column so you can filter them out before outreach. This simple export step turns raw web data into a clean, compliant lead list ready for your next marketing campaign.
After you’ve imported your raw data into Excel, the first step is to clean it up. Start by removing any obvious errors: delete rows with missing email addresses, strip out duplicate rows, and standardize company names (e.g., “Inc.” vs. “Ltd.”). Use the “Remove Duplicates” feature under the Data tab, but remember to keep a copy of the original file in case you need to revert. Next, use the “Text to Columns” tool to split full names into first and last names, and the “TRIM” function to eliminate stray spaces that can cause mismatches later.
Once the basic cleanup is done, deduplicate more rigorously. Create a helper column that concatenates key fields (email, company, phone) and then use a pivot table or the “COUNTIF” function to flag duplicates. Delete or consolidate duplicates, ensuring you keep the most complete record. After cleaning, validate email formats with a simple regex or the “LEN” function to catch typos. Finally, review the list for compliance: remove any contacts that have opted out or that you cannot legally email under GDPR or CAN-SPAM. For a ready‑made, privacy‑compliant B2B lead list, you can also explore https://www.hirewebscraper.com/lists/.
Enrich your raw Excel list by adding verified email addresses, job titles, and company details with free, browser‑based tools. Start with HireWebScraper’s PDF‑to‑Excel converter to pull any PDF contacts straight into a spreadsheet, then use the Smart Scraper Studio app to auto‑populate fields like LinkedIn profile URLs or Crunchbase data. These tools run entirely in the browser, so you avoid downloading heavy software and keep your data secure.
After enrichment, double‑check compliance with GDPR and CAN‑SPAM. Verify that each email address is opt‑in or that you have a legitimate business relationship before sending outreach. Use a simple “unsubscribe” link in your first email to respect privacy and avoid penalties. By combining HireWebScraper’s free tools with a quick compliance check, you’ll have a polished, ready‑to‑use lead list without spending a dime.
Before you hit “send,” double‑check that every contact is compliant with privacy rules. 1. Open your Excel list and filter out any entries that lack a verifiable email address or phone number. 2. Run a quick GDPR/CAN‑SPAM check by using HireWebScraper’s built‑in “Compliance Scan” tool—this flags addresses that might be from regions with stricter opt‑in requirements. 3. Add a column for “Consent Status” and mark each lead as “Opt‑In,” “Opt‑Out,” or “Unknown.” 4. For those marked “Unknown,” add a short note to follow up with a consent request before sending mass mail. 5. Save the updated sheet and export it as a CSV for your outreach platform.
When you’re ready to reach out, keep your messages short, clear, and respectful of privacy. 1. Include a visible unsubscribe link in every email. 2. Personalize the subject line with the lead’s first name or company. 3. Use a reputable email service that tracks opens and clicks, so you can see if the contact is engaged and adjust your follow‑up cadence accordingly. By staying compliant and courteous, you’ll build trust and improve response rates.
Google Sheets IMPORTXML, Octoparse free tier, and HireWebScraper’s Smart Scraper Studio (free in‑browser PDF tools).
Use Excel’s Remove Duplicates feature or a pivot table to spot repeats before finalizing the list.
Yes. Under GDPR and CAN‑SPAM, you must have a lawful basis or prior opt‑in before sending marketing emails.
Type a niche and a place. We send 25 real businesses with website, phone and email (Excel) — usually within minutes. No card, no signup.
Need the full list? Custom lists for any niche & city — 300 rows $10 · 1,500 rows $15 · 5,000 rows $40 (launch prices), Excel + CSV in 24–48 h. Start with the free 25 above.
Business contacts from public sources. We may email you once or twice about the full list — unsubscribe any time.
© 2026 HireWebScraper · Privacy
in Follow HireWebScraper on LinkedIn · Facebook — new free lists and scraping tips