MAC2CSV

Added file picker, reduced unneeded code, increased resiliency (11/2023)

MAC2CSV

What does it do?

Mac2CSV Converts the output of a MAC Address Table such as "# sh mac address" or ARP TABLE like the output of "# sh ip arp" in a text file to a CSV file ready for Google Sheets / Excel

Dependencies

• Requires the output of a MAC Address table or IP ARP table saved as a text file
• Requires Python3.x

Why

• Having this information in a spreadsheet allows for record keeping and retrieval that is useful to Network and Systems Engineers (such as myself 😄)

---

Output Example

Updates / Fixes

• Automatically checks and attempts to update the required libraries (05/19/2022)
• Added the name as a banner and info box on what the app does (04/26/2022)

---

This app is free❗

MAC2CSV

What does it do?

Converts the output of a MAC Address Table such as "# sh mac address" or ARP TABLE like the output of "# sh ip arp" in a text file to a CSV file ready for Google Sheets / Excel

Dependencies

• Requires the output of a MAC Address table or IP ARP table saved as a text file
• Requires Python3.x

Why

• Having this information in a spreadsheet allows for record keeping and retrieval that is useful to Network and Systems Engineers (such as myself 😄)

---

Output Example

This app is free❗

MAC2CSV

03/14:

• Converts the output of a # sh ip arp or #sh mac address table to a CSV (comma separated values) file for spreadsheet applications
• Colors added to console output
• Requires Python 3.x to run

MAC2CSV

• 03/11/2022: Converts the copied output of a #sh ip arp or a #sh mac address-table to a comma-separated-value (csv) file ready for Google Sheets (https://sheets.google.com) or MS Excel