How to Use the Canadian National Climate Data and Information Archive to Find Historical Weather Data
Posted by Go iHelp Administrator, Last modified by Go iHelp Administrator on 06 August 2012 11:11 AM

Go to

1. Use the “Search by Province” section

2. Use the dropdown menu to select the province you are interested in obtaining weather information for

3. Make sure the radio button “for years from:” is enabled, and then choose the range desired

          a. Please Note: Do NOT include the current year, as it will not contain a complete dataset
          b. Change the Display results from 25 to 100
4. Click on Search
5. Locate the weather station you would like to retrieve data from in the list that appears.
          a. Suggestion: If applicable, use a major airport or weather station that is closest to the center of a major metropolitan area. This will increase your chances of exporting the largest and most up-to-date dataset available.

6. Change the “Data Interval” to Daily
7. Change the “Month” to the month you want to use to begin your data retrieval, likely this would be the first month you typically service properties for snow removal, or the month when the first snowfall typically occurs.
8. Change the “Year” to the year you would like to use to retrieve your weather data.
9. Select “Go”
10. Your search results will display, see example below.

11. Be sure there is a sum listed in the “Total Snow” column
          a. Please note that the weather data is listed in Centimeters (cm), NOT Inches (in). Our Snow Proposal Builder requires inches, so you will need to convert your totals from cm to in before entering in the snow proposal builder.
12. Scroll to the bottom of the page to the “Navigation Options” section

13. Click the CSV link located next to “Download Data” to save a spreadsheet with the weather data to your computer. The spreadsheet will contain data for the entire year, so you will not have to download each month individually.
14. Once the spreadsheet has been saved, scroll back up until you can see the space just above the “Navigation Options” section and just below your previously displayed results.

15. Change the year to the year after the original year you searched and hit “Go”. For example, if you chose to obtain data for the year 1999, change the year to year 2000.
16. Ensure that the year has changed in the “Download Data” portion of the “Navigation Options” section.
17. Click the CSV link located next to “Download Data” to save a spreadsheet to your computer.
18. Continue this process until you have downloaded the range of data that you believe will adequately represent your snowfall history. Remember that you are trying to get an “average” amount. We recommend downloading 5 to 10 years of weather history for an adequate dataset.

(0 vote(s))
This article was helpful
This article was not helpful

Comments (0)
Post a new comment
Full Name:
CAPTCHA Verification 
Please enter the text you see in the image into the textbox below. This is required to prevent automated registrations and form submissions.

Help Desk Software by Kayako