Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

If you're exporting CSV from Wireshark (File > Export Packet Dissections > As CSV...), rather than using -T fields etc. in TShark, then it's exporting the columns of the packet summary; if you specify the time format as "date and time of day" (View > Time Display Format > Date and Time of Day), then the CSV export will show the date and time as YYYY-MM-DD HH:MM:SS.SSSSSS.

According to this Stack Overflow question's current topmost answer:

For second accuracy, yyyy-MM-dd HH:mm:ss should do the trick.

I believe Excel is not very good with fractions of a second (loses them when interacting with COM object IIRC).

which suggests that the ".SSSSSS" part of that might be an issue, but that YYYY-MM-DD HH:MM:SS, at least, should work.