This file needs some post processing since it is generated raw from the database. Please follow these instructions.

  1. Remove/delete the first row of the spreadsheet. It will look something similar to this (This file is created on Thu Jun 17 8:20:43 PDT 2004).

  2. Select all cells of the first title row. Change the font to bold. You can freeze this row to be non-scrolling if you like.

  3. Select all cells in the spreadsheet, and then select Format - Column -Autofit Selection. Then (with all cells still selected) select Format -Cells - Alignment - Vertical = Top and enter a check in the Wrap Text checkbox.

  4. The next step is up to your personal preference. The Notes fields and a few others will be quite wide. Select these columns and adjust the widths to make them manageable (I suggest width=55).

  5. Sort the file as follows: Select all cells, use Common Name a primary sort key, Tree ID as secondary and Index as third. Then Sort.

  6. To save the file, the file may have quotes around the file name. Remove them. Save as Excel Workbook XLS format.