Getting Your List of Confirmed Species

By Julie Hart June 16, 2020
Black-throated Green Warbler Setophaga virens

Many people have been asking how to get a list of all the species they have confirmed. You can’t get it by clicking on your total confirmed species on the atlas home page; that will take you to your life list. There is no direct way to get the list, but you CAN get it with a bit of work in Microsoft Excel or LibreOffice. I’ve included instructions for Excel below, but it’s the same steps in LibreOffice just with slightly different naming.

Instructions for MS Excel

1. Download your data

  • Go to My eBird in core eBird. (If you go to My eBird in the Atlas portal, the option to download your data is not available.)
  • In the right sidebar near the bottom, click on “Download My Data.”
  • Submit your request and wait a few minutes for an email from eBird that gives you a link to download you data.
  • Save the linked CSV file to your computer.

2. Filter and sort your data

  • Open the CSV file in Excel (or LibreOffice).
  • Select the columns with data (columns A through W).
  • In the Data menu, select “Filter.” All the columns should now have a small arrow/drop-down menu that allows you to filter the data.
  • In the Date column, go to “Date Filters” and select “This Year.” You should now only see data from 2020. (In future years, you will have to select “After” and enter 1/1/2020.)
  • In the Breeding Code column, scroll down and deselect the check mark next to all the Possible and Probable codes and Blanks. Remember that the Confirmed codes have two-letter abbreviations. You should end up with check marks next to the 10 confirmed codes. Hit OK.
  • Now you only see records with a Confirmed breeding code, but you may have multiple records of the same species, so you need to get unique values.

3. Get unique records

  • Create a new sheet/tab by clicking on the + symbol at the bottom left of your screen to the right of MyEBirdData.
  • Copy the “Common Name” column to the new sheet.
  • Select the “Common Name” column in the new sheet. In the Data menu, select Advanced Filter. Click OK on the warning about column labels to use the first row as the column name.
  • In the Advanced Filter window, select “Copy to another location.” In the “Copy to” box, select a different column or type in “Sheet1!$C$1.” Lastly, select “Unique records only” and hit OK.

You now have your unique list of confirmed species! You can do this whenever you want or you can keep track of your confirmations in this new spreadsheet.

Happy atlasing!