---
title: Import and export data
slug: configured-commerce/docs/import-and-export-data
docTags: 
createdAt: 2026-08-13T10:46:28.000Z
---

Optimizely Configured Commerce classifies imports and exports as integration jobs. This lets you monitor for success or failure on the Job page. Click **Upload** or **Download** in the Admin Console to start the job.

:::hint{type="info"}
**Note**

Imports and exports follow the XLSX file limits. This file format specifies a worksheet size of 1,048,576 rows and 16,384 columns.
:::

## Import data

Click **Upload** on a page such as Products, Categories, or Users to import data. You can also download an import template by clicking **Download Template**. See [Work with the import template](docId\:S-ouMp4EHztdemA6HPjp0) for more information.

Complete these steps to import with a template:

1. Format all template cells as text.
2. Remove all sample rows except for the column headers.
3. Browse for the file and choose the desired import options:
   - **Validate file before importing** **** – Choose **Yes** to have the Windows Integration Service (WIS) check the import data for errors. If it finds an error, the import process stops, and a notification displays with further options. Because the setting commits each row individually to the database then reverses the change, if you have data in a row that depends on data from a previous row (such as a variant tied to the variant parent), it fails during the validation but not during the import. Optimizely recommends using this setting sparingly as it takes more time than actual processing. Choose **No** to continue the import. Any errors display in a report.
   - **Ignore blank cells** – Choose **Yes** to ignore blank cells and not overwrite existing cells. Choose **No** to allow the import to remove existing data. 
   - **Update existing records** – Choose **Yes** to push changes from the import file to existing records, like a promotion rank change.
   - **Ignore modified date** – Choose **Yes** to let the import data override existing data. Exported data includes the ID and modified timestamp. If you re-import the data with changes, the system checks if the record was changed before the export and, if it was, it records an error unless this setting is set to **Yes**. If the modified date is not in the spreadsheet, this setting has no impact.

     ![import_options.png](https://api.archbee.com/api/optimize/BrbvVORKJ5iIeSMZye5kI/4zKIIWPz9ikERdwf9_r5p-20260720-144629.png)
4. Click **Import** to start the import. Because the internal integration service runs the import in the background, you can complete other tasks in the Admin Console. Any errors that occur display on the Admin Console screen.

## Unassign products by import

You can also unassign related product data by importing.

1. Go to **Products** > **Upload** > **Product** **Related Product**.
2. Download the template.
3. Complete the required information.
4. Set the **Unassign** column to **True** for any related products you want to unassign.
5. Browse for the file and choose your desired import options, as described in the previous section of this article.

## Export data

![ExportOptions.png](https://api.archbee.com/api/optimize/BrbvVORKJ5iIeSMZye5kI/OBA2EqgMXOZ5QYtr0aH-X-20260720-144629.png)

1. Click **Download** on a list page to access the Export page.
2. Select what you would like to export.
3. Select whether to export **Selected Products**, **Filtered Products**, or **All Products**.
4. Select the columns to include in the export. There is no limit to the number of columns you can select.
5. Click **Save as Default Selections** to save the selected column list for future exports.
6. Click **Export** to begin the export.

As with imports, you can work on other tasks in the Admin Console while the export job completes.

## Review import and export status

Once an import or export has started, you can monitor the status by going to **Administration** > **All Jobs History**.