I, as many folks on this forum (likely) do, have a rather large collection of musical media. While I've always kept a digital and searchable index of my albums (typing up liner notes, credits, etc), I've been taking this a step further as of late by also transcribing the lyrics and ascribing 3+ "tags" for each song to increase searchability.

This has been an endeavor several years running (albeit, without any progress for several of those), but I've recently started trying to make more consistent progress -- about an album a day, give or take. Of the >1,400 discrete pieces of media indexed in my collection, I've fully transcribed the lyrics to 134 of them so far. Sisyphean sounding, I admit, but it's also been a good way to explore in a new depth some of the recordings I have. Once completed, I plan to go over each song and make a master song index of songs and variants I have. The vast majority take about 30-45 minutes to transcribe, though there's obviously variance in either direction because of singles (5-10 minutes) or longer/more incomprehensible albums (2 hours ++).

I was wondering, has anyone else on here ever done a similar project? How was your experience, and what was the process? Any unexpected surprises or difficulties? Once complete, how did/do you present the data?