Importing Animals from CSV

Created by Jarrett Woodall, Modified on Thu, 3 Sep at 3:02 PM by Jarrett Woodall

Importing Animals from CSV

If you have a large number of animals to add, you can bulk import them from a CSV (comma-separated values) file instead of entering each one manually.

Before You Start

Start from the import template rather than building a file from scratch. On the Import Animals page, click Download example template (with format requirements) to get an Excel workbook with two sheets:

  • Requirements — the accepted values for each column.
  • Animals — the header row and a few example rows. Replace the examples with your own animals.

When your data is ready, save or export the Animals sheet as a CSV file. The importer only accepts CSV — it will not read the .xlsx workbook directly.

How to Import Animals

  1. From the Dashboard, click Import Animals in the quick actions.
  2. Choose a Default Identifier — Ear Tag, EID, Freeze Brand, or Other Tag. This is the column Cattle360 treats as each animal's main identifier, and the one used to match sires and dams.
  3. Optionally tick Check Cattle360 system for matches so sires and dams named in your file are linked to animals you already have. If it is left unticked, every row is treated as a brand new animal.
  4. Drag your CSV onto the upload box, or click it to browse for the file.
  5. Click Validate Import. Any problems are listed on screen, one per issue, with the row number.
  6. Once validation passes, click Import Data to create the animal records.

Nothing is saved until you click Import Data. Validating is safe to run as many times as you like.

CSV Format

Your file needs a header row. Column names are matched ignoring case, spaces, underscores and dashes, so BirthDate, Birth Date and birth_date all work. Columns can appear in any order, and any column Cattle360 does not recognize is ignored.

Required Columns

ColumnAccepted Values
TypeBull, Cow, or Calf. (Goat accounts: Buck, Doe, Kid. Sheep accounts: Ram, Ewe, Lamb.)
SexBull, Steer, or Heifer. (Goat accounts: Buck, Wether, Doe. Sheep accounts: Ram, Ewe.)
StatusActive, Dead, Sold, or Reference.
An identifierEvery row must have a value in at least one of EarTag, EID, FreezeBrand, or OtherTag.

Identification Columns

ColumnAccepted Values
EarTagAny text.
EIDAny text.
FreezeBrandAny text.
OtherTagAny text.
NameAny text.
TattooAny text.
EarTagColorBlack, White, Red, Gray, Green, Yellow, Blue, Orange, Purple, Pink, Silver, Other.
OwnerThe owner's first and last name exactly as it appears in Cattle360. If it is blank or does not match a user, the account owner is used.

The template also has a Default Identifier column. You can leave it as-is — the choice you make on the import page is what Cattle360 actually uses.

Descriptive Columns

ColumnAccepted Values
ColorBlack, Black White Face, Red White Face, Black Brockles, Red Bockles, White, Red, Gray, Cream, Brown, Tan, Orange, Blonde, Blue Roan, Red Roan, Brindle, Other.
BreedAny text.
RegistrationNumberAny text.
BrandTRUE or FALSE.
CastratedTRUE or FALSE.
CastratedDateA date.
DeHornedTRUE or FALSE.

Parentage and Breeding Columns

ColumnAccepted Values
SireIdentifierThe sire's value in whichever column you chose as the Default Identifier.
DamIdentifierThe dam's value in whichever column you chose as the Default Identifier.
ConceptionTypeNatural or AI.
BreedingStatusOpen (or Empty), Exposed, or Pregnant.

A sire or dam can be another row in the same file. If you ticked Check Cattle360 system for matches and the parent is not in your file or in your herd, Cattle360 creates a placeholder animal for it with the status Reference so the pedigree still links up.

Birth and Weaning Columns

ColumnAccepted Values
BirthDateA date.
BirthWeightA number, in pounds.
WeaningDateA date.
WeaningWeightA number, in pounds.

Purchase, Sale, and Death Columns

ColumnAccepted Values
AcquiredRaised or Purchased.
PurchasePriceA number.
PurchasedDateA date.
SaleDateA date.
SalePriceA number.
SaleWeightA number, in pounds.
PricePerPoundA number.
SalePriceMethodWeight, TotalPrice, or CWT.
DeathDateA date.
CauseOfDeathAny text.

Notes Column

ColumnAccepted Values
NotesAny text. Whatever you put here is saved as a note on the animal, exactly as if you had added it by hand on the animal record. Leave the cell blank for no note.

Each row gets one note. To add more notes later, open the animal and use the Notes section — see Adding Notes.

Dates and Numbers

  • Dates can be written as 3/9/2026, 03/09/2026, 2026-03-09, or 3-9-2026. Month comes first.
  • Prices and weights can include currency symbols and thousands separators — $1,232.50 is read the same as 1232.50.
  • Blank cells are fine for any column that is not required. Leave them empty rather than typing N/A or 0.

Accepted Column Name Variations

If your existing spreadsheet uses different headings, these are recognized automatically and do not need renaming:

If Your Column SaysCattle360 Reads It As
Date of Birth, DOBBirthDate
Purchase Date, Date PurchasedPurchasedDate
Date SoldSaleDate
Date DiedDeathDate
SireSireIdentifier
DamDamIdentifier
Reg Number, Reg NoRegistrationNumber
Price Per LbPricePerPound
Note, Comment, CommentsNotes

Tips

  • Clean your data first. Remove blank rows and fix spelling inconsistencies before importing — a single misspelled status or color will fail validation for that row.
  • Start with a small test. Import a handful of animals first to confirm everything lands where you expect, then import the full file.
  • Save your CSV in UTF-8 format. This prevents issues with special characters in animal names or notes.
  • Import parents first, or keep them in the same file. This gives sires and dams the best chance of matching instead of creating placeholder Reference animals.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article