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.