I record my logs using am Android device and a free android bluetooth serial terminal app and a Veepeak Mini Bluetooth OBD2 adapter.
All my logs go into a folder on the Android. Many are far too large for a spreadsheet.
I use another older Android app (aGrep) to do a regular expression search of the logfiles. In this way I can quickly scan for messages meeting various criteria.
This is one of the RegEx expressions I used for the screenshots above.
..:..:...[0-9][0-9][0-9] .. 4[A-B] .. 14
This gives me anything addressed to either $4A or $4B with the secondary ID of $14.
If I find I want to further investigate a given logfile I cut/paste either the whole logfile if it is not too large or a snippet to get what I want to see into the spreadsheet.
The spreadsheet is a monster. I am no programmer so I'm sure this can be done better but this is what I am capable of and it works for me.
The spreadsheet (a Google Sheets doc) does some lookups from portions of the SAE J1850 specifications to make the reading/decoding easier.
Here is a small part of what the spreadsheet shows me....
Partially highlighted in light blue the PCM reports oil life of $00, the cluster requests same, and the PCM reports the real value of $47.
I have not seen the message priority vary for a given message except between vehicles perhaps. But in the case of oil life reports both my vehicles use the same priority.