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 ...
    • 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 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 ...
    • Import DHIA Test Results

      For processed testing, PAGs and Johnes results, you can ask your DHIA testing processor to send the files direct to BoviSync and have the results automatically imported. If they have any questions, your tester can request information by email us at: ...