Importing Weather Data into a spreadsheet

[u742884]

I know this is an odd request, but I'm looking for a source that can automatically import weather data (high/low temp, precipitation). I work for a retailer. The spreadsheet records daily sales by market (zip code of the stores) for the this year, last year and two years ago. We want to include weather b/c it can influence how people shop. Does anyone know of a source that I can automatically feed this data from?

Thanks as always for your help!

 

[Norie]

Why not try Data>Get External Data...New Web Query... with a suitable URL?

 

[u742884]

I was thinking along those lines. I remember messing around to collect stock price info from Yahoo. Any idea what that suitable URL might be? Ever collected weather specifically?

 

[PA HS Teacher]

For conditions each hour over the past 24 hours, you could use this site.

http://iwin.nws.noaa.gov/iwin/iwdspg1.html


I also like to look at this site,
http://www.wunderground.com/cgi-bin/findweather/getForecast?query=17033

Though I wasn't able to view the sourcecode for this one.