Sennheiser-G4-Scan-Converter

Made to be used with Google Sheets/Appscript & RF Explorer/Touchstone Pro Scans, to convert and format CSV's to Sennheiser WSM format

Link to my own sheet for usage:

Wireless Frequency Range Document - RF Explorer CSV to Sennheiser WSM CSV

---

Largely inspired by this video: Loading RF Scans ingo IAS, WWB6 and WSM - PeterErskine

And people from this thread: ProSoundWeb Community - RF Explorer to WSM

Export CSV from Michael Derazon

---

How to set up the .gs Appscript File on Google Sheets:

1. Open My Sheet and go to File -> Make a Copy

2. In your new copy of this file: go to Extensions -> Appscript and on the left-hand side of the new window click the Triggers alarm icon.

3. In the bottom right, click Add Trigger and select the onOpen Function to run On Open, then click Save.

4. Then, authorize the code to run from your account: LOOK THROUGH THE CODE FIRST BEFORE AUTHORIZING ANYTHING ON YOUR ACCOUNT!!!

5. Refresh the sheet, and see that the new menu dialog next to Help, Create Sennheiser WSM File has popped up

How to use the sheet

1. Export your Touchstone Pro scan to .csv format

2. In the RF Explorer Paste tab, go to File -> Import and upload your CSV. Select Replace Current Sheet and then click Import Data

Your Replaced sheet should look like this:

3. Go to the Create Sennheiser WSM File Menu and select Download Sennheiser WSM CSV

4. When the dialog box appears with the download link, click it and download the file. That's your converted scan data!

Notes:

I've provided an example Touchstone Pro Scan + a Sennheiser converted scan that works in my software in case you want to see the formatting for yourself or compare it to previous iterations.

The biggest note is that the Sennheiser file uses ; instead of , for cell separation, and the Sennheiser data expects a scan % in between the Frequency and RF level

I've also provided the .gs code in this file if you want to look at it yourself in a code editor