Jackson Bottom Wetlands Preserve

Providing interpretive education on wetlands and wildlife, panoramic views, water quality, weather, natural resource management, trails, bird watching, recreation, exhibits, displays and an eagles nest, Jackson Bottom Wetlands Preserve is a treasure of the Hillsboro community.

How to Download Data

How to Download Data Tables

How to Load Water Quality Data into a Spreadsheet

1) Click on the Link to Comma-Delimited Data

Find links to comma-delimited data on one of the following water quality web pages:

Tualatin River Water Quality Data Tables
Jackson Bottom Slough Water Quality Data Tables

On that web page, click on the link Comma-Delimited Data for Spreadsheet

2) Save the Data in a Text File

If your browser is Internet Explorer, select Page menu, Save As. Select a folder and a filename (e.g. H2O_TR.txt).

If your browser is Mozilla Firefox, select File menu, Save Page As. Select a folder and a filename (e.g. H2O_TR.txt).

3) Start Microsoft Excel

4) Open the Text File

In Excel, open the same file (same folder and same filename) that you saved in Step 2) above. To open a file in Excel, select File menu, Open.
If you do not see the file in the same folder, you may need to change Files of type: to Text Files (*.prn; *.txt; *.csv) or All files (*.*).

5) Text Import Wizard: Step 1

The Text Import Wizard should automatically pop up when opening a text file.
Make sure that Delimited is selected.
Click Next to proceed to the next step.

6) Text Import Wizard: Step 2

Select the Comma delimiter. It's OK to leave the Tab delimiter selected.
Click Finish to complete the wizard.

7) Examine the data in the Spreadsheet

If the first column (labeled A) has data shown as ########, then increase the width of that column. To do this, locate the cell in the top row with the column labeled A. Click on the right border of this cell, hold and drag the mouse to the right, then release the mouse. Continue to increase the width of the column until you can view the date and time data.

8) Save your new Spreadsheet as an Excel Workbook

Select File menu, Save As. Select a folder and a filename (e.g. H2O_TR.xls).
You may need to change Save as type: to Microsoft Excel workbook (*.xls).

9) Insert a Chart and create Graphs

Refer to Microsoft Excel Help for Create Chart for an XY Scatter chart.