Formatting EID numbers in .CSV file formats

Formatting EID numbers in .CSV file formats

When opening a .CSV file in Microsoft Excel, EID numbers are automatically formatted to be rounded. For the file to import correctly, without errors, you must format the EID values to eliminate the decimal places. 

Written Instructions:

1. Open the .CSV file into Excel

2. Select the Column containing the EID Values
3. Right Click and choose 'Format Cells' 

4. The format cells dialog box appears. Select 'Custom' 
5. Select 'Custom' and Choose '0' under 'Type' category 

6. Click 'Ok' 
7. The EID values are now formatted correctly:

8. Save the .CSV file 
9. Import the .CSV file into BoviSync 
Note: Opening the file back up, will require you to re-format it each time. This is due to how Microsoft Excel handles EID values in Excel. 


Video Tutorial: 

To play this video in fullscreen; click here 


    • Related Articles

    • Import EID Pairs

      When buying eartag-EID sequences, the tag supplier generally will or can provide you with a CSV file of the eartag and EID pairs. You can import this file with the sequence of numbers into BoviSync. BoviSync will then automatically assign the EID for ...
    • Create an EID Pair File

      This guide will walk you through the steps to create an EID Pair file which can be imported into BoviSync. This is useful when entering new animals into BoviSync. the eartag will automatically be paired to the correct EID tag for you. Written ...
    • Import implant information from CSV file

      This import is only for advanced users for bulk updating implant event.  If you have errors you will need to import a new file to update or manually fix the events you updated.  If you have a lot of events to update, please try with a small portion ...
    • Import csv from non-US excel formats (semicolon separated csv files)

      When you export a report from BoviSync, does it look like this in Excel? (everything in one column) Export to CSV but all data is in one column You need to make some changes before you can import your .csv into BoviSync. Save your excel file as a ...
    • Import Lab Results (PAGs) - DNO File Only

      This article is how to import as well as creating a .DNO file. This is a standard file for importing preg check results for PAGs.  Written Instructions: If you already have a .DNO file and only need instructions on importing skip to step #4 1. Open ...