Convert eBird Checklists to Christmas Bird Count Tally Sheet

Help

To use this tool, follow these steps:

1. Select your count from the Count menu.

2. Enter your sector and region numbers, or your area number in the appropriate fields.

3. Paste one or more eBird checklist URLs into the Checklists box, putting them on separate lines or separating them with commas. Checklist URLs can be obtained by displaying the checklist in eBird and copying the URL from the browser's address bar. You can specify up to 10 checklist URLs. Here is an example of an eBird checklist URL:

   https://ebird.org/checklist/S145824088

   eBird checklist counts of "x" are ignored. Species on eBird checklists that are not on the tally sheet will be added under "Additional Species" or "Other Species."

4. Click the Download Tally Sheet button to download a tally sheet for your count with the species totals from your eBird checklists.

5. Review the downloaded tally sheet for accuracy.

Multiple Checklist Options

When specifying multiple checklists, you can choose whether to produce a tally in which all of the checklists are summed in one column, or each of the checklists are represented in separate columns with a grand summed total column at the end.

To choose separate columns per checklist, enable the Separate columns for each checklist checkbox.

When producing separate columns per checklist, you can choose how the grand total column is written. The Constants option produces numeric constants in the grand totals column. The Formulas option produces a formula that sums each of the checklist columns.

The advantage of choosing the Formulas option is that you can then edit the checklist totals in Excel, and your changes will automatically propagate to the grand total column. The disadvantage is that copying and pasting the grand totals column into another spreadsheet is slightly more complicated. You will typically want to paste using Excel's Paste Special menu item and clicking the Values button in the Paste section of the resulting dialog. Otherwise, you will probably get a "#REF!" error.

Other Buttons

Display Tally as CVS displays the populated tally comma-separated values. Each line represents a row in the tally sheet. The values of each cell are separated by commas. It can be useful to examine these results before downloading a tally sheet.

Display Tally Properties displays properties of the tally sheet, including subspecies detected in the tally sheet and pseudonyms used in the tally sheet (species names that are mapped to their eBird equivalent).

Contact