• Benadette Wambui

Data collection using web scraping techniques

Web scraping, web harvesting, or web data extraction is data scraping used for extracting data from websites. Web scraping software may access the World Wide Web directly using the Hypertext Transfer Protocol, or through a web browser. While web scraping can be done manually by a software user, the term typically refers to automated processes implemented using a bot or web crawler. It is a form of copying, in which specific data is gathered and copied from the web, typically into a central local database or spreadsheet, for later retrieval or analysis.

Among new and growing businesses, web scraping has become a familiar term, especially due to the idea that harvesting large data is necessary to stay in the market. Not all companies have what it takes to extract data through web scraping and so they outsource the services to a reputable agency. They do this because the internet contains unstructured data that cannot be used in the format in which they exist.

Below are some web scraping techniques.


Manual scraping

  1. Copy pasting

In manual scraping, what you do is copy and paste web content. This is time-consuming and repetitive and begs for a more effective means of web scraping. It is however very effective because a website’s defences are targeted at automated scraping and not manual scraping techniques. Even with this benefit, manual scraping is hardly being done because it is time-consuming while automated scraping is quicker and cheaper.


Automatic scraping

  1. Google sheets


Google sheets are a web scraping tool that is quite popular among web scrapers. From within sheets, a scraper can make use of IMPORT XML (,) function to scrape as much data as is needed from websites. This method is only useful when specific data or patterns are required from a website. You can also use this command to check if your website is secure from scraping.