Prospya
Excel export

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

  1. 1
    Pick 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.

  2. 2
    Filter

    With a phone, with a verified email, without a website, minimum rating, only new businesses: the number of results updates with every filter.

  3. 3
    Export

    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
Email 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
Instagram 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.

Trade and city

About fifty trades; city, postcode, region or a whole country.

With a phone

For a call list: keep only businesses that have a number.

With a verified email

Domain checked to receive mail, before a campaign.

Without a website

For web agencies: businesses that do not have a site yet.

Rating and reviews

Minimum rating and review count, where known.

Only new businesses

Hides businesses you already unlocked or marked as already contacted.

Three tips once you are in Excel

BeispielPlumbers in Bordeaux in Google Sheets

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

Ratgeber · 8 Min. Lesezeit

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

Sales 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. Lesezeit

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

Lesen
How 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

Excel export

Ihre erste Liste in zwei Minuten

25 Gratis-Credits, ohne Karte. Erst eine Frage? Schreiben Sie uns, ein echter Mensch antwortet innerhalb eines Werktags.

Hilfe & FAQ

Kurze Antworten auf die häufigsten Fragen. Noch Fragen? Kontaktieren Sie uns, wir antworten innerhalb eines Tages.

Wie funktioniert Prospya?

1. Kostenlos nach Branche und Stadt suchen. 2. Gewünschte Unternehmen freischalten: 1 Credit zeigt Telefon, E-Mail, Website und Adresse. 3. Anrufen, E-Mail schreiben oder die Liste als CSV exportieren. Suche ausprobieren →

Was kostet es?

Monatstarife ab 19 € für 1.000 Credits, ohne Vertragsbindung: jederzeit kündbar, nicht genutzte Credits werden übertragen. 25 Gratis-Credits jeden Monat ohne Tarif, ohne Kreditkarte. Unternehmen ohne Telefon und ohne E-Mail sind kostenlos. Preise ansehen →

Woher stammen die Daten?

Aus öffentlichen Quellen: Karten und Verzeichnisse, die Websites der Unternehmen und ihre öffentlichen Social-Media-Profile. Wir gleichen sie ab, entfernen technische Adressen und prüfen, ob jede E-Mail-Domain Post empfangen kann. FAQ lesen →

Kann ich im Team arbeiten?

Ja, mit jedem bezahlten Tarif: bis zu 10 Personen pro Konto ohne Aufpreis, mit gemeinsamen Credits, gemeinsamem CRM, Anrufverfolgung und Statistiken pro Person. So funktionieren Teams →

Kann ich den Unternehmen direkt aus Prospya schreiben?

Ja, mit jedem bezahlten Tarif: Schreiben Sie eine E-Mail und senden Sie sie an alle Unternehmen Ihrer Suche, mit Vorlagen, KI-Texter, Abmeldelink und Nachverfolgung im integrierten CRM. E-Mail-Kampagnen ansehen →

Gibt es ein CRM?

Ja, integriert: Phasen, nächste Aktionen, Anrufe mit einem Klick erfassen, Board-Ansicht und Verlauf pro Unternehmen. Oder exportieren Sie in Ihr eigenes CRM. Funktionen ansehen →

Ist es legal, diese Unternehmen zu kontaktieren?

B2B-Akquise ist in der EU erlaubt, wenn die Nachricht für das Unternehmen relevant ist und einen einfachen Widerspruch ermöglicht. Gelistet sind nur Unternehmen, nie Privatpersonen. Datenschutz & DSGVO →

Alle Fragen Kontaktieren Sie uns

Neu bei Prospya?

Finden Sie Ihre nächsten Kunden: Restaurants, Geschäfte und Handwerker in Frankreich, Belgien und 13 weiteren Ländern.

Mit einem kostenlosen Konto können Sie:

  • Betriebe nach Branche und Stadt suchen, kostenlos
  • Telefon, E-Mail und Website freischalten: 1 Credit pro Betrieb
  • Ihre Kontakte als CSV exportieren, kostenlos
  • Ihre Anrufe und Wiedervorlagen im CRM verfolgen
  • Mit Tarif: E-Mail-Kampagnen und Teamarbeit
Mein kostenloses Konto erstellen

25 Kontakte gratis · ohne Karte · 30 Sekunden

Prospya

25 Kontakte gratis

Telefonnummern und E-Mails lokaler Unternehmen

  • Suche und Filter kostenlos
  • Gewünschte Kontakte freischalten, als CSV exportieren
  • E-Mail-Kampagnen mit jedem Tarif
  • Keine Kreditkarte nötig

Erstellen Sie Ihr kostenloses Konto

25 Kontakte gratis, ohne Kreditkarte.

Weiter mit Google
Mindestens 8 Zeichen

Mit der Kontoerstellung akzeptieren Sie die AGB.

Schon ein Konto?