Skip to main content
TutorialsNovember 13, 2026 · 3 min read

How to export Google Maps pharmacy leads to Excel

Use Spidra to find pharmacies in Lekki, Lagos, collect available phone numbers and emails, and export 20 Google Maps listings to Excel.

How to export Google Maps pharmacy leads to Excel

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.

Google maps leads 1.png

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.

Google map leads 2.png

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.

Google map leads 3.png

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).

google maps leads 4.png

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

Share this article

You build the product.
Spidra handles the data work.

Start with 300 free credits, about 300 pages. No credit card required.