I have quite a large music library (150k) that I have put together over the past years. Through various crashes of systems and copy processes I fear that there may be duplicate copies of albums and albums with missing tracks.
Is there a quick way to identify such album so that I can correct the issues?
Yes you can, but only from a computer, not from a phone or tablet.
Goto track view, select a track. At the upper left, there is a small menu that says: 1 selected. Change that to: all.
Now click the three buttons next to the blue Play or Queue button. Select export, and export to Excel.
You now have an Excel file with all you tracks, together with their numbers and album titles. Make sure that this list is ordered by album title first, disc number second and track number third.
You can now insert a column in Excel and create a function that generates a text when track numbers don’t add up in the right way.
Like this…when you are in an empty column on the 3th row: =IF(C3=C2;IF(E2+1=E3;"good";"missing");"")
This assumes your column titles are in row one and Album names are in column C and Track numbers are in E.
After this, it’s perhaps easiest to make a pivot table that groups by your albums and shows how many ‘missings’ there are per album.
(I see now that this will give a ‘missing’ for the first tracks of discs 2, 3 etc. in sets, so you will have to correct for that. It will also not see missing last tracks from albums.)