Logon script for Putty

Hello Experts,

I have almost 300 URLS to test to see if the Telenet connection type has been disabled. To do this, I have a column of URLS in an excel spreadsheet. I take the URL and paste it into Putty. If I can login in, I mark up the Excel spreadsheet with an X then I retest it in Putty under SSH . For example:

URL     TELNET     SSH      AD
Djfk           X              X          X    This means I logged on to both Telnet and SSH with my  AD credentials
dfjdfj         F              X          X     This means telnet was disabled because the attempt failed;  SSH was set up and I logged in  
rewor        X              F          F      This means Telnet is still available on this server and we missed setting up SSH.

I have some vba skills, and Powershell is on my machine. I also read about PLINK and think I could use it.
https://www.experts-exchange.com/questions/28516752/VBS-script-to-use-putty-plink-to-login-to-Unix-run-command-retrieve-answer-into-variable.html

Can you please advise me on what the best way to automate this and point me to some code examples? It doesn't have to use Excel or Access, that is just what I am most familiar with.

Thank you again,
Steph_M