Skip to main content

Custom CSV / Excel

Your file is not in Index Mellifera, BeeBreed, or beeXML format? The BeePass importer accepts any spreadsheet and guides you through mapping your columns to the BeePass schema.

Accepted formats​

TypeExtensionsNotes
CSV.csvSeparator detected automatically (comma, semicolon, tab)
Excel.xlsx, .xlsIf the file has multiple sheets, you choose which one to import

Maximum size: 5 MB / 10,000 rows.

Step 1 — Upload​

Drag and drop your file into the import zone, or click to browse your files. For multi-sheet Excel files, select the sheet containing your queen data.

Step 2 — Analysis​

BeePass automatically analyzes your columns:

  • Column names: compared against a dictionary of ~150 multilingual synonyms (FR, EN, DE, NL)
  • Data types: dates, numbers, scores, text
  • Value ranges: scores 1-4, HYG cells 0-50, honey 0-200 kg
  • Fill rates: empty or partial columns flagged

Each column receives a suggested match with a confidence score.

Step 3 — AI mapping (optional)​

If the Ollama server is available, an AI Suggestions button appears. Clicking it, the Llama 3.2 model analyzes your headers and data to propose additional correspondences.

  • AI suggestions are marked with a purple badge
  • The AI never overrides a reliable heuristic match (confidence > 85%)
  • You keep full control: every suggestion can be modified
AI is optional

The import works perfectly without AI. Heuristics (column names + value analysis) are sufficient in most cases. AI is a bonus for files with unusual headers.

Step 4 — Manual mapping​

A table displays your columns with:

Your columnValue previewBeePass field
Queen nameANNA, BELLA...queen_name
Year2023, 2024...birth_date
Production25.5, 30.2...honey_yield_kg

BeePass fields are grouped by category in the dropdown:

  • Identity: name, serial number, breeder code, country...
  • Pedigree: dam, sire, drone group...
  • Evaluation: honey, gentleness, vigor, wintering, HYG...
  • Location: postal code, evaluation country
  • Ignore: column not imported

Rule: at least one identifier (queen_name or serial_number) must be mapped to continue.

Step 5 — Validation and import​

Before import, BeePass displays:

  • Preview of transformed data (normalized names, converted races, formatted dates)
  • Errors in red (missing identifier, values out of range)
  • Warnings in orange (potential duplicates, empty optional fields)

Check Skip errors to import despite error rows (they will be skipped). Click Import to start batch processing.

Original data preserved​

All columns from your source file are preserved in an origin_data JSON field, even if they were not mapped. Nothing is lost: you can access your original data anytime from each queen's detail page.

Name your columns clearly

Columns with names close to BeePass fields are matched automatically. Use explicit names like queen_name, birth_date, honey_kg, gentleness for optimal mapping.

See also​