Adding IDs from a Spreadsheet

If you have a large group of animals with multiple IDs listed in a spreadsheet, follow these steps to add the IDs to the animal group.

Note - these steps apply to adding IDs to an animal group with a head count over one

  1. Select the animal group to which you need to add the IDs and click Edit.

  2. Click “Add an ID” and select the type(s) of IDs listed in your spreadsheet. You will need to select the “Add an ID” button for each additional ID.

  3. Once you have the ID type(s) selected, open your spreadsheet. 

  4. Highlight the cells with the corresponding ID values that you want to add to the animal group. Once they are highlighted, click “Control” and “C” on your keyboard to copy the values.

  5. Once you have the ID values copied, click on the first yellow cell under the Type of ID field and click “Control” and “V” on your keyboard to paste the values.

  6. After all IDs are entered, click “Save” on the animal’s profile. When the profile is saved the IDs will appear on the CVI. 

Note:

  • If there are errors, double-check that no extra rows were highlighted when copying and pasting from the spreadsheet.
  • If there is a head count of 10 animals, there MUST be ten IDs entered. If one animal does not have an ID, there would need to be a placeholder entered, such as “N/A.”
  • Another common issue when adding IDs from a spreadsheet is that all IDs may appear in a single line or cell after pasting. This typically happens when the ID row isn't correctly selected before pasting.

    • Important: To avoid this, make sure to click once on the desired ID cell so it is highlighted. Do not double-click into the cell, as that will place the cursor inside the cell for editing and cause the pasted IDs to fill into one cell instead of multiple rows.

 

 
Was this article helpful?
0 out of 0 found this helpful