Skip to content

Final London 2012 medal tally in Excel

Get the full medal tally into Excel for your own analysis.

We close our Olympics coverage (sorry “Quadrennial Corporate-sponsored Rings-based Sporting Event”) with links to some looks at the medal tally.

The Guardian continued their data analysis of the medal wins. In the end they produced a simple interactive which shows the medal count adjusted in several ways:



  • Official ranking (Gold = 3, Silver = 2, Bronze=1),
  • By population (Go Grenada!)
  • By GDP (Grenada again!)
  • By Team Size (a little surprising that China tops this list)


Medal Tally in Excel

Or you can go to their Google Docs page and download the entire Olympic results raw worksheet data including population data, GDP, team size etc to play with yourself. Copying to Excel is easy from the File | Download menu in Google Docs.

 

Note: at time of writing, the data hasn’t been updated to reflect New Zealand’s delayed win of a sixth Gold medal and other changes due to a positive doping test. If you’re playing at home with the medal tally as at the closing ceremony – deduct one Gold medal from Belarus, one silver from New Zealand and one bronze from Russia . ADD one gold medal to NZ, one silver to Russia and one bronze to China.

 

And congratulations to New Zealand for a wonderful performance overall, even before the unexpected late Gold.

The Aussies did very well too, though you’d not know it from the mean-spirited coverage in their local press. Just to show you can prove anything with statistics, an Aussie statistian has (with tongue in cheek) come up with a way to make Australia top the medal tally. All you have to do is multiply a country’s team size by the number of medal won and divide by population.

About this author