When transferring data from your USB flash drive or LogCard to a spreadsheet, the type of file the utility creates is a .csv file (for example, LogCard.csv). A .csv, or Comma Separated Value file, is a type of file in which the data is delineated, or separated, by commas. In other words, the commas tell a software program where the different data elements begin and end.
The utility creates a .csv so that you are not restricted as to what type of program you need to read the file. Microsoft Excel, as well as other programs such as Microsoft Works or Access, can import and read .csv files. When opening a .csv file, you may be prompted by a Text Import Wizard to indicate how the data is delineated in the file. If this occurs, make the appropriate selections to indicate the data is delineated by commas.
To view the resulting file created with the Transfer to Spreadsheet option, you will need to have a program installed on your computer that is capable of opening .csv files. If you do not have a program on your computer with this capability, and you simply want to view the information on your USB flash drive or LogCard, click Upload/Transfer Results and then click Upload to Online Logbook. The utility will read the USB flash drive or LogCard and display the information, which you can then print if you choose.
The Transfer to Spreadsheet option transfers all the data on your USB flash drive or LogCard (you cannot transfer only certain pieces of information), including heart rate information if you are using the appropriate equipment to display heart rate data on the Performance Monitor during your workout. Please note that the Transfer to Spreadsheet option will overwrite previously transferred data if you transfer data to the same file. Additionally, the Transfer to Spreadsheet option will not work if you are transferring to a file that you currently have open on your computer. In this case, close the file before doing the transfer, or change the name of the file the Concept2 Utility will create.
You cannot upload results to your online logbook from a .csv. Additionally, you cannot transfer data back onto a USB flash drive or LogCard using a .csv.
Take the following steps to transfer the data to a spreadsheet:
- If you have not already done so, download and install the Concept2 Utility, and then run it.
- On the main Concept2 Utility screen, click Upload/Transfer Results. If your device is already connected to your computer, skip to step 5.
- Select the type of device on which your results are stored.
- Attach the device you selected in the previous step to your computer, as applicable:
- Insert your USB flash drive into your computer
- Attach your PM5 to your computer using a standard USB cable
- Connect your PM or card reader to your computer and insert your LogCard into it
- Click Transfer to Spreadsheet.
- The Concept2 Utility displays the default location and the name of the data file it will create.
- To change a file location, click Browse, and select a new location/file on your computer.
- To change the name of the file that will be created, type a new file name in the Spreadsheet file name box, but leave the “.csv” extension.
- If you want to view the results immediately following the transfer, select Open file in Excel after reading data. (This may appear as "Open file in External Application" if Excel is not installed on your computer.)
- Click OK to transfer the data.
If you chose to have the utility automatically open the file and Excel is installed on your computer, the utility will launch Excel and display the spreadsheet created by the Transfer function. If Excel is not installed on your computer, the utility will prompt you to select the application you would like to use to display the spreadsheet created by the Transfer function. (If you have already set your computer to open .csv files in a particular application, the utility will use that application to open and display the file.)
If some of the data is not visible or appears as ###### when viewing the data in a spreadsheet, the data is too wide for the column. Widen the spreadsheet column to see the data in its entirety.