Mathematica Stack Exchange is a question and answer site for users of Mathematica. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top
data = WeatherData["WMO44207", "Temperature", {{1950}, {2013}}]

This list contains 11400 records ... date,temperature value .... I want to export all records as an XLS file. How can I do that?

share|improve this question
Take a look at the help for Export[] – Dr. belisarius May 5 '14 at 12:50

The way you want to Export data depends on your tastes and what you plan to do with the XLS file afterwards.

But as belisarius said Export is your friend:

rawdata = WeatherData["WMO44207", "Temperature", {{2013}, {2013}}]
Export["your/Path/rawdata.xls", rawdata, "XLS"]

enter image description here

If you want to Export rawdata after making some Mathematica operations on it (e.g. DateString) you can do the following:

data = Thread@{DateString /@ First /@ rawdata, Last /@ rawdata}
Export["your/Path/data.xls", data, "XLS"]

enter image description here

share|improve this answer
:) ...and what is the trick to link a comment?? – Dr. belisarius May 5 '14 at 14:04
Click on the timestamp. – Öskå May 5 '14 at 14:05
Ha! I never saw that link! Nice! – Dr. belisarius May 5 '14 at 14:07
That can be useful sometimes.. :D – Öskå May 5 '14 at 14:11

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.