Using CSV reports

Comma-separated value (CSV) reports are text files of data in which each piece of data on a line is separated from the next piece by a character known as a delimiter (a comma in these files). The product creates these files using a default delimiter or using a delimiter of your choice. (See report options to set another delimiter.)

The main use for a delimited file is that it can be imported into many third-party programs (spreadsheets or databases). Importing data from a series of CSV reports into a spreadsheet over a period of time allows the creation of many kinds of progress metrics. The native extension for the report filename is .CSV. If the system to which you upload the file requires another extension, it will need to be changed prior to upload.

Moving data from a CSV into another program is a multi-step process. Some steps are inside the product and others take place in the program into which the data is being imported. (The steps given here are to import the data into a Microsoft Excel spreadsheet, but importing into other programs follows the same general pattern.)

  1. Create the CSV report.
  2. From the home page, click the report generated successfully message to access the file.
  3. Click on the file to open the File Download dialog.
  4. Click Save and save the file to your local system. Do not open the CSV file now. Internet Explorer will add extra line feeds to the data which will ruin it.
  5. Open Excel to the worksheet where you want to place the data.
  6. On the Data menu, select Import External Data, Import Data. Browse to the CSV file. The Text Import Wizard opens with your data displayed at the bottom of the dialog box.
  7. In Step 1 of the Text Import Wizard, select Delimited and click Next.
  8. In Step 2, check the delimiter that is visible in your report data. Clear any other delimiters that may be checked. Click Next. (If you are using the pipe delimiter ( | ), check Other and type the | in the field. If you have selected the correct delimiter, you should see your data resolve into columns at this point.
  9. In Step 3, change each column that contains ID data that could begin with a zero from General format to Text format. (Excel trims leading zeros from numbers it imports in the General format. This may result in IDs that are missing digits.)
  10. Click Finish.
  11. In the Import dialog, set up the destination for the data and click OK. The data is imported.