Directories, association member lists, trade-fair exhibitor pages and supplier catalogues show contact details for dozens of organisations per page. Copying them one by one is slow and error-prone. ScrapeSheet reads the list you are looking at and turns every entry into a row.
What it extracts, and what it doesn't
- Yes: emails, phone numbers and names that are visible on the page, plus the main link of each entry (usually its profile or website) in a Link column.
- No: it does not crawl each company's website looking for addresses, guess emails from names, or read addresses hidden in the page code. If an email isn't shown on the page, it won't appear in your sheet.
Step by step
- Open a public directory or listing page where each entry shows its contact details.
- Open the ScrapeSheet side panel and press Extract this page. Check that each entry is one row; if not, use Suggest another table or Select manually (highlight) and click one entry.
- Switch from 📊 Data to 📈 Analysis and pick the 📇 Business leads mode. It lays out company, email, phone and website, removes duplicates (same email, website or name), counts the valid emails and flags entries with missing details.
- If the directory spans several pages, set Collect to All pages (Pro) before extracting. See pagination and infinite scroll.
- Export with Excel, CSV or Sheets.
When the details are buried in text
On pages where contacts are written inside paragraphs rather than in a list — a "Contact us" page, a team page, an event programme — use the AI extraction (Pro, with your own Claude or OpenAI key) and ask, for example, list every email address and phone number with the name of the person or office next to it.
Before you email anyone
A work email such as [email protected] is personal data. In the EU the GDPR requires a lawful basis for using it and telling people where you got their details, and many countries restrict unsolicited commercial email (in Spain, for example, the LSSI requires prior consent). Collect only what you need, keep it secure, honour opt-outs, and never collect from sites whose terms forbid it.
Use it responsibly
ScrapeSheet is meant for publicly available data. It reads the page you have open in your own browser, at your own pace; it does not get around logins, paywalls, CAPTCHAs or anti-bot protection, and it should not be used to try. Before you extract, check the website's terms of use: if a site forbids automated collection, don't use ScrapeSheet there. If the data includes people (names, emails, phone numbers), privacy law such as the GDPR applies to what you do with it. More in Is web scraping legal?
FAQ
Can ScrapeSheet extract email addresses from a website?
It extracts emails that are visible on the page you have open, such as a directory or member list, and puts them in a column. It does not crawl other sites or guess addresses, so only emails shown on the page are captured.
Can it extract every link on a page?
It saves the main link of each item in a list or table, for example each company's profile or website. It is not a link crawler: it does not list every URL in the page code or follow links to other pages.
How are duplicate contacts handled?
The Business leads mode removes entries that repeat the same email, website or name and tells you how many duplicates it removed.
Is it legal to collect emails from directories?
It depends on the site's terms and on privacy law where you and the people listed are. Work emails are personal data under the GDPR, and unsolicited commercial email is restricted in many countries. Check the directory's terms and the rules that apply before using the data.
Does it reveal phone numbers hidden behind a Show phone button?
Pro can click a site's own Show phone buttons on listing pages, with a limit of 50 per run. Use it only where the site allows it.
Related use cases
Back to the ScrapeSheet home page · all use cases · ScrapeSheet Pro