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