Apple - Can I easily view all songs that iTunes can't locate in Finder?

Two approaches: First, take a look at Doug's AppleScripts for iTunes - dougscripts.com. He has a ton of useful scripts, including Super Remove Dead Tracks, which you might be able to modify to just list them if you want.

Or, if all you want to do is create a playlist of songs which have no native file, there is a very simple way to do that (which I found repeated by so many people that I don't know who to attribute it to):

1. Create a regular playlist, not a smart playlist. For this example, call the playlist "Alive".

2. Select all tracks in your main library and drag them into "Alive". Note that "dead" tracks with no native file will not appear in this playlist.

3. Create a smart playlist defined as: Playlist -- Is Not -- Alive. Call this playlist "Dead".

You now have a list of "!" songs which are missing their native files. You could then go ahead and delete the dead ones if you wish.

Deleting is not allowed from a smart playlist. So, select all songs from the new "Dead" playlist by clicking Ctrl A. Right-Click and select Dislike. Now they can be seen and deleted in the main library; sort using Love/Dislike column. Tested in current Windows version.

This worked for me:

1. Make a static playlist called “All Live Files” and copy/add your entire library into it. (You can drag the songs from the Music item in iTunes)
2. Make a smart playlist called “Missing Files” with the rules set as ‘Playlist’ ‘is’ ‘Music’ and another rule set as ‘Playlist’ ‘is not’ ‘All Live Files’
3. The broken songs will not transfer and “Missing Files” will contain all those broken songs.

Once you have this playlist of broken songs, you probably want to delete them by using Option + Delete.