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

+1 to Michael's answer, Kimono is probably the most automated tool to extract data from a structured website in a scaled way.

Scrape the required data from the website using JSoup API for Java. Put the data in an excel file (.xlsx format) using Apache POI API, if you want to skip the CSV step. JSoup: http://jsoup.org/ Apache POI: http://poi.apache.org/

The best approach, in my opinion, is to parse web data using a modern programming language and then export the data as a CSV file (readable by Excel). I recommend Python, for its simplicity and the awesome modules (for HTML parsing, BeautifulSoup is really good). BTW, there are also some interesting tools to remove the CSV step and just put the data right into Excel (e.g. DataNitro)

Personal web scraper apps are spreading like wildfire these days,  Try: Kimono: http://www.kimonolabs.com/ http://import.io (vent) I hate how Quora automatically turned the URLs I entered above into links w/titles.  I'm not advertising for these sites, just trying to help the questioner.  Stop parsing my verbage, Quora!

it depends on whether the site uses javascript or not.  if it doesn't, then you can use basic python modules such at scrapy or httplib2 that rely on http get/post requests.  if it does, you'll need to control a web browser to do the data fetching automaticlally so have a look at selenium.

One of the best option is using a web data extractor or website scraper like business directory extractor, Google data extractor, Gmail extractor and so on. I have used ScraperWorld's business directory extractor for my business and marketing requirements. It automatically pull out all the data I have opted for quickly in our database, that's fantastic...

Here I  have one of the best data scraping service tool which provides web scraping service and latest technology to deliver successful web scraping of information from websites. It scrapes webpage, html , pdf , social websites, local listing, wiki, online shops, eCommerce sites, blog, podcast, and online internet resources like directories, reviews, product description; and change them into more structured formats like excel, csv , XML etc. It is called as “Easy Data Feed” and it is available on http://www.easydatafeed.com You can read about how to use it here: http://www.easydatafeed.com/open-source/ They also have developers, you can hire them to do the job for you, and their Skype is “easydatafeed”

What you are asking for is known as scrapping!Tools needed PHP, CURL, MySQL(php myadmin) :: Needs some programmingStep1: Write a php script which sends a curl GET request to the justdial page Step2: render the response over the shadow PHP_DOM element inside of the PHP Script, find the "basic DOM Pattern"(the way in which div/span/p other html tags form a tree/ or are arranged, you will see when you view source of your requested page)Step3: Extract the text inside of an hash/ object variable inside the script and push to databaseOnce you find the html dom pattern from which you want to push data to your database, recurse || loop || repeat it over all the other links you find inside of that particular page!!(in a similar way you make spiders for search engine... just follow the links inside of a given page and index out the patterns to a *MySQL database)Run Script either Locally or on the server with some optimizations and index the DB,Now its time when you open phpmyadmin and go to your database and simply export the indexed data to a CSV formatThe CSV format of the data is the scrapped out EXCEL sheet full of justdials info texts on your terms!!

Here I am suggesting you to use Oasisinfoway services. Founded by a highly experienced team of IT, and management professionals, Oasisinfoway understands the various requirements of client for technology and business, thus, provides the solutions to our valued clients. They have done lots of scraping work on 1000's of websites. As you want to scrape http://justdial.com/ You can choose oasis for this.Contact....email :