Categories
Development

Google Sheets or MS Excel to scrape business directories ?

We’ve already stated some Tips and Tricks of scraping business directories or data aggregators sites. Yet recently someone has asked us to do aggregators’ scraping in the context of Google Sheets and/or MS Excel.

Indeed, both Google Sheets & MS Excel provide inbuilt functions for extraction custom data of external web and even appliying regex to them. See the ancquiry we’ve got:

I need a REGEX for Google sheets to extract Social Media URLs starting with:
https://linkedin.com/
https://de.linkedin.com/
https://www.xing.com

Both Linkedin and Xing.com are business directories. They don’t expose their data that easily. Both Google sheets and Excel only allow you to fetch data with simple queries. These queries do not handle custom User-Agents, store cookies for persisted sessions, neither proxying requests… There will be no real result with that.


Browser automation with Selenuim or Puppeteer comes to resque.

We recommend you to read some of the posts on the browser automation

  1. Scraping a JS dependent website with Puppeteer
  2. JAVA, Selenium, headless Chrome, JSoup to scrape data of the web
  3. Xing.com scrape
  4. Linkedin scrape
  5. Linkeding scrape legal issue
  6. Selenuim posts

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.

This site uses Akismet to reduce spam. Learn how your comment data is processed.