Data Entry, Import and Export > Importing and Exporting Microsoft Excel and ".CSV" Data


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.

  1. Open your DSS file and select Excel from the Import popup menu from Data Entry on the menu bar, see below.
  2. If your data is in a “.csv” or blank separated file, select Time Series Data instead of Excel.


    Importing Excel or .csv Files
      
  3. 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
      
  4. The file will be read into an editable table as shown below.


    Editable Import Table of an Excel or .csv File
      
  5. 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
      
  6. From the top header row, select any columns that contain dates or times, as shown below.


    Assigning Data and Time to Columns
        
  7. You can also select individual data columns from the header popup.
  8. 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
     
  9. This will bring up a dialog to set additional pathname parts or units, as shown below.


    Import Data Window
     
  10. 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
      
  11. 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
       
  12. 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