A Reverse DNS Function for Google Sheets.

Often in my job I am given spreadsheets of IP addresses that look like this:

Screen Shot 2016-04-03 at 4.16.11 PM

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

One of the first things I always want to do is find if they have a FQDN.   Sadly Google keeps forgetting to build a reversedns function into sheets so with the help of a  HackerTarget API I hacked this together today:

Screen Shot 2016-04-04 at 6.45.21 AM

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

The configuration is pretty easy (although this took me way longer than I want to admit.)

The cells are setup like this:
A2: IP Address
B2: =“http://api.hackertarget.com/reversedns/?q=”&(A2)
C2: =IMPORTDATA(B2)
D2: =SPLIT(C2,” “)
E2: FQDN (Finally

Here is a link to the sheet so you can copy it and play with it. Hopefully this can help someone else out in the future as I know I have spent way too much time manually looking this information up.

Here is a gif of it in action:

Site Footer