eBird checklist compiler

New version! You no longer have to download your checklists; they are automatically retrieved directly from eBird!

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 spreadsheet containing data from all of the checklists. This spreadsheet has one tab for counts and a second tab for comments.


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 to AviSys checklist import will fetch the checklists directly from eBird; you no longer need to download them.

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


    S46116491, S21594122, S48759196

    S46116491 S21594122 S48759196

  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 spreadsheet.
  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.

More eBird tools

Questions or comments?