How do I bring data from my SignalHawk into Excel?

Once you have a capture you want to analyze on you SignalHawk, export it as a .txt file. You may want to export the Settings as a .xml file as well as you will need to know the start and stop frequencies if you want to associate power readings with frequency buckets.

Move the exported .txt file to a computer via Bluetooth file share or USB drive.

In a new excel file:

1. Go to the Data tab
2. In the Get & Transform Data section, select From Text/CSV
3. Select the exported .txt file from you SignalHawk.
4. In the window that appears, select Transform Data
5. Select Split Column > By Delimiter
6. Select Comma as the Delimiter
7. Under Advanced Options, Split into Rows
8. Close & Load
9. You now have a table in Column A with your SignalHawk measurements.

To associate each measurement with a group/bucket of frequencies:

1. In cell B2, enter your start frequency
2. In cell B3, enter this formula:

   =B2+(StopF-$B$2)/1022

   Replace StopF with your Stop frequency.
3. Fill the rest of column B with this formula.

This associates each reading a frequency, the bucket of frequencies represented by each reading is the frequency +/- (StopF-StartF)/(1022), where StopF and StartF are the start and stop frequencies and N is the total number of readings minus 1. In the general case, 1022=N-1, where N is the number of readings; SignalHawk always returns 1023 readings.

Note: If you set the start frequency below SignalHawk's minimum analysis frequency of 9 kHz, the frequency bucket size will change accordingly, and data will be returned for those lower frequencies. However, the specifications of the datasheet are unchanged. Measurements below 9 kHz are not guaranteed for accuracy.