New Tool – all Climategate emails in order in Excel

Jeff Id writes:

Buffy Minton who provided the email Mime data has produced a spreadsheet of Climategate 1 and 2 emails in chronological order.  This should be an excellent tool to follow conversations through.

Here are the links:

ordered emails – xls (Office 2000, 2003)

ordered emails – xlsx (Office 2007 and later)

Note you can also load these into Open Office and LibreOffice which are both free.

0 0 votes
Article Rating
Newest Most Voted
Inline Feedbacks
View all comments
November 29, 2011 8:15 am


Greg Holmes
November 29, 2011 8:30 am

Everyone should be writing to their MP’s , members of Congress, State Governors whoever laying a stink that will not go away.
One thing politicians fear are the voters, I have already writtten to Chris Huhne telling him I shal never again vote Liberal Democrat.

Chris BC
November 29, 2011 8:42 am

Excellent. Now I would suggest providing a download with the mail files renamed in YYYY-MM-DD HH-MM format. That way they will appear in order when viewed in your file manager of choice. You might also append the From and 1st recipient to the file name.

November 29, 2011 8:50 am

Hopefully this list will assist George Osborne, “On green energy, Mr Osborne touted his environmental credentials but said: ‘We’re not going to save the planet by shutting down our steel mills, aluminium smelters and paper factories.’ “ to find some reasons to drive this resolve through the parliament past Chris Huhne.

November 29, 2011 9:05 am

I gave WUWT link to Drudge since he’s not said anything thus far.

November 29, 2011 9:41 am

@DCA: Matt Drudge knows that this email story no longer has legs. However when the Durban high-carbon-footprint schmooze fest ends with no noteworthy successor to Kyoto he might post that boondoggle on his site.

November 29, 2011 9:44 am

I am most appreciative of the person/entity who has made these emails available to the people at large.History will ,I am sure recognise his contributions to lessen the crooks’ effect on our lives by merely revealing how corrupt these scientists are and how the Governments get together to corrupt everyone and all to achieve their corrupt purposes

Bill Parsons
November 29, 2011 9:50 am

RE: “One thing politicians fear are the voters,”
Yes. They will need to be made aware (if they are stupid), then reminded – and re-reminded – that the public has little time and no money for this non-issue.
Pew (Jan, 2011): “Global warming” ranks just above “obesity” as major concern.
Neilsen: “Sustainability Survey: Global Warming Cools Off as Top Concern”
Rasmussen Report (October, 2011):
Top concerns do include government overspending and corruption. The global warming ponzi scheme should, for these reasons, be a top concern for everyone.

November 29, 2011 9:55 am
November 29, 2011 10:19 am

I love the Excel spreadsheet idea, although P. Jones may need some assistance using the spreadsheet! 😉

November 29, 2011 10:20 am

I say chaps, this is hardly cricket!
It’s Excel – how is Phil going to be able to read that?

November 29, 2011 10:25 am

Is there any speculation on how the Climategate 2 Email file names were chosen? The obvious possibility is it’s the order they were tagged to be released. The original files are time stamped with Unix time since 1970 in seconds, obvious to some of us.

November 29, 2011 10:28 am

Sorry OT but…
This comment section on the Canada refusing to contribute to the $100 Billion climate fund is very encouraging. check it out.

November 29, 2011 10:38 am

Nice file to put in gephi or pajek and get a Team Big Picture Social Network. Just parsing the field “to” and replicating the field “from”. Set output to csv and use txt2pajek to import a make a .net file. Will be very beatiful!

kadaka (KD Knoebel)
November 29, 2011 10:45 am

DCA said on November 29, 2011 at 9:05 am:

I gave WUWT link to Drudge since he’s not said anything thus far.

Drudge Report has a search function. One mention back on November 22, “climate emails”: Fresh round of hacked climate science emails leaked online…
There’s a lot happening in the world right now. This batch is still being digested, and “the opposition” is busy trying to explain how the initial results should be blamed on some strange intestinal virus the readers must have instead of the contents themselves. Wait until Congress gets involved, then they’ll get mentioned more.

November 29, 2011 11:58 am

Being a bit slow here. How do I see the email body text? I have the excel file but it looks like just a list of the emails rather than the emails themselves.

North of 43 and south of 44
November 29, 2011 12:08 pm

The out of context yappers out there best remember there are over 200,000 emails to help add even more context to the matter. Be careful what you wish for.

November 29, 2011 1:26 pm

Excel? Come on now! You know that Climate Scientists do not like modern tools.
Give them some Fortran stuff instead.

November 29, 2011 5:10 pm

About as useful as most of the climate change skeptics material. A list of file names, who knows what’s in each file?

Jimi Bostock
November 29, 2011 6:09 pm

Nice spreadsheet

November 29, 2011 6:42 pm

Buffy Minton deserves a medal, or a raise in salary, for this great effort.
The previous numerical listing coupled with the reference from these spreadsheets gives access to these emails that apparently some do not like being placed in the public arena
Comment : Tough!

Jay Davis
November 29, 2011 6:55 pm

David, as a start you can sort by sender for the 1st level, then by recipient for the 2nd level. Then look up the files in each group and see what kind of thread develops. Requires a little work, but you can do it. That is if, unlike Phil Jones, you know how to use Excel.

November 29, 2011 7:34 pm

For those looking for the source files, Climategate II full direct download here: – 173MB
If anyone missed out on Climategate 1, (about 64Mb) here’s a TinyURL link to it on Rapidshare:
(Both active as of 2 minutes ago)
My recommendation for exploring this stuff locally (on Windows) is to extract to subdirectories under one directory, and use Agent Ransack (free) rather than Find (eg Grep for Win). AR will list all files where the search item occurs, with some context. Opening this stuff with Notepad (usually the default) or Wordpad is messy. Right-mouse-click allows “open with” to any editor. Editpad Lite (and many similar editors) will clean up the line wrap, highlight email addresses, and turn URLs into click-able items.

Steve C
November 29, 2011 11:22 pm

The ‘Office 2000’earlier version works OK in ’97 too (okay, I’m a cheapskate). Very useful it is too, thanks Buffy. As for not having the text as well … how long d’you want to have to wait for it to download? 🙂

November 30, 2011 12:18 am

Have you included a HELP.txt file for Jones? (just in case he wants to have a look at the Excel…)

Buffy Minton
November 30, 2011 1:42 am

Thanks for the mostly positive comments. Of course you need to download the emails as well, or use the online search engine that Anthony links to. The idea of the spread sheet is to be able to reference the mails by author, subject or time and thus find related emails in a thread and see the chronology of a particular thread.

Buffy Minton
November 30, 2011 1:47 am

For people who don’t use Excell (Phil Jones) here is the index in CSV form:

November 30, 2011 1:50 am

This might be a thing between continents, but when I try to use the combined Climatgate 1&2 search engine from the WUWT source, I find it does not look hard for results, but comes up with smart mesages taunting me. Is it possible that it has been got at?

Brian H
December 6, 2011 12:19 am

graphicconception says:
November 29, 2011 at 10:20 am
I say chaps, this is hardly cricket!
It’s Excel – how is Phil going to be able to read that?

He’ll be able to read it. But he won’t be able to decipher what the trend line is.

Brian H
December 6, 2011 12:22 am

Steve C;
get LibreOffice. Really. It will handle everything up to the most recent formats, including ones that MS’ Orifice won’t.

%d bloggers like this: