Sign up ×
Mathematica Stack Exchange is a question and answer site for users of Mathematica. It's 100% free, no registration required.
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[] – belisarius has settled May 5 '14 at 12:50

1 Answer 1

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?? – belisarius has settled May 5 '14 at 14:04
Click on the timestamp. – Öskå May 5 '14 at 14:05
Ha! I never saw that link! Nice! – belisarius has settled 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.