Many a times we face a situation when we want to fetch data from an existing website. As the data is in html format, we retort to copying and pasting all required data manually to an excel file. But as many other languages, excel offers special objects to open web browsers from excel application and render it to read the data. These combined with the looping functionalities can be used for creating web scrappers which can automatically download all required data. We have worked with multiple clients to automate their web scrapping needs.