How to Extract Thousands of B2B Leads from Heavy HTML Files with the AJC Master Prompt

Turn raw webpage source code, directory dumps, and unformatted lists into structured, campaign-ready CSV databases using AI.

If you have ever tried to manually copy and paste thousands of business contacts from a public web directory, you already know the frustration: the browser freezes, selection breaks, and spending hours manually building spreadsheets slows down your entire sales operation. High-volume prospecting requires automated precision.

At AJC Ideas, we focus on scalable, high-throughput solutions. The true power of modern large-context AI models (such as Google Gemini 1.5 Pro/Flash or Claude) is not cleaning ten rows of text—it is processing massive, unformatted HTML files in seconds.

By saving an entire web page containing thousands of listings directly to your computer, you can feed the complete source code into AI using the AJC Master Extraction Prompt to generate a clean, perfectly formatted CSV database ready for Excel or your CRM.

How to Obtain the Raw HTML File for Batch Processing

Skip manual text highlighting entirely. Follow these quick steps to capture massive lists:

Navigate to your target public directory or database (e.g., YellowPages, Chamber of Commerce directories, industry association listings).
Right-click anywhere on the page and select "Save As..." (or press Ctrl + S).
Save the file to your computer as lead_database.html.
This file now holds all the underlying contact data displayed across the page.

Practical Case Study: Mass Extraction from an Industry Directory

Suppose you saved a complete directory web page containing 500 digital marketing agency profiles in a single .html file.

Step 1: Open a Large-Context AI Platform

Access Google Gemini (gemini.google.com) or Claude (claude.ai), both of which support large document and code uploads.

Step 2: The Master File Extraction Prompt

Click the attachment button (+ or paperclip icon), upload your lead_database.html file, and paste the following prompt:

[SYSTEM: AJC LEAD MACHINE - BATCH FILE EXTRACTOR]
Act as a Senior Data Automation Engineer specializing in B2B growth operations.

OBJECTIVE:
Analyze the attached raw file (HTML/TXT/CODE) completely from start to finish without skipping entries. Extract every single commercial entity detected within the document.

EXTRACTION PROTOCOL:
1. Scan the entire document and locate all company, professional, or commercial listings.
2. Extract the following compulsory fields for each record:
   - Company / Business Name
   - Niche / Industry Category
   - Email Address (If missing, state: "Not Specified")
   - Phone Number
   - Website / Profile URL
   - Location (City / Country)

MANDATORY OUTPUT FORMAT:
To ensure instant copy-pasting and seamless mass import into Excel, Google Sheets, or CRM systems, output the final response EXCLUSIVELY as a raw CSV code block (comma-separated with quote encapsulation).

EXPECTED CSV STRUCTURE EXAMPLE:
"Company Name","Category","Email","Phone","Website","Location"
"InnovaTech Agency","SEO","contact@innovatech.com","+1 555 019 2831","www.innovatech.com","New York"

Process the attached file now:

Step 3: Export Your Database to Excel

Click Send. The AI will process the file in the background.
Copy the clean CSV block generated by the AI.
Paste the text into Notepad, save it as massive_leads.csv, and open it directly in Microsoft Excel or Google Sheets.

AJC-IDEAS

Monday, August 31, 2026