US Army Corps of Engineers
Hydrologic Engineering Center

Skip Navigation LinksHome > software > hec-dss > excel

HEC-DSS

The HEC-DSS Excel Data Exchange Add-In is no longer supported as of 2018. The reason for the removal of this Add-in is due to HEC-DSSVue containing import and export capabilities of data between Excel and HEC-DSS file formats via the Excel plug-in in HEC-DSSVue.

Detailed training materials for using the Excel plug-in in DSSVue can be found here: Water Resources Data Management with HEC-DSSVue

An example of using the HEC-DSSVue Excel Import plugin is shown below:

From HEC-DSSVue’s menu, select Data Entry -> Import -> Excel. You will then select the Excel file you wish to import.

In order to use the plug-in, you will be using right-clicks on rows and columns to assign the data. For the example here we will:

  1. Select the ordinate cell for the first row; this should have the number “1” in it. Right click and select “Pathname Parts Row” -> C Part





  2. Select the ordinate cell for the first row; this should have the number “1” in it. Right click and select “Pathname Parts Row” -> B Part (since each column is a separate location). Select the upper left cell (above the “1”), where there is no label. Right click and select “Select all Data columns”.

  3. Select the header cell for the Date Column; This cell has the letter A in it, not the cell that has the word DateTime. Right click and select Date – Time Column -> Date and Time.





  4. Select the upper left cell (above the “1”), where there is no label. Right click and select “Select all Data columns”.



  5. For the dialog shown below, give an A, B, and F part that matches the location and type description of your data. In this case, we Leave the units blank since we are importing multiple parameters for a single location. Press the Import Now button.

This batch process can take a few minutes depending on your dataset.