---
alias: user-guide-master-data-export
description: "Export data from the system via an Excel file for mass updates and configuration"
---

# Master Data Export

:lock: Administration.**MasterDataExport**

**Master Data Export** is used to export one or more objects into a Critical Manufacturing MES environment through the use of an Excel file that complies with the Master Data file structure. This feature also allows any authorized user to perform mass updates into the system.

The **Master Data Export** page is available in the Administration page group.

![Screenshot showing a UI with filename hint "exportdata1" and nearby instructions referencing the Master Data Export page in the Administration section.](images/exportdata1.png)

!!! info
	For more specific features, formats and configurations of the packages that can be used in this section, see [[master-data-packages-tutorial]].

## Export Data to File

You can export these Entity Types:

| **Non-Versioned Entities**   | **Versioned Entities**       |
|------------------------------|------------------------------|
| [[user-guide-area-index]]                         | [[user-guide-automation-controller-index]]       |
| [[user-guide-automation-manager-index]]           | [[user-guide-automation-driver-definition-index]] |
| [[user-guide-bin-converter-index]]                | [[user-guide-automation-protocol-index]]          |
| [[user-guide-business-partner-index]]             | [[user-guide-automation-workflow-index]]          |
| [[user-guide-calendar-index]]                     | [[user-guide-bom-index]]                          |
| [[user-guide-certification-index]]                | [[user-guide-checklist-index]]                   |
| [[user-guide-change-set-index]]                   | [[user-guide-data-collection-index]]           |
| [[user-guide-chart-index]]                        | [[user-guide-data-collection-limit-set-index]]    |
| [[user-guide-container-index]]                    | [[user-guide-document-index]]                     |
| [[user-guide-employee-index]]                     | [[user-guide-experiment-definition-index]]       |
| [[user-guide-enterprise-page]]                   | [[user-guide-flow-index]]                        |
| [[user-guide-event-rules-index]]                   | [[user-guide-inspection-plan-index]]             |
| [[user-guide-facility-index]]                     | [[user-guide-maintenance-plan-index]]          |
| [[user-guide-iot-event-definition-index]]         | [[user-guide-product-index]]                      |
| [[user-guide-kpi-index]]                          | [[user-guide-product-group-index]]               |
| [[user-guide-map-index]]                          | [[user-guide-protocol-index]]                     |
| [[user-guide-map-definition-index]]               | [[user-guide-recipe-index]]                       |
| [[user-guide-material-index]]                     |                              |
| [[user-guide-ml-model-index]]                    |                              |
| [[user-guide-notification-index]]                 |                              |
| [[user-guide-parameter-index]]                    |                              |
| [[user-guide-plan-index]]                        |                              |
| [[user-guide-printing-integration]]         |                              |
| [[user-guide-production-order-index]]             |                              |
| [[user-guide-qualification-index]]                |                              |
| [[user-guide-reason-index]]                       |                              |
| [[user-guide-resource-index]]                    |                              |
| [[user-guide-rule-index]]                         |                              |
| [[user-guide-sampling-pattern-index]]             |                              |
| [[user-guide-sampling-plan-index]]                |                              |
| [[user-guide-schedule-index]]                     |                              |
| [[user-guide-send-ahead-run-index]]               |                              |
| [[user-guide-service-index]]                      |                              |
| [[user-guide-setup-matrix-index]]                 |                              |
| [[user-guide-shift-definition-index]]             |                              |
| [[user-guide-shift-plan-index]]                   |                              |
| [[user-guide-site-index]]                         |                              |
| [[user-guide-sort-rule-set-index]]               |                              |
| [[user-guide-step-index]]                         |                              |
| [[user-guide-substrate-map-index]]                |                              |
| [[user-guide-substrate-map-mask-index]]           |                              |
| [[user-guide-task-index]]                         |                              |
| [[user-guide-team-index]]                         |                              |
| [[user-guide-timers|Timer]]                       |                              |

To export data, follow the steps below.

### Step 1: Types

1. Open **Master Data Export** and select the object types that you want to export. You can **Select All Items**, which will include items that are not currently visible on the screen, or only the ones you need:

    ![Screenshot showing a data export selection interface with options for selecting object types.](images/exportdata2.png)

2. Select **Next** to continue.

### Step 2: Items

1. Use the Expand all to see the rows of the Instance(s) of your selected types. You can **Select All Items**, which will include items that are not currently visible on the screen, or only the ones you need:

    ![Screenshot showing a list of items with an option to select all.](images/exportdata3.png)

2. Select **Next** to continue.

### Step 3: File Information

1. You can choose to **Append** to an existing file or **Create** a new one:

    ![Screenshot showing a filename input field with the hint "exportdata4".](images/exportdata4.png)

2. You can also **Override Existing Objects** as needed.

3. Select **Export** and then open your file:

    ![Screenshot showing a file information dialog with filename "exportdata5".](images/exportdata5.png)

    ![Screenshot showing a file information dialog with filename "exportdata6".](images/exportdata6.png)

    ![Screenshot showing a file information dialog with filename "exportdata7".](images/exportdata7.png)

!!! info
    The Master Data Loader enables you to import files for various Entity Types that support external properties. For more information, see [[tutorials-helpful-tips#importing-files-using-the-master-data-loader|Importing Files using the Master Data Loader]].

## Export Process For Individual Entities

You can also export data for individual entities. For more information, see [[user-guide-export-and-import]].