If your organisation permits you might be able to use LDAP to populate those field:
VBA excel Getting information from active directory with the username based in cells
https://documentation.sailpoint.com/connectors/active_directory/help/integrating_active_directory/ldap_names.html