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:
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.