@samsli Let me see if I can clear up what you are seeing and help you to use the data!<br>The file is a comma separated list with ALL the fields of the list inside double quotes.<br>Format of each LINE in the export file is as follows....<br>
Date the song was displayed yyyy-mm-dd
Time the song was displayed hh:mm:ss and the partial second is recorded to 6 decimal points.
Song title
Copyright information
CCLI Song Number
Category - Songs
How it was used - Displayed
To use the data you could just open the file and count the number of times each song was displayed.....I don't suggest this!<br><br>I would suggest you import the file into your spreadsheet program. Using LibreOffice I open the file within Calc and it opens a Text Import
window that asks about the file. Make sure the Separated by
option is set to a ,
then select the OK
button and the file is input into the spreadsheet. From this point you can sort or filter as needed to get the information you need.<br><br>For my church we add this information to the printed bulletin counts when reporting to our copyright licensing company.