Saving Exported Packet Information - Administration
In the first part of this two-part series, you learned the network communication concepts you need to know to understand the operation and data provided by Wireshark. I also covered the installation steps and some very basic configuration. This part will delve more deeply into using Wireshark for analyzing your network.
Step 6. When everything has been set, click “Save.” See screenshot below:
Step 7. Now go to My Documents (or any path in your computer where you save the .csv file).
Step 8. Right click on the file, and then click “Open.”
Step 9. The “Open With” dialog box will then appear. In the programs, select “scalc,” which is the Open Office Calc application, and then press OK.
Step 10. The next thing you will see is the Text Import Window in calc. Now look for “Separator Options.” Under that, confirm that “Separated by” is checked. If not, check it and then uncheck “Tab;” you will then need to check “Comma.” After that click OK; this should format the spreadsheet to the correct settings.
Step 11. Now to save it as an Excel file, go to File -> Save As -> and then, under "save as type," select Microsoft Excel 97/2000/XP (.xls). If there is a warning after clicking save, just click “Keep current format.”
Step 12. You can now close the calc spreadsheet and open the exported Excel file. You can start analyzing and working with your captured packets in the MS Excel environment.