Is there a way to export the static dhcp table to excel? I tried to copy and paste, but it does not work.
paste this on new terminal fullscreen inside winbox fullscreen:
/ip dhcp-server lease export compact
copy the results and paste on notepad or similar
remove extra top and bottom lines,
replace
“add address=” with “”
" client-id=" with “;”
" comment=" with “;”
" mac-address=" with “;”
" server=" with “;”
and so on, until you have only value;value;vlaue;etc.
Save this file as export.csv and open on excel.
Done.