Water Quality & Research
Monitoring,
Education & Partnerships
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 - Tables
Gene Pool - 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 File
menu, Save As. Select a folder and a filename (e.g. H2O_TP.txt).
If your browser is Netscape, select File
menu, Save Page As. Select a folder and a filename (e.g.
H2O_TP.txt).
3) Start the Microsoft Excel program
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_TP.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.
Background Information
Water
Quality Overview
Jackson Bottom Wetlands Preserve, Connecting
Water, Wildlife and People.
TOP
HOME | About Jackson Bottom | Programs & Activities | Volunteering
Water Quality & Research | Wildlife & Habitat | Recreation
Email
Webmaster with questions or
comments about this site
|
