An official website of the United States government.

This is not the current EPA website. To navigate to the current EPA website, please go to www.epa.gov. This website is historical material reflecting the EPA website as it existed on January 19, 2021. This website is no longer updated and links to external websites and some internal pages may not work. More information »

Water Quality Exchange Web Template Files

Note About Template Files

The templates are made up of two Microsoft Excel spreadsheet files that are meant to be used together to assist with data tracking and entry. The WQX Web Template Dictionary file provides guidance on the appropriate use of each data element, highlighting the data elements that are available in the WQX Web Template and showing the additional data elements that a user may add to the template. The dictionary covers data elements for all templates including:

  • Physical-Chemical Results
  • Biological Results
  • Habitat Results, Activity Metrics and Indices
  • Continuous Monitoring Results
  • Lab Results

Many of the templates contain sample data that can be imported into WQX Web using the following import configurations (for more information regarding how to use Import Configuration files in WQX Web, please see the WQX web tutorials).

drawing of a ketone compound

WQX Web Template User Guide

This is a step by step guide to use the WQX Web Template for Physical/Chemical data.  The document will assist in preparing data for import into the WQX Web tool and subsequent transfer to the Water Quality Portal.

A Prerequisite to Importing & Submitting Activities and Results is #1 Import Projects, #2 Import Monitoring Locations (Stations).  Sample Collection Method and all user owned methods are edited and registers via WQX Web's "domains value menu."

Import Configuration: (common to all spreadsheet templates)

Import & Submit

Type of Data

.WQX 3.0 - Template Project (Template) ~ 7039

Projects

.WQX 3.0 - Template Monitoring Location (Template) ~ 7040

Monitoring Locations

WQX Web 3.0 Physical/Chemical Results Template (ZIP) (983 K)

Import Configuration:

Import & Submit

Type of Data

.WQX 3.0 - Physical/Chemical (Template) ~ 7043

Results & Activities

The Physical-Chemical Results Template is provided to assist in formatting the regular results data, such as physical and chemical results that have been sampled and analyzed.


microphoto of a diatom closterium dianae

WQX Web 3.0 Biological Template (ZIP)(2 MB)

 

The Biological Template is provided to assist in formatting biological results.
*Note this template does not include the data elements for submitting biological metrics or indexes; these are handled using a separate WQX Web template file.

Import Configuration:

Element

Type of Data

.WQX 3.0 - Template Biological (Template) ~ 7045

Results & Activities


Photo of a reference stream

WQX Web 3.0 Habitat Template (ZIP)(557 K)

 

The Habitat Template is provided to assist in formatting habitat results.
*Note this template does not include the data elements for submitting metrics or habitat Indexes; these are handled using the WQX Web Metric-Index Template.

Import Configuration:

Element

Type of Data

.WQX 3.0 - Template Habitat (Template) ~ 7044

Results & Activities


Photo of Blue Heron

WQX Web 3.0 Metric Index Template (ZIP)(352 K)

The Metric- Index Template is provided to assist in formatting biological and habitat metrics and indices.

Import Configuration:

Element

Type of Data

.WQX 3.0 - Template BioHabitat Index (Template) ~ 7041

Indexes

.WQX 3.0 - Template Metric (Template) ~ 7042

Metrics & Activities


drawing of a ketone compound

WQX Web 3.0 Lab Template (ZIP)(1 MB)

 

The Lab Template is provided to assist in formatting physical and chemical results.

Import Configuration:

Element

Type of Data

.WQX 3.0 - Template Lab (Template) ~ 7046

Results & Activities


WQX 3.0 Continuous Template (ZIP)(3 MB)

Our recommendation for continuous monitoring data is to report to WQX a single activity in which you store the actual probe readings using every (4 hours, 2 hours or evenly distributed) intervals and to which you attach at the activity level a binary object formatted as text (".txt") file or compressed (".zip") file format for archiving the complete raw set of probe readings downloaded from the data logger.  This works equally well for the fixed data logger and for the so-called CTD cast, when the data logger is deployed off the side of a ship or pier and allowed to freely descend through the water column and report continuously the readings of its probes.

The CTD typically also yields results for thermocline, halocline and pycnocline depths, which can be added to the results associated with the activity. An additional comment could be included to indicate that this activity is a fixed data logger. The activity information and the "Document/Graphic" file will be available on the Water Quality Portal after export to EPA.

The Continuous Monitor Data Results Template is provided to assist in formatting the regular results obtained using a portable data logger, such as YSI probe.

Import Configuration:

Element

Type of Data

.WQX 3.0 - Template Continuous (Template) ~ 7047

Results & Activities