How can we extract data in Excel from a website like justdial.com?

You can use “Data from web“ functionality in excel to fetch website data in the excel. which is generally used to fetch data from web pages to excel sheet. Also you can made your own web scrapper tool in excel using vba (macro) functionality. which will provide the result as per your customization. also, there are lot of tool already available in the market for data scraping you can use one of them.

Google Map Data Extractor Software

As others have stated, you should always check TOS. Many sites don’t allow scraping and if they detect a scraping bot your account can be blocked. This typically happens when you are using a services that scrapes from a single server. I wouldn’t recommend this type of service.

I would recommend Data Miner (Data Scraper), it’s a chrome extension so it’s super easy to use and I’ve never been blocked by a site when using it.

Data Miner Extract data from any websites into a spreadsheet also has pre made queries, called recipes, which makes for very fast results. No coding require and ready to go!

you can develop one yourself using VBA and Excel. Similar has been developed you can buy the same from below link at very nominal cost.