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 »

Upload Data: Resources for Registered ATTAINS Users

Back to Main ATTAINS Page

The ATTAINS system allows registered state or tribal users to create Assessment Units and upload assessment decisions about those Assessment Units for their organization. In addition, the ATTAINS system allows registered EPA users to provide comments about assessment decisions, and to review Clean Water Act Section 303(d) lists of impaired waters. Users may work directly with the web user interface, batch upload files within the user interface, or submit data via the Exchange Network data flow.

Jump to:

ATTAINS Registration Information

Registered users may access the ATTAINS User Interface here.

Top of Page

ATTAINS Exchange Network Tools

Resources regarding submitting data through the Exchange Network - ATTAINS data flowExitare available on the Exchange Network page.

  • The Flow Configuration Document provides information on service end points
  • The Data Exchange Template provides information on the required versus optional fields in ATTAINS

Top of Page

ATTAINS User Interface Tools

  • Batch Upload Templates
    • Assessment Unit Batch Upload Template (83 K, 3/11/2020) - This Excel template can be used to upload new Assessment Units or update information about existing Assessment Units through batch upload capability in the ATTAINS User Interface. The file allows users to provide information such as Assessment Unit ID and Assessment Unit Name as well as Water Types, Locations and Monitoring Stations associated with the Assessment Unit.  After entering the information, save each tab of the file as a .CSV.  To upload this file, go to the Assessment Units tab and select "Upload Assessment Units" from the Menu button.
      • Bulk Rename Template(12 K, 09/20/2019)  - This template can be used to rename Assessment Unit IDs from an existing ID to a new ID.  This file is not for Splits or Merges because those can only be done in the User Interface.  After entering the information, save the file as a .CSV.  To Upload this file, go to the Assessment Units tab and select "Manage Assessment Units" from the Menu button.
      • Bulk Retire Template(12 K, 09/20/2019)  - This template can be used to retire Assessment Unit IDs.  Retired Assessment Units can be seen in ATTAINS, along with historical assessment decisions, but no new assessments may be associated with them.  After entering the information, save the file as a .CSV.  To upload this file, go to the Assessment Units tab and select "Manage Assessment Units" from the Menu button.  Note:  Retiring an Assessment Unit is permanent.
      • If you need to delete a series of Assessment Units such that they do not appear in ATTAINS at all, please contact your Data Management Coordinator for assistance.

    • Assessment Batch Upload Template(101 K, 10/28/2020)   - This Excel template can be used to upload Assessment decisions about Assessment Units. The file allows users to provide information on the last time the Assessment Unit was monitored and assessed. It also includes the Uses that apply to the Assessment Unit and the decisions about those Uses. It also includes the Parameters that were assessed and the decisions about the parameter (whether it was meeting criteria, a cause of impairment or an observed effect), and any Sources of impairment.    The file also includes a Seasons tab if the Organization applies different Assessment decisions for different seasons during the year.  After entering the information, save each tab of the file as a .CSV.  To upload this file, go to the Assessments tab and select "Upload Assessments" from the Menu button.
    • Associated Actions Upload Template(13 K, 3/11/2020) - This template can be used to associate existing Action IDs in ATTAINS to the Assessment decisions to help ATTAINS calculate waters into the appropriate EPA IR Category.  For example, if the state or region had entered an Action into ATTAINS between reporting cycles and the state would like to Associate that Action with the Assessment for the next Integrated Reporting cycle, this file can be used.  After entering the information, save the file as a .CSV.  To upload this file, go to the Assessments tab and select "Upload Assessments" from the Menu button.  If the Action ID has not been entered into ATTAINS yet, this Associated Actions Upload Template will not work.
    • TMDL Action Batch Upload Template(118 K, 3/26/2020)  - This excel template can be used to upload TDML Actions.  Only Draft Actions may be uploaded.  Any data entered for an Action ID will replace existing information about that Action ID.  After entering the information, save the file as a .CSV.  To upload this file, go to the Actions tab and select "Upload Actions" from the Menu button.
    • Non-TMDL Action Batch Upload Template(93 K, 3/11/2020)  - This Excel template can be used to upload Actions for 4B Restoration Approach, Alternative Restoration Approach, and Protection Approach Actions, as well as the Actions that do not require EPA approval.  (The TMDL Batch Upload is separate because it contains different required fields.)  After entering the information, save the file as a .CSV.  To upload this file, go to the Actions tab, and select “Upload Actions” from the Menu button.
  • Domain Values – Allowed values for restricted value fields in ATTAINS
    • DOMAINS(3 MB, 1/12/2021)  – This file is connected to ATTAINS Services. It can be updated to the latest domain values by downloading the file, going to the Data tab in the Excel Ribbon and clicking on “Refresh All”. Note: In order to refresh the spreadsheet to the latest values,  you must have Office 2016 or later.
  • Transitioning from ADB to ATTAINS
    • TN_ATTAINS_BATCH_from_ADB.zip(1 pg, 8 MB, 02/08/2018) – Tennessee developed some queries for the Assessment Database (ADB) that create Batch Upload queries to help populate ATTAINS.

Top of Page

Tutorials and Training

Top of Page


Back to Main ATTAINS Page

This returns users to the ATTAINS landing page.

Get Data: Access Public ATTAINS Data

This page provides access to public ATTAINS data in How’s My Waterway, ATTAINS Web Services, ATTAINS geospatial service, and historical National Water Quality Inventory Reports to Congress.

ATTAINS Program Information

This page provides links to background information about the Clean Water Act Sections 303(d), 305(b), and TMDL programs, including links to Integrated Reporting Guidance.