The latest version of the BLS Spreadsheet (v.7.20, released January 2025) now includes a dropdown list to help with typing in names and displays back the ID difficulty score in the green columns. Please be careful with the dropdown, it saves a lot of typing time but it is easy to select the wrong option, e.g. Cladonia rangiferina rather than Cladonia rangiformis. You can still use the old names for things, the spreadsheet converts them for you. Lists of synonyms, current names and BLS numbers, as well as the substrate and scale habitat codes, are on the coloured tabs for your reference.
Please note that spreadsheet currently uses the taxon dictionary as it was in November 2024, but the recent names for the Teloschistales can be used if you wish. For now it converts them back to the more familiar names but that is a temporary measure, the synonyms will be updated as soon as the database has caught up with the changes. Please do not type anything into the green columns. If it fails to recognize what you have typed in we will sort that out as part of the import process.
It helps us if you can send in a separate spreadsheet for each vice county for which you have records, and also separate out any churchyard records, as that is how the database is organised. The spreadsheet will take up to 5,000 record lines so you can use it to accumulate records for the VC over a period of time if you wish, but we are always happy to receive smaller numbers of records for individual sites as well.
This spreadsheet is designed to be used in modern versions of Excel and so is in .xlsx format, but it should also work in OpenOffice or under windows emulation.
The Guidelines document includes help on using the spreadsheet and our substrate and scale habitat codes, and the handout from the training session run at Cober Hill in March 2019 may also be useful. Both are a bit out of date but we will be updating them, and recording short video tutorials as well, in the next few months.