< Back to FAQs

How do I export my played tracks to Excel?

You can export your played tracks to Excel by using PlayIt Live's Logged Tracks feature, which maintains a record of all tracks that have been played on your station.

To access logged tracks:

Go to Manage > Logged Tracks from the main menu. This opens the Logged Tracks window, which displays a list of recently played tracks with timestamps showing when each track was broadcast.

Filtering your data:

Before exporting, you can filter the data to show only the tracks you need:

  • Past 24 hours - Shows tracks played in the last day
  • Past 7 days - Shows tracks played in the last week
  • Past 30 days - Shows tracks played in the last month
  • Custom date range - Select specific start and end dates using the calendar dropdown

Exporting to CSV:

Once you've filtered to show the tracks you want to export, click the CSV button. This opens an export dialogue where you can select which fields to include in your export, such as track title, artist, play time, duration, and other metadata.

After selecting your desired fields, click Export and choose where to save the CSV file on your computer.

Opening in Excel:

The exported CSV file can be opened directly in Microsoft Excel or other spreadsheet applications like Google Sheets. The CSV format preserves all your data in a structured format that's perfect for creating reports, charts, or further analysis of your station's playlist history.

This export feature is particularly useful for music reporting, royalty submissions, creating playlist reports for clients, or analysing your station's music rotation patterns.

Contact

PlayIt Software is based in the heart of Cambridge, England, United Kingdom.
You can get in touch with us by the following methods:

Office
PlayIt Software Ltd
184 Cambridge Science Park
Milton Road
Cambridge
CB4 0GA
United Kingdom
Email icon Email icon
Sales enquiries (email)
Headset icon Headet icon
Sales enquiries (talk)
Facebook icon Facebook icon
Technical support (Facebook group)
Facebook icon Facebook icon
Technical support (email)
Facebook icon Facebook icon
Facebook page
Facebook icon Facebook icon
YouTube channel