Nuts About Nets

Wireless Diagnostics & Troubleshooting

  • Products
    • WifiMETRIX
    • RF Explorer
    • Product Highlights
  • Software
    • Rational Waves — Spectrum Analyzer Software
    • RF Analyzers Supported By Rational Waves
    • Touchstone — RF Spectrum Analyzer Software
    • Touchstone MacOS — RF Spectrum Analyzer Software
    • Clear Waves — RF Spectrum Analyzer & Frequency Coordination
    • Clear Waves (MacOS) — RF Spectrum Analyzer & Frequency Coordination
    • WiFi Surveyor — RF Spectrum Analyzer & 802.11 Network Discovery Software
    • Intermod Assist RF Frequency Coordination Software
  • Support
    • Documentation
    • MacOS Support
    • FAQs
    • About Us
    • Contact Us
    • Return Policy
    • Patents
  • Store
    • Shop
  • Featured Image

Viewing CSV Log Files As A Waterfall / Heatmap in Microsoft Excel

For applications (e.g. Touchstone-Pro and WifiSurveyor) that support data logging to CSV-formatted files, we’ve included an example of a VBA macro in the installation folder that can be used for viewing the CSV data as a waterfall / heatmap in Microsoft Excel.
1. Open the CSV log file in Excel.
2. Open the VBA editor window by pressing Alt+F11
3. Import the VBA macro HeatmapVBA.bas into Excel by selecting File / Import File… from the VBA editor menu and navigate to the application’s installation folder (e.g. C:\Program Files (x86)\NutsAboutNets\TouchstonePro) to locate the file.
4. Close the VBA editor window by selecting File / Close and return to Microsoft Excel.
5. Press Alt+F8 to display the Macro dialog box. Select and run the macro Create_Heatmap_From_CSV.


Excel Heatmap

Excel makes it easy to retrieve the timestamp, frequency and signal strength from any point in the heatmap chart. To determine the timestamp of a particular point in the chart simply click along the left-most column, as shown below. The timestamp is displayed in Excel’s Formula Bar.
Excel Timestamp

Similarly, to determine the frequency at a particular point in the chart click the corresponding column near the top of the chart, as shown below. The frequency, in MHz, is displayed in Excel’s Formula Bar.
Excel Frequency

And, finally, to determine the signal strength at a particular point in the chart click the corresponding cell, as shown below. The signal strength, in dBm, is displayed in Excel’s formula bar.
Excel Signal Strength



Let’s get started on your wireless project…

Product Highlights

  • WifiMETRIX
  • RF Explorer
  • Rational Waves
  • About Us
  • Contact Us
  • SHOP

Copyright © 2023 ·Nuts About Nets