Create Script in Mac OS X to ping from csv

The goal here would be to ping an IP stored in a .csv file

I found the following that may work

machineName, MachineIP

dozer,192.168.2.1

dozer2,192.168.2.2

dozer3,192.168.2.3

i=0;

for $line in `cat spreadsheet.csv`;

do

ip=`echo $line | cut -f2 -d","`;

if [ $i -ne 0 ]; then

if [ `ping $ip -c1 | grep -c -i "64 bytes from ${ip}"` -eq 0 ]; then

....

else

echo "$ip could not be pinged" >> /var/log/mylogfile;

fi

fi

i=1;[/code]

i is used as the 1st line of the csv is headers.