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 TablesOn 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_TP.txt).
If your browser is Mozilla Firefox, 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.