Importing Data from
Microsoft Excel or “.csv” files using Time Series Wizard
You can import multiple columns of time-series data from Excel, a “.csv” file, or a blank
separated file using the Time Series Wizard. The Time Series Wizard is
a plug-in that is distributed in a development stage; check the HEC-DSSVue plug-ins web
page for updates.
-
Open your DSS file and select Excel from the Import popup menu from Data
Entry on the menu bar, see below.
-
If your data is in a “.csv” or blank separated file, select Time Series Data
instead of Excel.

Importing Excel or .csv Files
-
Select your file to import, as shown below. Data should be in columns, separated by
comma or spaces. Ideally, a row should contain a location or parameter, and a
column should contain date/time.

Selection of an Excel or .csv File to import into HEC-DSSVue
-
The file will be read into an editable table as shown below.

Editable Import Table of an Excel or .csv File
-
Select any location, parameter, units, or version, etc. rows by right clicking on the
header row in the first column and selecting the item, as shown below. You may also
skip any rows that are not to be imported or used.

Assigning Locations, Parameters, Units, Versions, etc. to Rows
-
From the top header row, select any columns that contain dates or times, as shown
below.

Assigning Data and Time to Columns
-
You can also select individual data columns from the header popup.
-
Alternatively, you can enter all data into DSS at one time by right-clicking the upper
left cell and selecting Set All Data Columns, as shown in the figure below.
The resulting window will look like the second example figure below.

Select all Data and Columns to Import

Window after Selecting Select All Data Columns
-
This will bring up a dialog to set additional pathname parts or units, as shown
below.

Import Data Window
-
Enter additional information desired. To import all the data sets, press the
Import Now button. A confirmation window will appear, see below.

Import Data Confirmation Window
-
Alternatively, if all columns are not to be imported, individual data set columns can be
imported by right clicking on the header row of the column and selecting Set
Data Column. This will bring up the window shown below.

Import Data Window
-
Fill in the additional information and press Import Now if you are finished
importing data from this file, or press OK to select other columns. When you
have selected all the columns you want to import, press the Import Now button, or
the Import button at the bottom of the table. A confirmation window will appear,
see below.

Import Data Confirmation Window