Go to:
C:\Users\[username]\Documents\My Games\Sid Meier's Civilization 5\config.ini
Open up config.ini and edit to enable message logging and ai logging:
; Enable message logging
MessageLog = 1
; Enable AI logging
AILog = 1
Play the game. Now when you go to the log folder you can view all the logs:
C:\Users\Joshua\Documents\My Games\Sid Meier's Civilization 5\Logs
To view you war monger threat score, go to DiplomacyAI_Approach_Log.csv
I've attached a sample csv so you can view one from one of my games. I only started half way through the game though.
Column A: Turn number
Column B: Civ who's view you want
Column C: Civ who is the target. i.e. if you are playing indonesia and want to know what is portugal's view of you, then look for Portugal in column B and indonesia in column C. If you have Microsoft Excel, you should be able to set filters to easily do this for you.
Column D: AI Stance e.g. FRIENDLY, NEUTRAL, GUARDED, HOSTILE. There is one more stance that is not visible from the UI, which is DECEPTIVE. Deceptive Civs will appear as Friendly to you, but really they see you as a war target. To check if AI is deceptive, usually he will have no reason to be friendly to you - mouse over the FRIENDLY status and view all the red and green modifiers - if there are lots of reasons to hate you in red and not many green, he is likely deceptive. Friends will also give good trade deals - 1 lux you own will get you either 7gpt or 1 of their spare luxes. Deceptive civs will usually only allow bad trade deals, like guarded civs. To determine if a civ is deceptive, try and propose a fair trade and see what happens. If a civ goes from guarded to friendly for no reason, he is likely in deceptive mode. Guarded means he hates you but you have a very strong military. Once your military dwindles he will switch to deceptive because now he no longer fears you. The purpose of deceptive mode is for the player to trust him and then open borders so he can take a peak at your weaknesses.
COLUMN F: Not sure what this is. The column has "OPN XXX" where XXX can be unforgiveable, enemy, ally, friend, competitor
COLUMN G: The warmonger threat column. Possible values: None, minor, major, severe, critical. This column can be deduced from the game UI, except for friendly civs. To check what they think of your war mongering, simply hover over their stance (e.g. NEUTRAL, GUARDED, etc) when talking to them and it should appear in red. Possible red messages shown below. Here's the non-obvious part: declared friend civs dont really show what they think of your war mongering - but they still track it. You won't know it from the UI and can only tell from the logs. I've found that once you hit a critical point of war mongering, your friends will backstab and it will appear.
None 0-19 N/A
Minor 20-49 They have some early concerns about your warmongering.
Major 50-99 They clearly see the potential threat posed by your warmongering.
Severe 100-199 They believe your warmongering has become an issue of global prominence.
Critical 200+ They fear your warmongering will soon sink the world into a new Dark Age!
COLUMN H: Some numbers here in the format X/Y; I don't know what is the first number, but the second number is you war monger score. It should correspond to the table written above. E.g. a score of 20 in column H means you that in column G you should see W_THT_MNR (Minor threat)
COLUMN O: No idea. Something to do with M_THT ???
COLUMN J: I believe this column is how good a war target you are. It can range from Impossible, Bad, A, Soft, Favorable. I don't know what A or soft means, but they are somewhere between bad and favorable.
COLUMN L to Q: No idea.
Columns S to AF: The possible stances an AI can have and a number. The actual stance is the one with the highest number.