eBird checklist compiler

Checklist input
Click to fetch the specified checklist(s) from eBird.

What it is

You can enter multiple eBird checklist subIds into eBird checklist compiler, and it will return a single Excel workbook containing data from all of the checklists. This workbook has one spreadsheet for counts and a second spreadsheet for comments. The cells of the two spreadsheets are aligned.


A compiled spreadsheet is handy for compiling a Christmas Bird Count, or other such group count. You might also like such a spreadsheet to summarize a trip, or multiple visits to a location, for example.

What you do

  1. In the “Checklist input” form above, list one or more checklist names and click “Go!”. eBird checklist compiler will fetch the checklists from eBird.

    Let's say you have a checklist https://ebird.org/checklist/S60513355. You can copy-and-paste just the "S60513355", or you can copy-and-paste the whole "https://ebird.org/checklist/S60513355". If you enter multiple checklists, enter them on separate lines, or else just separate them with spaces or commas. For example you could enter

    S60513355, S60533760, S60593564, S60652303
    S60513355 S60533760 S60593564 S60652303
  2. Click Go! and wait for the checklists to be retrieved from eBird (it takes a while).
  3. You'll be prompted to open or save the generated Excel workbook.
  4. Note: Excel may open in “PROTECTED VIEW”, displaying an “Enable Editing” button. You will need to click this button if you want to see the row and column sums; otherwise they are displayed as zeros. The presentation of the Enable Editing button may vary between different spreadsheet programs and versions.
  5. Beware! The eBird API that this application uses suppresses data on sensitive species. If you have any checklists that contain sensitive species, you will need to add data for those species to the workbook manually. Similarly, the API will not download checklists that are hidden for any reason. If you have any hidden checklists you will have to enter their data manually. These are eBird policies; there is nothing this application can do about it.

More eBird tools

Questions or comments?