Objective

To load large Packet Trace/Event Trace in which the number of entries exceed Excel's limit of 1 million rows and generate Pivot Reports. This usually occurs either when running a large scale (in terms of number of devices) simulations or when running simulations for large times (virtual).


Steps to open large scale files

  1. After simulation save the experiment
  2. Open a blank workbook in MS Excel
  3. Go to Data > Get & Transform Data

  4. Click on From Text/CSV
  5. Browse to find the large CSV file generated by NetSim. This will be in the experiment folder. For example<Workspace Location>/Experiment name/<Packet Trace or Event Trace> and click on Import
  6. Click on Load To (shown at the bottom in red)
  7. Various options to import that file can be found
    1. To visualize the trace file click on Only Create Connection and click on OK
    2. To generate Pivot Report, click on PivotTable Report and click on OKPivotTable Reports can be generated once the entire table is loaded.
    3. To perform calculation and obtain plots Click on Table and Click on OK
    4. Once the Trace loads to the table, users can start using all excel options which includes Adding/Deleting Table, Performing Calcluation, obtaining Plots/Charts.


When you have a large CSV it's better to split the CSV file to its MAX Limits. Consider you have a trace-file of 5M rows then split the CSV file to 5 sheets using tools such as  KuTools Plus / CSVSplitter / PythonScript etc.  Download links to the tools are given below: 

https://www.extendoffice.com/product/kutools-for-excel.html

https://download.cnet.com/CSV-Splitter/3000-2074_4-75910188.html

https://sourceforge.net/projects/splitcsv/


Once you have split files you can open all the files and perform functional operations including plotting in each individual files. However, it may be a time-consuming process performing the repeated operation and you can write VBA scripts to automate this.