Export to CSV but all data is in one column

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

  1. Select the cell or column that contains the text you want to split.

  2. Select Data Text to Columns.

  3. In the Convert Text to Columns Wizard, select Delimited > Next.

  4. Select the Delimiters for your data. For example, Comma and Space. You can see a preview of your data in the Data preview window.

  5. Select Next.

  6. Select the Destination in your worksheet which is where you want the split data to appear.

  7. Select Finish.


    • 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 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 ...
    • CIS/MRO Export

      Steps to export CIS/MRO data from BoviSync: 1. Open BoviSync Herd 2. Open this URL: https://bovisync.farm/report/export/legacymro 3. The CIS/MRO data will automatically begin downloading. Check your Download folder for "LegacyMRO.txt" file Related ...
    • Print and Export Options in Bovi-Insights

      Learn how to easily export Bovi-Insight reports in CSV and PDF formats Related Articles: Introducing Bovi-Insights Reporting Intermediate Bovi-Insights Reporting
    • Create a Test Day file based on Parlor Data

      This article will walk you through how to create a DHIA Test Day file based on parlor data from BoviSync.  You must have an active parlor interface which records daily milk weights into BoviSync for this to work.  Step 1:  Open this report in ...