Currently there no way to identify Dynamics CRM base licensed users from CRM. This results in manual effort getting information from Office 365 in excel.

Please add new field to update if user have Dynamics CRM base licensed assigned which can help customer to analyse usage w.r.pt. their license assignment without extra manual efforts..