---
title: Import PIM translations
slug: configured-commerce/pim/import-pim-translations
docTags: 
createdAt: 2026-08-05T19:28:06.103Z
---

You can translate large amounts of data by importing it.

## Help with formatting your data

If you need to download the template to help format your data, go to **Import Templates** >  **Download Import Templates** and click **Download** for **Translations**.

![download-import-templates.png](https://api.archbee.com/api/optimize/BrbvVORKJ5iIeSMZye5kI/Yf9HB3DQKY2Urd9fW9z9a-20260720-144540.png)

## Import translated properties, categories, or assets

You can import translated content for properties, categories, or assets.

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

URL segments for categories must be unique for the translated languages.
:::

1. Go to **Imports** > **Imports** tab. The **Imports** list page displays.
2. Click **Import** and select the file you want to upload. (You also can drag and drop the file onto the Imports page or click **Browse** to locate your file.) The page automatically detects the **Import Type** and asks you in the **Notes** column to verify the import type selected. If the columns match a previously saved template, the page selects that template under **Import Template**.

   ::Image[]{src="https://api.archbee.com/api/optimize/BrbvVORKJ5iIeSMZye5kI/iECr4zcteUhI32bFNvby2-20260720-144540.png" size="100" alt="import-in-progress.png" isUploading="false" showCaption="false"}
3. Click **Open** to start the upload.

The import validates the file for issues. If there is an issue, it displays a validation error message with a downloadable file. If there are no issues, the translations successfully import for the properties, categories, or assets in the file.

## Import translated products

The import process for translated products is similar to the [standard import process](docId:5NddA2hag7MzvoDBHS0Pz), except you also include a **Language** column on the **Mapping** step. A drop-down list in the **Language** column lets you select the language for mappings to any multi-language products. When importing files with column headers that include language codes, the field mappings select the language code by default. For instance, if you have column for *Product Title - EN* and *Product Title - ES*, the columns auto-map to *Product Title* with *EN* and *ES* selected. If no language code is specified, the **Language** uses the default language.

1. Go to **Imports** > **Imports** tab. The Imports list page appears.
2. Click **Import**. The Import Wizard displays. (You also can drag and drop the file onto the Imports page or click **Browse** to locate your file.) The page automatically detects the **Import Type** and asks you in the **Notes** column to verify the import type selected. If the columns match a previously saved template, the page selects that template under **Import Template**.
3. Drag and drop the file onto the Imports page. You can also click **Browse** or **Import**, locate your file, and click **Open**. The page automatically detects the **Import Type** and asks you in the **Notes** column to verify the import type selected. If the columns match a previously saved template, the page selects that template under **Import Template**.
4. Select an option for handling new or existing records:
   - **Add or update records**
   - **Only add new records**
   - **Only update existing records**
5. Choose whether to **Ignore blank cells**. If you ignore blank cells when updating, the import does not overwrite existing data with a null value.
6. Click **Select Source Fields** to map.
7. Select **File includes name/value pairs** if your data has columns for a series of names and values, where many properties may exist within any 'name' column. Select the columns with the names and values. You can then map unique values within the name columns to properties.
8. Select the check boxes beside the columns you want to import in **Available Fields**.
9. Click **Continue**. The wizard maps the source fields to the target properties.
10. Change or select any **Target Properties** if needed.
11. Select **Hide mapped fields** if you want to hide fields and focus on the unmapped fields.
12. Add a **Static Value** to import a specific value for all imported records if desired. For example, the vendor or supplier name.
13. Select **Save this option as an import template** if you want to save these field mappings and import options. The wizard automatically uses the file name plus "Template".
14. Click **Import**.