Skip to content
Setlistory
Setlistory
  • User guide
  • News
  • Login
  • English
    • English
    • Slovenščina
Close Button

How to import songs from an Excel file into SetlistoryHow to import songs from an Excel file into Setlistory

1. 3. 20241. 3. 2024|

For an even better experience, we have added an option to import songs that you play from an Excel file, which makes adding all your songs into the Setlistory app

Read MoreRead More

Setlistory available on Android and IOSSetlistory available on Android and IOS

20. 10. 202220. 10. 2022|

Huge news! Setlistory is now available as an Android and IOS app. Links below. Android: https://play.google.com/store/apps/details?id=com.setlistory.app IOS: https://apps.apple.com/us/app/setlistory/id6443555599 Feel free to install it on your phone and give us your

Read MoreRead More
Setlistory screenshot

Updated websiteUpdated website

1. 10. 20201. 10. 2020|

The Setlistory website has been recently updated. The actual application can be found at app.setlistory.com. That’s where you can create an account, log in and start creating your setlists. Some

Read MoreRead More
Create Profile Icon

Create an accountCreate an account

30. 9. 202030. 9. 2020|

Just join our platform and you’re on your way!

Read MoreRead More
Add Songs Icon

Add your songsAdd your songs

30. 9. 202030. 9. 2020|

Add the songs you play, covers and originals, with all the possible details.

Read MoreRead More
Create Setlist Icon

Create a setlistCreate a setlist

30. 9. 202030. 9. 2020|

Select the venue, city, date and add your songs to create a setlist.

Read MoreRead More
Print Setlist Icon

Print it outPrint it out

30. 9. 202030. 9. 2020|

We create an awesome, ready-to-print setlist and downloadable forms!

Read MoreRead More

About the app

Setlistory is an application designed with the gigging musician in mind. It’s used to create, print and export setlists. Songs with all their details are added first, then the setlists with venue, city and date can be created. The order of the songs is easily manipulated via a simple drag&drop interface.

Recent Posts

  • How to import songs from an Excel file into Setlistory

    For an even better experience, we have added an option to import songs that you play from an Excel file, which makes adding all your songs into the Setlistory app even faster and simpler. First, in the “Songs” section, you click on the upload icon, which is to the right of the “New song” button. Here you will see a link, where you can download the Excel template, which you can pre-fill with all your songs. Please note that you must not change the template in any way, each column should stay in it’s place. Also, do not delete the first row. The only required fields are TITLE and TYPE, but it is advised that you fill each row with as much data as possible. The columns are: ISWC – The International Standard Musical Work Code (ISWC) of your song, which is a unique, permanent and internationally-recognized reference number used to identify musical works. This column is not required and can be left empty, but it is strongly advised that you fill it out in order to definitively identify the song. TITLE – The title of the song. This field is required and should not be left empty. TYPE – This field determines, whether the song is an original or a cover. You fill it with ether a lowercase “o” (original), or a lowercase “c” (cover). This field is required and should not be left empty. LENGTH – The length of the song. It must be in the mm:ss format, which means minutes, followed by a colon (:) and then the seconds. The field is not required. KEY – The key of the song. The field is not required. BPM – “Beats per minute” of the song. The field is not required. TIME SIGNATURE – It must be in the format beats/measure (for example 4/4, 7/8, 15/16). The field is not required. MUSIC AUTHORS – The names of all the music authors of the song. If there are multiple authors, they should be separated by a semicolon (;). The field is not required. LYRICS AUTHORS – The names of all the lyrics authors of the song. If there are multiple authors, they should be separated by a semicolon (;). The field is not required. ARRANGEMENT AUTHORS – The names of all the arrangement authors of the song. If there are multiple authors, they should be separated by a semicolon (;). The field is not required. LYRICS – The lyrics of the song. The field is not required. When you are finished with filling out the Excel template, you can import it by clicking the “Select file” button, finding and selecting your saved template and then clicking the “Import” button. Once the import is finished, you will see a screen such as this one: There are a couple of notes here. Firstly, in the example Excel file above, you can see we tried to import 5 songs, but the actual number of songs in the import is 4. That is because the title and type were not filled in one of the rows, so the import ignored this row. There were 3 songs created successfully, which means there were no conflicts when importing them (all the successfully imported songs have a green tick next to them). There was 1 conflict (song number 3), indicated with the red cross. As the error implies, a song with this title already exists in your Setlistory songs list. The import checks for duplicates of titles and ISWC codes. It it finds a duplicate you have 3 options: DUPLICATE – create a duplicate of the song with the same title or ISWC code (this is not advised, you should know what you are doing). Ideally you should have unique ISWC codes for each of your songs. UPDATE – override the existing song in your Setlistory songs list with the data from the one in the Excel file. CANCEL – Ignore the song from the Excel file, keeping only the existing song. You should address all the conflicts when importing. Once you do, you can close the modal and you should see all your imported songs in your songs list. Now you can start creating setlists. If you have any questions or problems, please feel free to let us know at info@seltistory.com. Happy gigging!

  • Setlistory available on Android and IOS

    Huge news! Setlistory is now available as an Android and IOS app. Links below. Android: https://play.google.com/store/apps/details?id=com.setlistory.app IOS: https://apps.apple.com/us/app/setlistory/id6443555599 Feel free to install it on your phone and give us your feedback!

Links

Web App

Android

Apple

Setlistory Lyrics

Setlistory
Setlist. Simplified.
Scroll Up