PiscesLogoSmallerStill Open an existing data file

Top  Previous  Next


Use either File: Open or the left hand button on the tool bar to select a data file for analysis. A list of previously-used files is available under Reopen on the File menu:





Species Diversity & Richness 4 will open either comma-separated text (*.csv) of Microsoft Excel spreadsheet files (*.xls). With Excel files, it is important that a number of points are observed:

1. If you are using an Excel file with multiple worksheets, the data will be imported from the worksheet that was open (visible) when the file was last saved.

2. The data should be present as a contiguous rectangular block, starting at Cell A1.

3. Cell A1 itself should be empty, with sample names present in Row 1 and variable (species) names present in Column 1.

4. The import procedure ignores formulae in cells and imports the visible values.

5. Ensure that all cells rightwards and downwards from cell B2 contain numerical data.

6. CAP can import directly from Excel whether Excel is open or not, provided the worksheet has been saved.


SDR requires all numbers in the data set to be either binary presence-absence data (i.e. 0 or 1), or positive integers; in opening a data set, the program will check the data and alert you to any non-standard numbers which would cause the program to fail. You can then edit the data set to correct these data points, either in the original spreadsheet program, if you used one, or using the Edit Open Dataset button.


Once the file is opened, its name is displayed in the tool bar towards the top left of the main window, and the number of species it contains is given in the information bar at the base of the window. The General Statistics window will be displayed, showing all the available statistics on the data set.