Run Powershell as admin

Get-vm | Get-VMNetworkAdapter | select-object VMname, Macaddress, Name | Export-Csv -Delimiter “;” -Path C:\vmmacs.csv

VMName = name of the virtual machine
Macaddress = Mac of the VM being used
Name = The type of network adapter being used such as Network Adapter and Legacy Network Adapter

Delimiter is ; which is how they are spaced out so that you can convert from text to collumn.

Open the file in Excel, select the column, then click on Data tab then text to columns, select delimited and click on next and then ensure only semicolon is ticked, and then click finish