Thank you all for the help!
I did like keeping my waypoint database in a spread sheet. I kept a lot of extra information e.g. whether the WP had been use tested, its origin etc. However, Once I get good GPX files I'll probably give up.
If there's anyone in a similar situation PM me and maybe I can help.
Here is my current
process: (The "Temp sheet is a template that G7toWIN understands)
1 Copy Name, lat, lon, and comment columns to "Temp" sheet
2 Put W in col (A), Name (B), Comment (K), 18 (L), S+N (N), leave other colums blank
3 Remove blank lines
4 Copy entire "Temp" sheet to new workbook, including header line
5 "save as" csv file in /Navigation/csv files/
6 Run G7toWin and open csv file, Save as GPX file
7 Open GPX file in Notepad, replace "Waypoint" with "triangle", replace "<extensions>" with "<extensions><opencpn:viz_name>1</opencpn:viz_name>", save file
8 Check in O and Mapsource