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 ...

    • Export to CSV but all data is in one column

      Does your .csv look like this when you export from BoviSync? Report exported to .csv from Bovi-Insights - all data in one column Use Microsoft Excel's Text to Column wizard to split text into different columns Select the cell or column that contains ...