To export data to an Excel dynamic worksheet:
Open a list of records in the CRM web application or in Microsoft Dynamics CRM …Click or tap Export to Excel.
Choose Dynamic worksheet.
Under Common Tasks, configure the column settings and then choose Export.
Choose Save and then save the . xlsx file. Make note of the location where you saved the file.