Logging network traffic without particular tools

Unfortunately Fiddler has no really useful built-in export options. But it is possible to extend the FiddlerScript to export the traffic data to Excel (csv).

1. Open Rules
2. Choose "Customize Rules..."

see screenshot https://techscreen.tuwien.ac.at/sites/default/files/Fiddler-Rule-Edit.png

3. Search for the following code:


public static ToolsAction("Reset Script")
function DoManualReload() {
FiddlerObject.ReloadScript();
}


4. Insert following code after the lines above:


public static ToolsAction("Copy Request Timings to Excel")
function DoHighlightSlowRequests() {
var oSessions = FiddlerApplication.UI.GetAllSessions();

var s: String = "";
s = s +
"Id\t" +
"URL\t" +
"Is HTTPS\t" +
"Response Code\t" +
"Request Bytes\t" +
"Response Bytes\t" +

"ClientConnected\t" +
"ClientBeginRequest\t" +
"ClientDoneRequest\t" +

"ServerConnected\t" +
"FiddlerBeginRequest\t" +
"ServerGotRequest\t" +
"ServerBeginResponse\t" +
"ServerDoneResponse\t" +
"ClientBeginResponse\t" +
"ClientDoneResponse\t" +

"DNSTime\t" +
"GatewayDeterminationTime\t" +
"TCPConnectTime\t" +
"HTTPSHandshakeTime\t" +

"Request Transmission Time\t" +
"Server Time Spent\t" +
"Response Transmission Time\t" +
"Transmission time (down + up)\t" +
"Total Round Trip Time" +
"\r\n";
for (var x:int = 0; x < oSessions.Length; x++){
var logEntryId = oSessions[x].id
var session = oSessions[x]
var timer = session.Timers
// use tabs intead of CSV because
// Excel and .NET have incompatible
// expectations for unicode format

var t = oSessions[x].Timers
var transmissionTime =
new TimeSpan(t.ServerGotRequest.Ticks -
t.FiddlerBeginRequest.Ticks)
var serverTimeSpent =
new TimeSpan(t.ServerDoneResponse.Ticks -
t.ServerGotRequest.Ticks)
var responseTransmissionTime =
new TimeSpan(t.ServerDoneResponse.Ticks -
t.ServerBeginResponse.Ticks)
var totalTransferTime =
transmissionTime + responseTransmissionTime
var roundTripTime =
new TimeSpan(t.ClientDoneResponse.Ticks -
t.ClientBeginRequest.Ticks)

var transmissionTimeStr =
transmissionTime.ToString().Contains("-") ? "" : transmissionTime + ""
var serverTimeSpentStr =
serverTimeSpent.ToString().Contains("-") ? "" : serverTimeSpent + ""
var responseTransmissionTimeStr =
responseTransmissionTime.ToString().Contains("-") ? "" : responseTransmissionTime + ""
var totalTransferTimeStr =
totalTransferTime.ToString().Contains("-") ? "" : totalTransferTime + ""
var roundTripTimeStr =
roundTripTime.ToString().Contains("-") ? "" : roundTripTime + ""

s = s +
logEntryId + "\t" +
oSessions[x].url + "\t" +
oSessions[x].isHTTPS + "\t" +
oSessions[x].responseCode + "\t" +
oSessions[x].requestBodyBytes.Length + "\t" +
oSessions[x].responseBodyBytes.Length + "\t" +

oSessions[x].Timers.ClientConnected.ToString("HH:mm:ss.fff") + "\t" +
oSessions[x].Timers.ClientBeginRequest.ToString("HH:mm:ss.fff") + "\t" +
oSessions[x].Timers.ClientDoneRequest.ToString("HH:mm:ss.fff") + "\t" +

oSessions[x].Timers.ServerConnected.ToString("HH:mm:ss.fff") + "\t" +
oSessions[x].Timers.FiddlerBeginRequest.ToString("HH:mm:ss.fff") + "\t" +
oSessions[x].Timers.ServerGotRequest.ToString("HH:mm:ss.fff") + "\t" +
oSessions[x].Timers.ServerBeginResponse.ToString("HH:mm:ss.fff") + "\t" +
oSessions[x].Timers.ServerDoneResponse.ToString("HH:mm:ss.fff") + "\t" +
oSessions[x].Timers.ClientBeginResponse.ToString("HH:mm:ss.fff") + "\t" +
oSessions[x].Timers.ClientDoneResponse.ToString("HH:mm:ss.fff") + "\t" +

oSessions[x].Timers.DNSTime + "\t" +
oSessions[x].Timers.GatewayDeterminationTime + "\t" +
oSessions[x].Timers.TCPConnectTime + "\t" +
oSessions[x].Timers.HTTPSHandshakeTime + "\t" +

transmissionTimeStr + "\t" +
serverTimeSpentStr + "\t" +
responseTransmissionTimeStr + "\t" +
totalTransferTimeStr + "\t" +
roundTripTimeStr +
"\r\n";
}
System.Windows.Forms.Clipboard.SetText(
s.ToString(),
TextDataFormat.Text);
}


Source:
https://www.garysieling.com/blog/adding-export-excel-option-fiddler

5. Save
6. Open Tools
7. Now click on the new menu "Copy Request Timings to Excel"

see screenshot https://techscreen.tuwien.ac.at/sites/default/files/Fiddler-Export.png

The Log will be copied to the clipboard as csv format.

8. Open Excel and paste content from clipboard