Template

Local Business Lead List Template

A free local business lead list template for organizing businesses, categories, websites, emails, phones, locations, source URLs, status, and notes.

23 columns CSV + XLSX Local leads 4 min read

Download template Install extension

Download the template

Use the CSV for quick imports into other tools, or use the Excel file when you want a cleaner local business prospecting sheet for review, segmentation, outreach planning, client delivery, or CRM import preparation.

0 (empty) rows 23 columns

Download Excel

Use cases

Who This Template Is For

Use this local business lead list template when you are collecting businesses from local directories, chamber of commerce pages, business association pages, city guides, search results, company websites, marketplace pages, or best-of lists.

It is designed for agencies, freelancers, consultants, local sales teams, founders, marketers, and service providers who need to organize businesses by category, city, location, contact details, status, and source.

The template is designed to work well with ProfileSpider exports, but it is not an import format. Use it as a spreadsheet structure for manual research, post-export cleanup, local campaign planning, client delivery, CRM import preparation, or outreach tracking.

Preview

What's in the File

Sample rows below. Downloads ship empty so you can fill them manually or use them to organize exported ProfileSpider data.

profilespider-local-business-lead-list-template.xlsx

Business	Category	Website	Email	Phone	City	Lead Status	Source URL
Northstar Dental	Dental Clinic	northstardental.example	hello@northstardental.example	+34 600 000 001	Barcelona	Reviewed	example-directory.com/barcelona-dentists
Weber Fitness Studio	Fitness Studio	weberfitness.example		+34 600 000 002	Barcelona	Needs email	local-guide.example/fitness-studios
Verhoeven Legal	Law Firm	verhoevenlegal.example	info@verhoevenlegal.example	+34 600 000 003	Barcelona	Ready for outreach	chamber.example/member-directory

Schema

Column Dictionary

A local-business-focused schema for city campaigns, niche lists, agency work, local SEO outreach, and service-provider prospecting.

Column	Type	Notes
Business Required	string	Local business, company, clinic, shop, agency, firm, studio, restaurant, contractor, or service provider name.
Category	string	Business type, service category, industry, niche, or local search category.
Description	string	Short business description, service summary, or notes from the source page.
Website	url	Full business website URL when available.
Domain	string	Website domain without protocol when possible, such as exampleclinic.com.
Email	string	Business email when visible, manually added, or found through email finding where available.
Email Status	string	Use your own status labels, such as visible, found, verified, needs-review, not-found, or invalid.
Phone	string	Phone number when visible or manually added.
Address	string	Street address or location details when available.
City Required	string	City or town for local segmentation.
Region / State	string	Region, province, state, county, or local area.
Country	string	Country for filtering and export cleanup.
Postal Code	string	Postal or ZIP code when available.
LinkedIn URL	url	Company or business LinkedIn URL when available.
Social URL	url	Instagram, Facebook, X, YouTube, TikTok, or other public social profile when available.
Contact Name	string	Owner, founder, manager, director, or other contact person when known.
Contact Role	string	Role of the contact person, such as owner, founder, manager, dentist, lawyer, director, or partner.
Lead Status	string	Use labels such as New, Needs review, Reviewed, Needs email, Ready for outreach, Contacted, Follow-up, Not a fit, or Client.
Priority	string	Use labels such as High, Medium, Low, Tier 1, Tier 2, or Tier 3.
Next Action	string	The next task, such as review website, find email, call, send email, add to CRM, follow up, or export.
Tags	string	Use semicolon-separated labels, such as city:barcelona;category:dentists;local-seo;needs-email.
Notes	string	Free-form review notes, qualification comments, campaign context, or outreach ideas.
Source URL Required	url	Where this business came from. Keep this for verification, cleanup, and source tracking.
Last Reviewed	date	ISO date when you last checked, enriched, verified, called, or reviewed the row.

How to

How to Use This Template

Use it to move from scattered local sources to a structured local business lead list.

Fill it manually

Use the template as a local lead sheet when you are researching businesses without the extension.

1Download the empty CSV or Excel file above.
2Add one row per local business, company, clinic, shop, agency, firm, studio, or service provider.
3Fill Source URL for every row so you can verify where the business came from.
4Use City, Region / State, Country, Category, and Tags to segment the list.
5Use Lead Status, Priority, and Next Action to track review and outreach progress.
6Use Notes for local context, qualification comments, service-fit notes, or outreach ideas.

Use it with ProfileSpider exports

ProfileSpider can extract local business data from public pages, save rows to lists, and export them to CSV, Excel, or JSON. Use this template to clean, segment, and organize those exported local business rows after download.

1Install ProfileSpider and open a public local directory, chamber page, business association page, city guide, marketplace page, search result, or company website in Chrome.
2Run extraction and save useful business rows to a list.
3Review the saved list, add tags and notes, enrich where useful, or find emails per row where available.
4Export the list as CSV or Excel.
5Use this template to add Lead Status, Priority, Next Action, city/category segmentation, and local campaign notes before sharing or importing elsewhere.

ProfileSpider does not currently support CSV/file import inside the extension. This template is for manual local business research, cleanup, segmentation, export organization, and external spreadsheet workflows.

Local Business Lead Generation use case

Questions

Questions About the Template

What is this local business lead list template for?

It is a spreadsheet structure for organizing local businesses by category, website, email, phone, location, lead status, priority, next action, source URL, tags, and notes.

Who should use this template?

Agencies, freelancers, consultants, local sales teams, founders, marketers, and service providers can use it to organize local business lead lists.

Can I use this template with ProfileSpider exports?

Yes. Use it to organize, clean, segment, or hand off local business data exported from ProfileSpider lists.

Can I import this template back into ProfileSpider?

No. ProfileSpider does not currently support CSV or file import inside the extension. This template is for manual work, cleanup, export organization, and external spreadsheet workflows.

What formats are available?

The template is available as CSV and Excel.

Does ProfileSpider export CSV and Excel?

Yes. ProfileSpider exports saved lists as CSV, Excel, or JSON.

Does exporting use credits?

No. Exporting saved lists to CSV, Excel, or JSON uses 0 credits.

Which columns are most important?

Business, Category, Website, Email or Phone, City, Lead Status, Next Action, Source URL, Tags, and Notes are the most useful fields for local business lead generation.

What should I put in Lead Status?

Use labels such as New, Needs review, Reviewed, Needs email, Ready for outreach, Contacted, Follow-up, Not a fit, or Client.

What should I put in Tags?

Use labels such as city:barcelona, category:dentists, local-seo, source:chamber, needs-email, reviewed, or client:acme.

Does this work in Google Sheets?

Yes. Download the CSV or Excel file and upload it into Google Sheets.

Can I use this for client campaigns?

Yes. Use separate files, clear tags, source URLs, and notes to organize local business campaigns by client, city, niche, or source.

Local Business Lead List Template

Download the template

Fill it manually

Use it with ProfileSpider exports

Ready to Extract Structured Leads?