Bulk MAC Address Formatter
Convert multiple MAC addresses at once. Paste from switch exports, spreadsheets, or any source — one MAC per line.
Formatted MAC addresses will appear here...
Statistics
—
Bulk MAC Address Formatting for Network Engineers
Different network vendors and operating systems represent MAC addresses in different formats. Cisco devices use dot notation (aabb.ccdd.eeff), Linux uses colons (aa:bb:cc:dd:ee:ff), and Windows uses hyphens (AA-BB-CC-DD-EE-FF). When you're working with switch exports, DHCP logs, or inventory systems from multiple vendors, you often need to convert a large batch of MACs to a consistent format.
This tool processes an entire list in one pass — paste hundreds of MAC addresses in any format and convert them all simultaneously to your target format. Invalid entries are identified and marked rather than silently skipped.
How to Use This Tool
- Paste your MAC addresses into the input field — one per line. Mixed formats are fine.
- Select your desired output format from the dropdown.
- Click Format All.
- Review the statistics panel for invalid MAC count, then click Copy All.
Supported Input Formats (Auto-detected)
AA:BB:CC:DD:EE:FF— Colon separated (Linux, macOS, most network devices)AA-BB-CC-DD-EE-FF— Hyphen separated (Windows, some printers)aabb.ccdd.eeff— Cisco dot notation (IOS switches, WLC)AABBCCDDEEFF— Raw hex, no separator (databases, some APIs)
Real-World Workflows
- Cisco switch MAC table — Export via
show mac address-table, paste the output directly. Cisco dot-notation MACs are auto-detected and converted. - DHCP server logs — Parse DHCP leases and normalize MACs for import into a CMDB or NAC system.
- 802.1X / NAC whitelisting — Build MAC allow-lists in the exact format your network access controller requires.
- Wireless controller exports — Standardize client MAC addresses from different AP vendors into a unified format.
Frequently Asked Questions
There's no hard limit — the tool runs entirely in your browser and can handle thousands of MACs in a single pass. Performance remains smooth up to tens of thousands of entries. For truly massive datasets (millions of MACs), a command-line tool like
awk or a Python script would be more appropriate.Invalid entries are flagged with an [INVALID] marker in the output rather than silently removed. The statistics panel shows how many valid and invalid MACs were found. This way you can identify problematic entries in your source data without losing their position in the list.
Yes. The tool automatically strips non-MAC content and detects the Cisco dot notation (
aabb.ccdd.eeff). You can paste the raw output of show mac address-table or show arp and it will extract and convert the MACs while ignoring VLAN numbers, port names, and other surrounding text.This tool only validates the format (12 hex characters). It does not check whether the OUI (first 3 bytes) is a registered manufacturer prefix. For that, use our MAC Vendor Lookup tool which checks against the full IEEE OUI database. Note that locally administered and multicast MACs (bit 1 of byte 1 set) will pass format validation but won't return a vendor.
The second-least-significant bit of the first octet indicates whether the MAC is globally (0) or locally (1) administered. Globally administered MACs are assigned by the IEEE to manufacturers (the OUI prefix). Locally administered MACs are assigned by the network administrator or software — commonly seen in VMs, containers, and devices with MAC randomization enabled. Locally administered MACs won't match any vendor in the OUI database.