Add multiple songs to songbook and add song numbers based on spreadsheet / csv.


Just wondering if it's possible to add multiple songs to a songbook and then add song numbers through spreadsheet or csv. Either in OpenLP or outside using an SQL editor or something similar?

I have the Songs of Fellowship books 1-5 to add and would like to have them imported in a tidy manner.



  • edited March 27
    OpenLP stores songs in an SQLite database. Just open the data folder (Tools menu), and find the "songs.sqlite" in the "songs" folder. Make sure OpenLP is not running when you open the database.

    Don't forget to make a backup first! If you mess up the database, it'll be a lot of hard work to get it back.
Sign In or Register to comment.