Cool google and wikipedia mashups

Reading Time:

[![A map of population centers generated using wikipedia](](

I do like a nice mashup and they are not just the preserve of techies as an ever increasing range of tools means the humble journo can mash with the best of them.

In that spirit I wanted to share a great post by Tony Hurst where he explains how you can  ‘Data scrape’ Wikipedia with Google Spreadsheets to get a map like the one above.

[W]e have scraped some data from a wikipedia page into a Google spreadsheet using the =importHTML formula, published a handful of rows from the table as CSV, consumed the CSV in a Yahoo pipe and created a geocoded KML feed from it, and then displayed it in a YahooGoogle map.

As Tony says ‘Kewel :-)’

It may sound arcane but don’t be put off by the seemingly techy.  Tony provides a reallu usable tutorial and the key thing is to experiment with data that’s relevent to you.

Go on, release the inner geek and have a play*

Interesting links for Monday

[Tweet]( I have mostly been reading Motorway camera map – JP’s deal with the highways agency produces a neat little map....

Making your stills camera look more like a video camera

[Tweet](’m holed up in the Middlesbrough Central Travelodge and getting some kind of insight in to what living in halls...   Never miss a story from, get updates in your inbox.