Stefan Kühn, a cartographer at the University Trier, Germany, has extracted all the geo coordinates embedded in articles on Wikipedia. The WikiProject Geographical coordinates is a Wikipedia project for ensuring standardized geocoding of locations in its articles.

Google Earth fans bent on instant gratification can simply download a KMZ file and start surfing. But more importantly, coders and infoviz geeks can get a comma-separated text file (CSV) with coordinates, titles and Wikipedia categories for all points.

Link: Geocoordinates from Wikipedia for Google Earth