If you’re looking to export your DHCP leases on your Windows Server into a readable format, then the following article will help.
http://theadminguy.com/2009/10/14/export-dhcp-leases-to-html-using-powershell/
You can also simply run the following command and copy and paste it into excel and it should match the columns correctly.
netsh dhcp server 1.1.1.1 scope 1.1.1.0 show clients 1