And here''s the scorecard: CPV-GB-OneCol0-6192019-Resolved-Sort.ods ==> Three
hostnames that should have been found with Magic
Banana's script were somehow missed ("None ?).
It works here (hostname_list contains the first column of your spreadsheet):
$ ./find-IPv4-addr.awk hostname_list
178-137-92-231.broadband.kyivstar.net 178.137.92.231 231.92.137.178
137.92.231.178
static.83.94.46.78.clients.your-server.de 83.94.46.78 78.46.94.83
94.46.78.83
bb121-7-170-10.singnet.com.sg 121.7.170.10 10.170.7.121 7.170.10.121
fulltextrobot-77-75-76-161.seznam.cz 77.75.76.161 161.76.75.77
75.76.161.77
google-proxy-64-233-173-150.google.com 64.233.173.150 150.173.233.64
233.173.150.64
17-58-96-188.applebot.apple.com 17.58.96.188 188.96.58.17 58.96.188.17
baiduspider-180-76-15-137.crawl.baidu.com 180.76.15.137 137.15.76.180
76.15.137.180
crawl-54-236-1-12.pinterest.com 54.236.1.12 12.1.236.54 236.1.12.54
host-185-251-38-166.hosted-by-vdsina.ru 185.251.38.166 166.38.251.185
251.38.166.185
ip199.213-181-133.pegonet.sk 199.213.181.133 133.181.213.199 213.181.133.199
msnbot-157-55-39-153.search.msn.com 157.55.39.153 153.39.55.157
55.39.153.157
msnbot-157-55-39-222.search.msn.com 157.55.39.222 222.39.55.157
55.39.222.157
msnbot-157-55-39-88.search.msn.com 157.55.39.88 88.39.55.157
55.39.88.157
msnbot-207-46-13-125.search.msn.com 207.46.13.125 125.13.46.207
46.13.125.207
static.88-198-36-62.clients.your-server.de 88.198.36.62 62.36.198.88
198.36.62.88
140.82.10.185.vultr.com 140.82.10.185 185.10.82.140 82.10.185.140
143.237.193.82.ediscom.de 143.237.193.82 82.193.237.143 237.193.82.143
219.63.227.35.bc.googleusercontent.com 219.63.227.35 35.227.63.219
63.227.35.219
116-48-158-174.static.netvigator.com 116.48.158.174 174.158.48.116
48.158.174.116
24-181-158-230.static.dlth.mn.charter.com 24.181.158.230 230.158.181.24
181.158.230.24
5-255-250-121.spider.yandex.com 5.255.250.121 121.250.255.5 255.250.121.5
62.62.198.146.dyn.plus.net 62.62.198.146 146.198.62.62 62.198.146.62
77-88-47-28.spider.yandex.com 77.88.47.28 28.47.88.77 88.47.28.77
bot-103-131-71-48.coccoc.com 103.131.71.48 48.71.131.103 131.71.48.103
c-71-236-162-44.hsd1.or.comcast.net 71.236.162.44 44.162.236.71
236.162.44.71
crawl-66-249-79-111.googlebot.com 66.249.79.111 111.79.249.66
249.79.111.66
crawl-66-249-79-139.googlebot.com 66.249.79.139 139.79.249.66
249.79.139.66
fulltextrobot-77-75-78-162.seznam.cz 77.75.78.162 162.78.75.77
75.78.162.77
fulltextrobot-77-75-79-95.seznam.cz 77.75.79.95 95.79.75.77
75.79.95.77
google-proxy-64-233-173-149.google.com 64.233.173.149 149.173.233.64
233.173.149.64
google-proxy-64-233-173-151.google.com 64.233.173.151 151.173.233.64
233.173.151.64
google-proxy-66-102-6-215.google.com 66.102.6.215 215.6.102.66
102.6.215.66
google-proxy-66-102-6-217.google.com 66.102.6.217 217.6.102.66
102.6.217.66
host81-142-252-114.in-addr.btopenworld.com 81.142.252.114 114.252.142.81
142.252.114.81
ip174-67-55-131.ok.ok.cox.net 174.67.55.131 131.55.67.174 67.55.131.174
va-71-51-6-42.dhcp.embarqhsd.net 71.51.6.42 42.6.51.71
51.6.42.71
abts-tn-dynamic-70.160.49.171.airtelbroadband.in 70.160.49.171
171.49.160.70 160.49.171.70
customer-static-201-216-208.145.iplannetworks.net 201.216.208.145
145.208.216.201 216.208.145.201
static-mum-182.59.70.225.mtnl.net.in 182.59.70.225 225.70.59.182
59.70.225.182