Import csv from non-US excel formats (semicolon separated csv files)

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)

You need to make some changes before you can import your .csv into BoviSync. 

  1. Save your excel file as a .csv

  2. Find the location of the saved file, and right click on the file to open in notepad or something similar

    1. Right click on the file to open in Notepad or a similar program (not excel)

  3. Click on Edit > Replace

  4. Use find and replace to replace , with . if you are using numbers with decimals. If there are no numbers with decimals in the file you are trying to import, skip to step 5.

  5. then, replace ; with , 

    1.  

  6. Save the file


  7. Now you are ready to import!

    1. to double check if the file saved properly, open it normally in excel and see if everything is in one column and separated by commas (,)
If you still have troubles with imports after this, please do not hesitate to contact support at support@bovisync.com 

    • Related Articles

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

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

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

    • New Animal Import from Excel

      A new import has been created to replace this import with less steps: Import New Animals (Animal Import Purchased) The following steps explain the process to import animals from excel: Download the attachments to this article. If you don't have the ...

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