A list of businesses by city in Excel or Google Sheets, in two minutes
One trade, one city, a few filters, then the Export CSV button: you open in Excel or Google Sheets a file with address, phone, email, website and Instagram.
- 25 Gratis-Credits
- Keine Vertragsbindung
- CRM inklusive
A list of businesses by city in Excel is often the first thing you prepare before prospecting: the restaurants of Lyon, the plumbers of Bordeaux, the real estate agencies of London, with a number and an email on every row. With Prospya, that file takes two minutes to build, without copying a directory line by line and without installing anything.
Get a list of businesses by city into Excel in 2 minutes
- 1Pick the trade and the city
In the search, type “restaurant” and “Lyon”, or a sentence like “hair salons in Nantes with email”. A city, a region or a postcode all work.
- 2Filter
With a phone, with a verified email, without a website, minimum rating, only new businesses: the number of results updates with every filter.
- 3Export
Click “Export CSV”, choose the number of rows, and open the file in Excel or Google Sheets.
Searching and counting are free. The export unlocks the records you choose: one credit per business with a phone or an email, free for those with neither. One export can hold up to 5,000 rows. A record you already unlocked is never charged again: from My leads you can export all your records to CSV as often as you like, for free.
How many businesses are in your city?
Two examples, with figures computed live from the database:
| Trade and city | Businesses | With a phone | With an email |
|---|---|---|---|
| Restaurants in Lyon | 1.660 | 1.589 | 900 |
| Hair salons in Lyon | 355 | 351 | 162 |
| Real estate agencies in Lyon | 412 | 408 | 275 |
| Restaurants in London | 6.115 | 6.008 | 2.995 |
| Hair salons in London | 1.979 | 1.973 | 880 |
| Real estate agencies in London | 3.330 | 3.314 | 800 |
The same works for 31.579 cities in France and Belgium, and for the big cities of 13 other countries, from New York to Toronto. Each trade also has its own page listing its cities, for example the restaurant list.
The columns of the Excel file
The file is a UTF-8 CSV with the byte-order mark that lets Excel read accents correctly. One row per business, with these columns:
| Column | Content | What it is for |
|---|---|---|
| Name | The trading name | Personalising the subject line and opener |
| Category | The trade in the database (restaurant, plumber…) | Sorting, filtering, pivot tables |
| Detailed category | The precise type (pizzeria, bistro, barber…) | Fine-tuning a message |
| Address, postcode, city, region, country | The full address | Planning a route, targeting a district |
| Phone | The number the business publishes | Cold calling |
| The published address, domain checked | Campaigns and written follow-ups | |
| Website | The site's address, empty if there is none | Spotting a need, preparing the call |
| The public account | DMs, social media agencies | |
| Rating and review count | For part of France | Targeting active businesses |
| ID | A unique ID per record | Removing duplicates, matching with your CRM |
The My leads export adds two columns: the pipeline stage and your note. There are no owner names: these are the details the business itself publishes.
Opening the file in Excel or Google Sheets
In most English-language setups a double-click opens the file with every column in place. If your Excel uses a European locale and puts the whole row in one column, go through Data › From Text/CSV, choose "Comma" as the delimiter, then Load. In Google Sheets: File › Import › Upload, the separator is detected automatically. The same file imports into HubSpot, Pipedrive, Brevo or Lemlist.
Prepare the list for calls or emails
For a call list, sort by postcode so each salesperson has a coherent area, keep only rows with a phone, and add a column for the best time to call: restaurants are hard to reach during service, shops are quieter just after opening. For an email campaign, keep only verified emails, check that the Name column reads well in a sentence, and remove the businesses you already work with. In both cases, write down who said no: a business that asked not to be contacted again must not end up in next month's file.
Also note the phone format: numbers outside France are exported with their international prefix, for example +44 for the United Kingdom or +1 for the United States, which avoids mistakes when your team calls from another country.
Export a business directory to Excel: the filters that matter
An online directory shows one business's details at a time. Here, the filters do the sorting before the export, so you only pay for useful rows.
About fifty trades; city, postcode, region or a whole country.
For a call list: keep only businesses that have a number.
Domain checked to receive mail, before a campaign.
For web agencies: businesses that do not have a site yet.
Minimum rating and review count, where known.
Hides businesses you already unlocked or marked as already contacted.
Three tips once you are in Excel
- Add a Status column (to call, called, interested, not interested) and a Follow-up date column. Or simply work in Prospya's CRM, which does it for you: see the sales prospecting tracker.
- Build a pivot table by postcode to split the city between several salespeople or several days in the field.
- Do not keep two files for the same city: run the search again with "only new businesses" to get only the businesses you do not have yet.
Illustrative example: a water heater supplier, fictional, wants to call the plumbers of Bordeaux. He searches for plumbers in Bordeaux with a phone, exports the list to Google Sheets, shares it with his salesperson and adds a Status column. A month later he runs the search again with only new businesses to export just the newcomers. Results depend on the offer and the message.
How much a list of businesses in Excel costs
One credit per record with a phone or an email. Monthly plans go from €19 per month for 1.000 credits to €129 per month for 10.000, so between €0.013 and €0.019 per row, with no commitment and unused credits carried over (up to 2 months). You get 25 free credits every month, no card, and the sample CSV shows the exact format without an account. Details on the pricing page.
Already have an Excel file with names or websites but no emails? CSV enrichment sends it back with the contact details found, one credit per record found. To automate it, the REST API returns the same data as JSON.
Going further: the business database, the business email list, local lead generation, what to check before you buy a customer list and what a free business email list is really worth.
Ratgeber für Sie
How to find clients: methods that work for B2B companies, freelancers and local services
How to find clients for a B2B business or a freelance service: define your target, pick the right channels, reach your first prospects, follow a 30-day plan.
Lesen Ratgeber · 7 Min. LesezeitSales prospecting: B2B prospecting methods, techniques by channel and a ready-to-use prospecting plan
A practical sales prospecting guide: define your target, build a prospecting plan, choose techniques by channel, write the message and track the right numbers.
Lesen Artikel · 6 Min. LesezeitWhat is a lead in sales? A simple definition, qualified leads, MQL vs SQL and B2B leads
What is a lead in sales? A simple definition, how it differs from a prospect, qualified leads, MQL vs SQL, and what changes when you sell to local businesses.
LesenHow do I get a list of businesses in a city into Excel?
Search for a trade and a city in Prospya, add the filters you need (phone, email, no website), then click "Export CSV". The file opens in Excel by double-click or through Data › From Text/CSV, and in Google Sheets through File › Import.
Is the list of businesses by city free?
The search and the number of businesses per city are free. The export unlocks records: one credit per business with a phone or an email, free if it has neither. A free account gives 25 credits every month with no card.
Which columns does the exported file contain?
Name, category, detailed category, address, postcode, city, region, country, phone, email, website, Instagram, rating, review count and a unique ID. The export of your leads adds the pipeline stage and your note.
Why does everything show up in one column in Excel?
The file uses commas as separators, while Excel set to some European locales expects semicolons. Import it through Data › From Text/CSV and choose "Comma", or open it in Google Sheets.
How many rows can I export?
Up to 5,000 rows per export from the search. For a whole region, run several exports by city; records you already unlocked are never charged twice.
Can I export to Google Sheets, HubSpot or Pipedrive?
Yes. The CSV imports into Google Sheets, HubSpot, Pipedrive, Brevo and Lemlist. You can also keep your records in Prospya's CRM, with stages, follow-ups and call history.
Weitere Prospya-Funktionen
Ihre erste Liste in zwei Minuten
25 Gratis-Credits, ohne Karte. Erst eine Frage? Schreiben Sie uns, ein echter Mensch antwortet innerhalb eines Werktags.