How to turn a paper bird list into a spreadsheet

In short: photograph every page first. Then make four columns (Species, Date, Place, Notes), type one row per bird, and use today's bird names and month/day/year dates. Save a CSV copy and keep it in two places. The notebook stays as your original.

Some of the best bird lists ever kept live in pocket notebooks, field guide margins and the backs of old checklists. They're precious, and they're fragile: one copy, fading ink, and no way to search them. Typing your list into a spreadsheet fixes that. It may take a few evenings, and you end up with a list you can sort, search and copy somewhere safe.

Key facts

• The Library of Congress advises making at least two copies of important personal records, stored as far apart as is practical.
• Excel's Remove Duplicates keeps the first occurrence of each value and deletes the rest (Microsoft Support).
• eBird can import a spreadsheet in its "Record Format" as a CSV file of up to 1 MB per file.
• For a pre-eBird life list with mixed dates and places, eBird suggests one Incidental checklist per country, dated January 1, 1900.
• Some names have changed: North America's familiar Herring Gull is now American Herring Gull (AOS, August 2025).

Facts checked: September 30, 2026.

Before you type: photograph every page

Start by photographing or scanning each page of the notebook. That gives you a second copy straight away, even before the typing is done.

The Library of Congress gives the same advice for any important personal records: make at least two copies, and keep them in different places, as far apart as is practical.

Set up four columns

Open a new spreadsheet in whatever you have: Excel, Google Sheets or Apple Numbers. Type these headings in the first row:

Species, Date and Place are the three things that make a list worth keeping. Notes is optional, for anything else you want to remember.

One row per species is enough for a life list: the first time you saw it. If your notebook records every sighting and you'd like year lists too, one row per sighting works just as well. The section below shows how to pull your life list out of it.

Species: use today's names

• Write the full common name, one bird per row: "Red-tailed Hawk", not "RTHA" or "red-tail".
• Update names that have changed. Bird names and species change over time (see bird splits and lumps). For example, the familiar Herring Gull of North America is now called American Herring Gull. Keep the old name in Notes if you like.
• Be careful with old scientific names. After a split, an old scientific name can belong to a different bird. Numenius phaeopus used to cover every Whimbrel; today it means the Eurasian Whimbrel, and North America's common one is Hudsonian Whimbrel, Numenius hudsonicus.
• Leave out birds you weren't sure of, or keep them in Notes. A "hawk sp." won't count as a species on any list.

Dates: month/day/year

• Type full dates as month/day/year, such as 5/12/1990. Spreadsheets recognize them as dates, and eBird's spreadsheet import uses the same order.
• Only know the year or the season? Leave the Date cell empty and write "spring 1985" in Notes. "1985" on its own isn't a full date, and programs that read lists may skip it.
• Don't guess. An empty date is honest. You can fill it in later if an old trip report turns up.

Places: a name you'd recognize

Write the place the way you'd tell a friend: "Cape May Point State Park, New Jersey", or just "Tucson, Arizona". Include the state or province. You don't need map coordinates.

Make a life list from a sightings log

If you typed one row per sighting, your spreadsheet already holds your life list: it's the first row for each species. To see it on its own:

1. Work on a copy. Duplicate the sheet first. Removing duplicates deletes rows for good, so, as Microsoft puts it, "it's a good idea to copy the original range" first.
2. Sort by Date, oldest first. Check any rows with no date by hand: a sort can't tell which came first.
3. Remove duplicates using the Species column only.
   • In Excel, choose Data, then Remove Duplicates, and tick only Species. Microsoft says Excel keeps the first of each value, which after sorting is your earliest sighting.
   • In Google Sheets, choose Data, then Data cleanup, then Remove duplicates, and tick only Species. Google's help doesn't say which row it keeps, so check a few species afterward: each should keep its earliest date.
4. Count the rows. The number of rows, minus the heading row, is your life list total.

A year list works the same way: copy the sheet, keep only the rows from one year, then remove duplicates. (Not sure of the difference? See life list vs year list.)

Save it the right way

1. Save the spreadsheet as normal, in its own format.
2. Also save a CSV copy. CSV ("comma-separated values") is a plain text file that almost any program can open, now and in the future.
   • In Excel, choose File, then Save As (or Save a Copy), and pick a CSV type in the file type box. Excel saves only the sheet you're on, and drops formatting such as colors.
   • In Google Sheets, choose File, then Download, and pick the CSV option.
3. Put the date in the file name, such as "life-list-2026-10-01.csv", so you always know which copy is newest.
4. Keep copies in more than one place. Our guide to backing up your birding records walks through it.

Where your spreadsheet can go next

Into eBird. eBird's help center describes how to add a life list from before you joined. If your old records mix many dates and places, it suggests one "list-building checklist" per country, using the Incidental type and the date January 1, 1900. Sightings with exact dates and places can go in as ordinary historical checklists. eBird can also import spreadsheets in its own "Record Format", as a CSV file of up to 1 MB.

Into a book. Birdfolio reads a simple list like this one. On the make page you can paste your rows or drop the CSV file. It looks for the headings Species, Date and Place and skips other columns, such as Notes. If an old name isn't recognized, it tells you, so you can update it.

Keep the notebook

A typed list is easier to use, but the notebook is the original, in your own handwriting. Store it somewhere dry, alongside your photos of its pages.

When your list is typed up, you might enjoy seeing it laid out properly: look inside a Birdfolio, or read more about what a life list is.

Birdfolio is not affiliated with eBird, the Cornell Lab of Ornithology or iNaturalist.