Guide
A chamber's member directory, as a spreadsheet.
Almost every town and city has a chamber of commerce, and almost every chamber publishes a member directory: the local accountants, contractors, printers and restaurants that joined to be found. It is a ready-made list of real, active businesses that want to meet other businesses — and it has no export button. Open it, press one button, and the members come back as rows.
What comes out
One row per member: the name, street address, city, state,
ZIP and phone, plus a link to the member's map location and to its own
profile in the directory. The columns arrive named, so the sheet reads
City, State, Postcode, Phone rather
than col_7.
With drill-down, each member's profile page adds what the list leaves out: the business's website, fax, and its LinkedIn, Facebook and X pages, where the member has listed them.
We tried it on the member directories of three chambers in three states, all on the directory software most chambers use. Every member on every page came through.
The named columns and the profile details are in
v1.23, the version in the Chrome and Edge stores now. If your copy shows columns
headed Text 2 or Card Link, it has not updated yet: it will on
its own, or remove and reinstall it from the store.
Four steps
Want to practise first? The sandbox is fictional and nothing on it is rate-limited.
Find the member directory
On your chamber's website look for Member directory, Business directory
or Find a business. Many live at an address like
business.yourchamber.org/list, split into categories. Open one —
most show the whole category on a single page.
Click the extension icon
The members are already found and the columns named. Leave out a column by clicking its header; rename one with a double-click. Your choices are remembered for that directory.
Add each member's website
Every row links to the member's profile. Turn on drill-down and it opens each profile in the background and adds the website and social pages it finds. Free for the first three rows, so you see exactly what comes back; Pro, a one-time purchase, does every row.
Export to Excel or CSV
Press XLSX or CSV. Want the whole chamber, not one category? Put the category pages in a list and one setup runs over all of them into a single sheet (Pro; the free version runs two).
Video: How to get business leads without copy-pasting (free Chrome extension). It plays from YouTube when you press play.
Using it well
A chamber directory is a list of businesses, so keep to business details — the company, its address, its main phone and website. Chambers usually hide members' emails behind a “Send email” form, and Magic Scraper does not get past that or guess addresses.
Check the chamber's terms, and contact the businesses the way your local rules on marketing calls and email allow. In the UK and the EU the rules differ for companies and for sole traders. Is it legal to scrape a business directory? sets it out in plain words.
Reasonable questions
Will it work on my chamber's directory?
If the members are shown as cards or a table, almost certainly — it reads what your browser shows you. Some chambers use other directory software; the free version is the test, on that exact page.
Can it get members' email addresses?
Only where the directory shows them. Most chambers don't: they put a contact form in its place. Magic Scraper collects what is on the page and nothing else.
The chamber only offers a PDF member list.
Magic Scraper reads web pages, not PDFs. Look for the online directory, which most chambers keep alongside the PDF and update more often.
Is it free?
Finding the members, choosing columns, crawling and exporting are free, with no account. Drill-down past three rows, and running one setup over many category pages, are part of Pro — a one-time purchase, not a subscription.
Does my list get sent anywhere?
No. Everything happens in your browser; there is no server for it to pass through. The privacy policy has the detail.