Administration> Periodic> Data export/import> Excel spreadsheets> Microsoft Office Excel export

Use this form to define options for data export from Microsoft Dynamics AX to an Excel workbook and to start the actual export.

For more information about the Excel file, see Microsoft Office Excel import (class form).

Tasks that use this form

Navigating the form

The following links and tables provide descriptions for the controls in this form.

Tab	Description
Advanced	Optional. Define advanced options for the data import.

Field	Description
Definition group	Select a definition group that specifies the tables and fields to export data from. Using a definition group is mandatory for Excel export. Definition groups are created in the Definition groups form.
Override file names specified in the Definition group	When this check box is selected, file names provided in the definition group specification are overridden and the file listed in the File namefield is used for data from all tables.
File exists rule	Specify how Microsoft Dynamics AX should handle the export if one of the file names listed on the Generaltab or in the definition group already exists: Abort export– Stop the export. Skip file– Continue with the export but skip the file that already exists. Create additional file– Continue with the export and create a new file so that the existing file is not modified. Modify file– Continue with the export and modify data in the existing file. Overwrite file– Continue with the export and overwrite data in the file.
Include already exported files	Reset the Export statusin the Definition groupso that files are exported even if they have previously been fully or partially exported. For more information, see Table setup (form).
Include supporting tables	Export also includes lookup tables. Inclusion of the lookup tables eases data entry and helps ensure data integrity during later import. The table data is exported to a sheet in the export named `#Lookup`.