Data Sources & Project Management

Uploading Custom Weather Records (CSV / Excel)

[!TIP] If your project uses an on-site weather station, a local rain gauge, or data from a regional agency, you can upload a custom CSV or Excel file.

The Climate Simulator accepts standard CSV (Comma-Separated Values) and Excel (.xlsx) files containing daily historical weather records.


File Format Requirements

Organize the spreadsheet with one row per calendar day and column headers.

Required & Supported Columns

Your file should include at least three columns:

  1. Date: Daily timestamp (supported formats include YYYY-MM-DD, MM/DD/YYYY, or DD/MM/YYYY).
  2. Precipitation: Daily rainfall or snow-water equivalent (depth per day).
  3. Daily Maximum Temperature ($T_{\max}$): Highest temperature recorded during that calendar day.
  4. Daily Minimum Temperature ($T_{\min}$): Lowest temperature recorded during that calendar day.

(Optional) You may also include:

  • Average Temperature ($T_{\text{avg}}$): If $T_{\max}$ and $T_{\min}$ are missing, the engine can estimate daily ranges based on seasonal averages, though providing both daily maximum and minimum is recommended for calculating monthly temperature parameters.
  • Solar Radiation or Wind: For future evaporation calculations.

Example Spreadsheet Layout

Date Precip (mm) Tmax (C) Tmin (C)
2000-01-01 0.0 5.2 -3.1
2000-01-02 14.8 3.1 -1.0
2000-01-03 2.4 4.0 -0.5
2000-01-04 0.0 7.8 0.2

(If using US Customary units, precipitation should be in inches and temperatures in °F).


How to Upload Your File

  1. In the Data Source card, click on the Custom Upload tab.
  2. Drag and drop your file into the upload dropzone, or click Browse Files to select your file from your computer.
  3. The Column Mapping Dialog will automatically appear:
  4. Match your spreadsheet's date column to Date Column.
  5. Match your precipitation column to Precipitation Column.
  6. Match your temperature columns to Tmax and Tmin.
  7. Select your file's native units (Metric: mm / °C or Imperial: in / °F).
  8. Click Import & Process.

Handling Missing Values & Gauge Outages

Field gauge records may contain missing entries due to power or equipment outages. The importer handles these entries as follows:

  • Blank cells or NaN: Treated as missing observations.
  • Flagged codes (e.g., -999 or M): Standard missing data flags are converted to nulls.
  • Leap Years: February 29th observations are included in February parameter calculations.

[!WARNING] If your custom record contains long stretches of missing data (e.g. 6 consecutive months missing), it is best to filter out those incomplete years using the Date Range Filter so that monthly statistics are not skewed by incomplete records.