How to Import Your Loft via CSV

Migrate your entire existing pigeon database from Excel or any spreadsheet with smart field mapping.

4 min read Silver plan and above Bulk import

If you already manage your pigeons in Excel, Google Sheets, or any other tool, you don't need to re-enter everything manually. The CSV importer lets you upload your entire database at once, with automatic field detection for ring numbers, dates, sex, and more.

CSV import is available on Silver plan and above. Free plan users can add pigeons manually or use the AI scanner (5 scans/month included).

Step 1 — Prepare Your CSV File

Export your spreadsheet as a .csv file. The importer accepts UTF-8, Windows-1252, and Latin-1 encodings — so files saved directly from Excel work without any conversion.

Your CSV needs at minimum a ring number column. All other columns are optional but recommended:

Column nameRequired?Notes
ring_numberRequirede.g. NL 20-1739393 M
nameOptionalPigeon's given name
sexOptionalM / V / Male / Female / 0 / 1
year or birth_dateOptionalYear (2020) or date (01/01/2020)
breedOptionale.g. Racing Homer
colourOptionale.g. Blue Bar
father_ringOptionalRing number of father — auto-links if present
mother_ringOptionalRing number of mother — auto-links if present
statusOptionalactive / sold / deceased / lost

Example CSV content:

ring_number,name,sex,year,breed,colour,father_ring,mother_ring NL 20-1739393 M,GABBAR,M,2020,Racing Homer,Blue Bar,NL 17-1115599 M,NL 15-1538924 V NL 17-1115599 M,ERIK,M,2017,Racing Homer,Blue Bar,, NL 15-1538924 V,MEALY 24,V,2015,Racing Homer,Mealy,, NL 09-2010686 M,NICK,M,2009,Racing Homer,Blue Check,,

Column names are flexible: The importer auto-detects common variations — ring, ringnumber, ring nr, name, pigeon_name all map correctly. You don't need to rename your columns.

Step-by-Step

Go to the Scanner / Import Page

In the sidebar, click Scanner, then click the Import CSV tab at the top of the page.

Upload Your CSV File

Drag your .csv file into the upload area or click to browse. Files up to 10MB are supported — that's enough for thousands of pigeons.

Review Column Mapping

The importer shows you how it has mapped your columns to database fields. Confirm or correct any mappings using the dropdown selectors. This step takes about 30 seconds.

Preview and Confirm

A preview table shows the first 10 rows of your import. Check that ring numbers, names, and sex look correct. Then click Import All Rows.

Review the Import Report

After import, you'll see a summary: pigeons added, pigeons updated (if duplicates), parent links created, and any rows that were skipped with the reason. Download the report as CSV for your records.

How Parent Linking Works

If your CSV includes father_ring and mother_ring columns, the importer automatically links offspring to their parents — building your pedigree trees in bulk. Parents referenced in these columns will be created as placeholder pigeons if they don't already exist in your database.

Troubleshooting

My file uses semicolons instead of commas

Common with European Excel exports. The importer auto-detects the delimiter (comma, semicolon, or tab). If it doesn't detect correctly, save your file as CSV UTF-8 from Excel's "Save As" dialog and try again.

Dates aren't being read correctly

The importer handles DD/MM/YYYY, MM/DD/YYYY, YYYY-MM-DD, and year-only formats. If your dates show as wrong, check the column mapping step and select Date (European) or Date (US) from the format dropdown.

Some rows were skipped

Rows are skipped if the ring number is empty, the ring number is a duplicate (existing pigeon with no changes), or the row contains invalid data. The import report shows exactly which rows were skipped and why.

Ready to Migrate Your Loft?

Upgrade to Silver and import your entire database in minutes.

Get Started