PiscesLogoSmallerStill Creating a data file using a spreadsheet

Top  Previous  Next

A data set is stored as a comma-delimited text file with the extension .csv. Removal Sampling will also open Excel files. It is normal to initially organize your data in a spreadsheet such as Excel. The data are organized as a simple 2-dimensional array as follows:


excel demo


This example is the demonstration file RemovalDemo.csv opened in Excel.


You should create a completely new spreadsheet file, and enter your data into it, rather than create a new sheet on an existing spreadsheet - which might for instance contain raw data and other information from your sampling. This is because the csv file format can only support a single worksheet. Make sure that no other data apart from the sample data grid is present on the worksheet. It is good practice to select the first 10 or so rows and columns, below and to the right of the data grid, and press the Delete key, to remove any data or blank spaces accidentally entered into cells outside the data grid.


When you have added all the data to your data set, click File: Save As, choose a name for your file, and select CSV (Comma delimited) (*.csv) from the Save as type drop-down menu (see below). You will receive a warning that the CSV file type does not support workbooks containing multiple sheets; press OK to ignore this warning, then click 'Yes' to ignore the next warning, that the sheet might contain features not compatible with CSV.