How to export EIGRP tables and SHOW IP ROUTE information to Excel

[mhoehl]

Is there a convenient way to transfer the routing entries for IP (e.g., SHOW IP ROUTE 10.0.0.0 or SHOW IP ROUTE EIGRP) from a Cisco router to Microsoft Excel. I want to sort the routing entries by gateway or by subnet.

[donewald]

If the internal redirection (inc, begin, etc) is not enough for you to do your sorting you can either pull the routing tables via SNMP (ipRouteTable) or RCMD. SNMP polling of the routing table can cause CPU issues and RCMD is seen, by some, to be a security risk.

Here is a link containing some information about RCMD:

http://www.cisco.com/en/US/partner/products/sw/iosswrel/ps1839/products_feature_guide09186a0080087c7f.html

Running 12.1 or higher IOS you should be able to do something like this to see your routes in question.

show ip route eigrp | include

That may or may not be enough capability for you.

Hope this helps,

Don

[deilert]

cut & paste the routing table to Excel then do a data > text to Columns > fixed width > then you can move the bar to the place were you want the columns to be.

[mhoehl]

Unfortunately, this will not work because each octet can take 1-3 character positions (0-255). For example, 10.9.3.0 versus 192.168.3.67.

[rais]

Unfortunately, there is no convenient solution to this problem. A practical solution follows:

1. Log the output of 'show ip route | inc D' to a file

2. Open the file in vi/notepad and replace all Ds and EX with spaces. Or you can do so in step 4 as well.

3. If not using Unix, FTP this file to a Linux/UNIX box.

4. Use sed substitute repeatedly to get rid of all prefix spaces before route entries, saving the resulting file with each repeat.

5. cat the file piped with sort.

You will have your routes sorted by subnet addresses.

Thanks.