Index Mellifera

Index Mellifera is the French national beekeeping database for bee selection management. BeePass imports its standard 26-column CSV format fully automatically.

Export from Index Mellifera

1. Log in to indexmellifera.fr
2. Go to Mon elevage (My apiary) in the main menu
3. Click Exporter CSV (Export CSV)
4. Save the file to your computer

The exported file contains all your registered queens, with pedigree and mating information.

Recognized columns

BeePass recognizes all 26 columns of the Index Mellifera format. Here are the key ones:

Source column	BeePass field	Description
name	Queen name	Short name of the queen
fullName	Serial number	Full identifier (e.g. FR-44-1-3-2024)
breeder	Breeder code	Breeder code in uppercase
birthdate	Birth date	Birth date or year
race	Race	Race code (B, M, C, CC, Li...)
pellet	Queen number	Annual marking color
mother	Dam name	Name of the mother queen
serial / motherCode	Dam external ID	Mother's identifier
RAMMother	Drone sire group	Mating station or SDI donor
insemCode	Mating code	1=SDI, 2=MDI
insemDate	Mating date	Insemination date
sdi	SDI code	Single drone insemination (yes/no)
coeffConsanguin	Origin data	Inbreeding coefficient (stored as JSON)

Automatic detection

BeePass detects the Index Mellifera format when 4 or more marker columns are present among the following 10:

name, breeder, birthdate, race, pellet, mother, RAMMother, insemCode, fullName, coeffConsanguin

Detection confidence: 99% — mapping is fully automatic, no user intervention required.

Imported data

The import creates F0 queens with pedigree links (dam, drone sire group). Performance evaluations are not included in this format — they can be entered directly in BeePass after import.

Data transformation

During import, BeePass automatically normalizes your data:

• Races: B becomes Buckfast, M or ML becomes Mellifera, C becomes Carnica, CC becomes Caucasica, Li becomes Ligustica
• Dates: Excel serial dates and DD/MM/YYYY formats are converted to standard dates
• Breeder codes: converted to uppercase
• Deduplication: queens with the same serial_number are updated (upsert), never duplicated

Export all your queens at once

BeePass handles deduplication by serial number (fullName). You can safely re-import the same file without creating duplicates.

See also

• Supported formats — overview of all formats
• Custom CSV / Excel — for files not automatically recognized