Summary: IP
Tools for Excel – Add-in / Plug-in provides functions and fully automatic or programmable,
macro like features. There is a gui
interface. Ping, ping sweep, bulk ping, dns
lookup, sort IP addresses, launch remote desktop protocol (rdp), launch SSH, launch telnet, launch
http and https, trim clean cells. Sheet functions to remove shading, remove
comments, remove text color. Excel worksheet functions to ping, NsLookup, open
TCP ports, open http web pages. Network test and evaluation.
Advisory: IP
Tools for Excel is capable of generating large amounts of network traffic. High
packet per second rates can consume large amounts of network bandwidth per
second. It can cause network security systems to alarm and block traffic.
Traffic patterns generated may be considered Denial of Service Attacks (DOS).
Please use this tool responsibly and professionally
IP Tools for Excel will stress test system and network
performance.
It can be considered a network "Hammer"
originating a substantial amount of connection attempts, ping
packets, name server lookups and thusly bits per second.
Features:
·
Very Fast - Select your cells and get results.
You will save much time with this tool. Guaranteed
· No
cutting and pasting or importing - saves key strokes - it is now part of
Excel
· You get
both: GUI ribbon interface, with no programming needed and the full featured
functions and formulas
· Right
click and choose command on any cell or range including entire columns or rows
· NSLookup
o NsLookup
- DNS lookup forward or reverse - 100's of results instantly any way you
need, red cell, green cell, comments in any cell
o Lookup and resolve IP Addresses
and host names
o Auto flush the DNS
cache. No misleading results
o Test that forward and
reverse DNS
entries match
o Measure a name servers
response time for query results
o DNS Performance
Testing - DNS Hammer
- Are your servers up to handling the load?
· Ping
o Ping - 100's of
results instantly any way you need in any cell
o Ping - Up to 100 at a
time depending on your computers capabilities
o Ping any selected
list of IP addresses or host names
o Ping sweep range of
IP's
o Launch Ping
continuously in command window
o Ping packet
parameters are customizable - 1 to 200k pings per address, size, content, delay
o Network Performance
Testing - Ping Hammer
- See where packets are dropped under load
· Sort IP
Addresses in Excel - 192.168.45.252 does not come before
192.168.45.54
o Select cells or columns,
identify the IP addresses, then sort them with expected results
o Extensive multi-level
column sort. Also sort IP addresses in multiple Excel columns too
o Sorting IP addresses in Excel
is fast and easy
· In Excel
Launch and make RDP SSH Telnet and HTTP(S) hyperlink connections
o Launch to HTTP or
HTTPS from any list of host names or IP addresses
o Connect to many Cisco
routers and switches or firewalls with two clicks - ssh, telnet
o SSH in Excel is easy
and fast
o Remote Desktop
Connections - open launch or hyperlink RDP sessions in Excel
· Trace
Route in a command window with two clicks and no typing
o Fast - sets your
timeout and numeric output preferences
· Trim
Clean functions
o Removes leading and
trailing white space including most non printable characters from the cells in
you selection
· Sheet functions
or Excel formulas are also included:
Ping, NsLookup, OpenTCP and OpenHTTP
o Versatile
=Ping(TargetHost, [ReturnType],[PingCount])
o Return record types A,
PTR, CNAME, MX, TXT, and LOC. Set the IP address of the name server to be
used for nslookup
=NsLookup(TargetHost, [ReturnType], [RecordType], [TimeOut], [DNS_SERVER_IP])
o Port check tool for
open TCP ports tests for speed and scans for inconsistent performance
=OpenTCP(TargetHost, [ReturnType], [Port], [TimeOut])
o Test HTTP request
speed and return results. HTTPS too. Any URL any port
=OpenHTTP(TargetURL,
[ReturnType],[TimeOut])
Powerful functions return
TRUE/FALSE, values, and response time for testing and evaluation of
your network
Use Excel conditional formatting to display any type of result required
IP
Tools for Excel Functions provided explanation and help page
· Output
directly in Excel with 1000's of output and format options
o Set output to ANY
cell
o Comments
o Results - Bangs and
Dots, Ping Times, Summaries, NsLookup Names, IP Addresses
o Cell Shading - Row
Shading Color
o Text Color
o And more
· GUI interface
for setting options and settings
This
solution for Microsoft Excel 2003 - 2013 provides IP Address management
capabilities. Running on Excel 2003 there are fewer features. Ping and NsLookup (DNS Lookup) for your
Excel worksheets. Automatic IP address lookup. Forward
and reverse DNS lookup functions. Ping sweep an entire list of
IP addresses or names instantly. Ping sweep or ping test
instantly. Sorting IP Address in Excel. Analyze and
parsing of IIS logs benefit from the ability to sort IP addresses in
Excel. Trace Route, SSH, RDP and Telnet
connection options from Excel.
The ultimate ping nslookup script. Not
VBA code. This is a com-add in.
When IP Tools is enabled and Excel is started, you will find
additional tool bars or ribbon and menu commands which provide functionality
to execute and display results from such commands as ping and
nslookup.
Your IP addresses, Host Names or URLs on the sheet - Click for Ping,
NsLookup, trace route - Launch RDP SSH Telnet and more.
The
functionality provided by IP Tools for Excel can not be achieved with
a VBA macro or ping script.
How to ping a host from an Excel spreadsheet? How to lookup up
a host address? Not a macro, not vba, not a script. IP Tools
for Excel.
IP
Tools for Excel is a COM add in that provides additional
functionality within the Microsoft Office Excel Program. It
does not expose any VBA code or macro script.
