If someone knows a better way than this I'm all ears because I don't like how this whole process is done. I split this text up weirdly like this because you can probably just use the Manage Reports feature that I describe in the middle there. You likely will not need to do the vlookup or any of that unless you have a lot of reports to sort through.
My usual use case for this is migrating fields to other types or similar changes and notifying personal report owners of exactly what has changed and what steps they need to take. What I do when I have a large list of reports that I need to find the owners of is copy the reportnames from the Usage tab of the field.
Then I go to the home page of the app > settings cog > App Management(under Advanced Features) > Manage Reports (under Manage App Contents).
I then change the Show dropdown to "All Personal Reports" and find the table I need. You can type the table name to filter if you need to but this also searches report names, it works though. Then copy all the data you see(I use a Chrome addon called Copytables that is wonderful for this) and do vlookup in Excel to match the report names to my previous list which will tell me who owns each report.
