Make a key from a spreadsheet

Write a dichotomous key in Excel or Google Sheets, save it as CSV, and turn it here into an interactive page that works offline on a phone. There is nothing to install: this page runs dimoose in your browser, and your files never leave your computer.

1. Choose your files

Starting R in your browser…

How to write the spreadsheet

One row for each lead (each choice). The two or more leads of a couplet share its number. Download the Montana spreadsheet to use as a template.

CoupletQuestionDescriptionGoes toSpeciesPhoto
1Leaf type?Leaves compound, divided into leaflets.2ash_leaf.jpg
1Leaf type?Leaves simple, a single blade.3
2Leaflets?3 leaflets with a few coarse teeth.Box elder (Acer negundo)boxelder
2Leaflets?5 to 7 leaflets with toothed margins.Green ash (Fraxinus pennsylvanica)

Couplet and Description are required. Each row needs either Goes to (the couplet it leads to) or Species (the result), not both. Question and Photo are optional; several photos are separated by semicolons and the file extension may be left out. If a description contains a comma, the spreadsheet program puts it in quotes for you when it saves the CSV.

Problems in the sheet are reported by row number, so you can fix the row and try again.