If you need a spreadsheet of local businesses, start with two inputs: the kind of business you want to find and the area you want to search. Spidra’s Google Maps leads template turns that search into a table you can open in Excel. Each row represents a business listing, with fields for its name, phone number, website, address, and Google Maps link.
This walkthrough uses pharmacies in Lekki, Lagos, as a worked example. To build your own list, change the business type and location. The same steps apply to a search for bakeries in Abuja or furniture stores in Accra.
1. Open the Google Maps leads template
In the Spidra dashboard, open Templates, select Lead generation, and choose Google Maps leads. The template lets you search one or more areas and optionally collect contact details from the businesses’ own websites.
2. Choose a business type and search area
Enter the kind of business you want to find. Under Areas, enter one location per line. Use Pages per area to set how many pages to collect. One page can return up to 20 places, so it’s a practical starting point for checking whether your search finds the businesses you have in mind.
For the sample run, we entered Pharmacy, used Lekki Lagos as the area, and selected one page. We also turned on Find emails and social links. With that option enabled, Spidra visits business websites and their contact pages to look for published contact details. If a business has no website or doesn’t publish an email address, its email field can be empty.
3. Run the search and review the listings
Select Run, then open the Table view in Results. The sample search returned 20 listings. Among them were Mopheth Pharmacy Eti Osa Lekki Phase 1 Lagos, Alpha Pharmacy & Stores Lekki, and Medplus Pharmacy Lekki-Admiralty.
Before exporting, check a few rows against your intended use. For example, the results include several Mopheth listings with similar names. If you’re building a branch directory, compare their addresses and Maps links before merging them. If you need a call list, check the Phone column first. One Mopheth listing in this run had no phone number.
4. Export the results to Excel
Select CSV above the results table and open the downloaded file in Excel. If you want to preserve phone numbers exactly as exported, use Data → From Text/CSV and set the Phone column to Text before loading the data.
The sample export contains 12 columns: Name, Category, Phone, Website, Emails, Instagram, Facebook, LinkedIn, Rating, Reviews, Address, and Maps link. In Excel, you can filter for rows with a phone number, group branches by address, or use the Maps link to inspect a listing. To keep your filters and formatting, save the file as an Excel workbook (.xlsx).
To build a list for your own market, open the template, enter your business type and area, and review the first page before expanding the search. Open the Google Maps leads template