Nuts About Nets

Wireless Diagnostics & Troubleshooting

  • Products
    • WifiMETRIX
    • RF Explorer
  • Software
    • General RF
      • Touchstone-Pro
      • Touchstone (Standard)
      • AirSleuth — RF Spectrum Analyzer Software for RTLSDR (RTL2832U)
      • Rational Waves
      • RF Analyzers Supported By Rational Waves
      • Remote RFExplorer — Cloud Data Sharing
    • Wireless ProAudio
      • ClearWaves — RF Spectrum Analyzer & Frequency Coordination Software
      • IntermodAnalyzer — RF Spectrum Analyzer & Frequency Coordination Software for RTLSDR (RTL2832U)
    • Wi-Fi
      • WiFi Surveyor (Windows)
  • 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 © 2025 ·Nuts About Nets