Song usage report
See which songs were used in planned services, how often they were used, and when they were last used.
Choose the period
- Open Worship › Service planner… and click Song report….
- Under Period, choose Last 3 months, Last 6 months, Last 12 months, This year, Last year, or Chosen dates. Set From and To for a specific range.
- Choose Sort by: Most used, Title, or Last used.
The report counts scores and chord sheets in dated services between those dates. Times is the number of services containing each song; Last used is its most recent date in the period. A song counts once per service, even when it appears more than once. Undated services are not counted, so add missing dates in the Service planner.
Check song details
Songs are matched by title, ignoring case, accents, and punctuation. A score one week and a chord sheet the next can therefore count as the same song. Check titles before relying on the totals.
Enter a CCLI no. for a song if you use one. The editor keeps it for later reports and syncs it with your library. A {ccli: …} line in a ChordPro sheet can fill it. Also list songs not used in this period (from other services and your library) helps you find songs to revisit; it does not add them to the usage totals.
Print or save a spreadsheet
Choose Print for a paper or PDF report. Choose Save spreadsheet (CSV) for a file to open in Excel or Google Sheets.
The CSV has one row per used song, with Title, Number, Words, Music, Tune, CCLI song number, Copyright, Times used, Last used, and Dates used. Check its credits, song numbers, dates, and usage counts before using it for a CCLI or other copyright report.
