Top > Technical-notes > VNWA > Import Line-Filter's VNWA data into EXCEL.

Import Line-Filter's VNWA data into EXCEL.

Measure and extract the S21 frequency characteristic data of the Line-filter as shown in the photo below.
Import the extracted data into EXCEL.
VNWA：Vector network analyzer (VNWA3E) DG8SAQ

If the frequency is below 100MHz, there is no problem with a measurement jig like the one in the photo below. 
This is a photo of measuring the S21 characteristics of a common mode filter using a vector network analyzer (VNWA3E) DG8SAQ.
Right-click on "S21" and a window will appear.
Click on "Export Trace to s1p".
This image explains the procedure for measuring the S21 characteristics of a common mode filter using a Vector Network Analyzer (VNWA3E) DG8SAQ and exporting the S1P data.
This is an image explaining how to add comments when exporting S1P data using the Vector network analyzer (VNWA3E) DG8SAQ.
This is an image showing the location where the data is saved when exporting the S1P data using the Vector network analyzer (VNWA3E) DG8SAQ.
 Decide on a file name and save it.
This is an image explaining the procedure for measuring the S21 characteristics of a common mode filter using a Vector Network Analyzer (VNWA3E) DG8SAQ and exporting the S1P data by specifying a file name.
First, start EXCEL and open the file you just saved by selecting File → Open.
At that time, select all files.
 This image shows how to open an S1P file saved after measuring the S21 characteristics of a common mode filter using a Vector Network Analyzer (VNWA3E) DG8SAQ.
 When you open the file, a window like the one below will open, so follow the instructions in the image. 
This image shows how to import an S1P file from a Vector Network Analyzer (VNWA3E) DG8SAQ into Excel by specifying "Delimited" as the file format.
This image shows how to import the saved S1P file into Excel using the Vector network analyzer (VNWA3E) DG8SAQ, specifying "Tab" and "Space" as the data delimiter. 
This image shows an S1P file saved using the Vector Network Analyzer (VNWA3E) DG8SAQ being imported into Excel with "General" specified as the column and data format. 
 This image shows the S21 characteristics of a common mode filter measured using a Vector Network Analyzer (VNWA3E) DG8SAQ, and the saved (s1p) data was imported into Excel.
 The data above 100MHz is shifted one square to the left, so we will correct it. 
This image shows the S21 characteristics of a common mode filter measured using a Vector Network Analyzer (VNWA3E) DG8SAQ, and the saved (s1p) data immediately after importing it into Excel. It shows how to shift one cell to the right for data above 100 MHz.
This image shows the data used to measure the S21 characteristics of a common mode filter using a Vector Network Analyzer (VNWA3E) DG8SAQ, and can be used to create a frequency response graph. 
Convert Line-Filter's VNWA-s1p data to dB and impedance.
Displays the converted Line-Filter dB data as a graph.
Displays the converted Line-Filter impedance data as a graph.
How to use Create-dB&Zgraph-from-VNWAs1p calculation sheet.
Click here to download CalculateGraph-dBZ-from-VNWAs1p.xlsx

© SMPS Solution