To export the contents of a DHCP database to a delineated text file, use Dhcpcmd.exe.
Logon to the DHCP server with Administrative priviledges and type the following at a CMD prompt:
dhcpcmd <IPAddress> enumclients <ScopeNetAddress> -<option> > <Path\outfile.txt>
<IPAddress> is the IP Address of the DHCP server.
<ScopeNetAddress> is the network address of the DHCP scope.
<option> is v for detailed lease information or h for lease / hardware information.
<Path\outfile.txt> is the output file, which can be imported into Excel, Access, Word, etc....
dhcpcmd 192.168.1.10 enumclients 22.214.171.124 -h > dhcpout.txt