There are a few methods you may want to investigate:
I. Text Exporter You can use the Text Exporter to generate a report spreadsheet similar to what you've shown in your screenshot, you can choose what metadata you would like to have in the report.
1. Select all the files in your contact sheet.
2. File > Export... then "Text Exporter" to generate a report. You can see an example and how it appears in a spreadsheet program in the attached screenshots.
Header text:
Nom di fichier{tab}Date de modification{tab}Taille image{tab}Légende{tab}Mots clés
Export:
{filename}{tab}{moddate}{tab}{filesize}{tab}{caption}{tab}{keywords}
Tips:
Save your exported file with the
.tsv extension to open it in Excel
Create a Snapshot preset for this report with the Snapshot (lightning bolt) button so you don't have to type in all those variables each time.
If you are doing this in Excel. make sure to check the box to Replace Carriage Returns
If you find yourself needing to make a lot of metadata edits this way, you can check this video on how to apply metadata back to your images from the spreadsheet:
https://www.youtube.com/watch?v=XHyl5inFvFsII. Find If you're mainly looking for empty fields that you forgot to fill out, you can use the Find feature in Photo Mechanic to locate files that don't have anything in specific metadata fields. Just leave the Find field empty. (Example attached)
III. Contact sheet labelsFor a simpler way to quickly check the contents of one or two fields, you can choose to display those fields in your contact sheet in Preferences > Contact Sheet. You won't be able to verify long strings, but if the strings are short, this could work.
IV. The Metadata Info screenUse the Arrow buttons to quickly flip through images in the Metadata Info screen. Depending on your batches, this may be the fastest way.
I hope something in these ideas can help you in checking the metadata on your images.
Mick