I'm wondering how others keep track of tens or even hundreds of songs.
Like SwitchBack, I use Excel with many conditional formats, and a lot of vlookup conditions. It just works, both in the workplace and at home.
Another suggestion that hopefully paves a way to minimize clutter for numerous songs is, if you at some point need to create a new title for your song and you're firm on that decision, there's no need to keep two of the same song (unless you're backing up).
To make a complete changeover to your new songname, use File>Save to New Folder. Locate the new songname so that it prepares the file under the default Documents\Studio One\Songs location. Just save under [Save to new folder] and Studio One will create the song folder with your newly named song within that folder. It will include all of the necessary sub folders for that song. Thereby leaving any redundancy out, such as the old song folder files/folders. Now, your new song will reside in a properly named folder within the same "Songs" location as your other songs.
What I then do is if I opt to delete the old song folder with the old songname, delete it, but don't remove it from your recycle bin.
Check that the new song works first. If it doesn't (for some odd reason) and is looking for some old file, you'd be able to restore the file back. You could also relocate the old song folder at another drive location, if you have reservations about sending the old song to the trash bin. The point is, ensure your new song fully works without needing the old song folder. Then delete the old song folder, so that you remove redundancy. Some choose to keep the old song, as they might be creating a new song and continue to revise the old. Youre choice. This is where having the info on a spreadsheet is all too important. Even if you dont use conditions or formulas in place. I do this to hundreds of songs, and its simply what one should have in place for tracking a lot of valuable work. Especially, when a client is involved.