For macOS 10.10 and later only. This applet checks your entire iTunes library for missing and presumed dead tracks--those tracks that iTunes is unable to associate with a file and which are listed in iTunes with a "!"--and can create a text file listing these tracks by last known File Path (if available), Song Name, Artist and Album, which you can view using TextEdit.
Also see Music Folder Files Not Added
To find and delete dead tracks see Super Remove Dead Tracks.
iTunes can't find the files pointed to by the Location property of these track entries.
Perhaps Also of Interest...
downloaded 56s ago
Two scripts copy text from clipboard to current or single selected track's lyrics tag
downloaded 7m 46s ago
Display, create text file listing info of dead tracks
downloaded 38m 8s ago
Copy Artist to Album Artist of selected tracks
downloaded 57m 22s ago
Gather audio tracks whose files contain no artwork metadata
downloaded 1h 0m 32s ago
Rename selected tracks' Song Names with their filenames (minus extension)
downloaded 1h 28m 15s ago
Sort purchased tracks into discrete playlists by name or Apple ID