Sunday, June 16, 2019

The World's Premier Listing Software
for Birders and Naturalists!

Celebrating 24 Years Serving Birders
and Naturalists around the World!

Search this Site and the Forum Contents

Birder's Diary Forums

Importing many checklists from eBird in ONE IMPORT.
Last Post 11/16/2018 5:11 PM by Jeff Jones. 0 Replies.
Printer Friendly
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Jeff Jones
Great Gray Owl
Great Gray Owl

11/16/2018 5:11 PM

    With eBird, you have the ability to download ALL of your checklists in one file, or one checklist at a time. If you just got back form a long birding trip and have many eBird checklists to download and import into Birder's Diary, you may be wondering is there any way to do this that doesn't require importing each of the many checklists one at a time. YES!

    1. Download all of your Checklists in one file. Go to and click on the link for Download my data. Follow the instructions and you will soon have a file containing all of your eBird checklist, but in species order. Download that file to your computer.
    2. Now open the file with Excel or some other spreadsheet program. Sort your records in DATE descending order. 
      1. Select the DATE column by clicking on the header for it; this selects the entire contents of that column.
      2. Click on the Sort & Filter dropdown in the Excel toolbar. Select Sort Newest to Oldest.
      3. Now select the first Row below all the records you want to import by clicking on the ROW selector.
      4. Manually scroll the view to the bottom of the list; it may be long. 
      5. Shift+Click on the last row of data. This will select every row from #3 above down to the last row.
      6. Right Click on the row labels and choose Delete from the popup menu.
      7. Now, only the sightings you want to import from the most recent checklists you are interested in are left.
      8. Save the file back to CSV format.
    3. Import the modified CSV file using standard eBird import process in Birder's ​


    Birder's Diary Technical Support
    You are not authorized to post a reply.

    Support Tools

     TitleOwnerCategoryModified DateSize 
    GreenShot - Advanced Screen Capture ToolJeff Jones 12/18/2013UnknownDownload
    Screen Capture ToolJeff Jones 3/8/2016UnknownDownload