---
updatedAt: 2025-10-02T19:13:13.000Z
agentTools:
  projectIndex: https://docs.quable.com/v5-EN/llms.txt
---

# Profiles

Frequently import the same type of file? Save your preferences!

The **Import Profiles** page is where you can define and manage the profiles for your Quable PIM imports. The page includes a brief description of the feature, a link to this documentation page, and a list of existing import profiles, if any.

* If no import profiles have been created yet, a <strong>Create Profile</strong> button is displayed in both the <strong>Current Import Profiles</strong> section and the top right corner of the page.

* If import profiles have already been created, a list is displayed with: the <strong>Name</strong> of the profile, the profile's <strong>Data Type</strong>, the file <strong>Format</strong> (CSV or XLSX), an indication if attribute <strong>Mapping</strong> is used, data <strong>Languages</strong>, and whether or not the profile is for <strong>Remote</strong> imports. The <strong>Create Profile</strong> button is only displayed in the top right corner of the page.

<Image title="Capture d’écran 2022-12-21 à 17.22.10.png" alt={2880} align={"center"} width={"80%"} src="https://files.readme.io/2395193-Capture_decran_2022-12-21_a_17.22.10.png" />

<Image title="EN_b_editDeleteMore.png" alt={1054} align={"center"} width={"80%"} src="https://files.readme.io/b3bd54b-EN_b_editDeleteMore.png" />

<table style={{borderCollapse: 'collapse'}}>
<tr>
<td style={{verticalAlign: 'top', border: '1px solid white', backgroundColor: 'white'}}>When you click:</td>
<td style={{verticalAlign: 'top', border: '1px solid white', backgroundColor: 'white'}}> </td>
</tr>
<tr>
<td style={{verticalAlign: 'top', border: '1px solid white', backgroundColor: 'white'}}>
<strong>Initiate a punctual import</strong> - A page for starting the import is displayed, preconfigured for the selected profile.
</td>
<td style={{verticalAlign: 'top', border: '1px solid white', backgroundColor: 'white'}}>

<Image title="Capture d'écran 2022-12-21 à 17.27.03.png" alt={2436} align={"center"} width={"80%"} src="https://files.readme.io/488f928-Capture_decran_2022-12-21_a_17.27.03.png" />

</td>
</tr>
<tr>
<td style={{verticalAlign: 'top', border: '1px solid white', backgroundColor: 'white'}}>
<strong>Download the import file template</strong> - A CSV file is downloaded with predefined column headers according to the selected profile.
</td>
<td style={{verticalAlign: 'top', border: '1px solid white', backgroundColor: 'white'}}> 

<Image title="importTemplate.png" alt={722} align={"center"} width={"auto"} src="https://files.readme.io/0700074-importTemplate.png" />

</td>
</tr>
</table>

### Creating Profiles

To create an import profile click the **Create Profile** button. The **Create an Import Profile** form is displayed:

<Image title="Capture d’écran 2022-12-21 à 17.28.15.png" alt={2574} align={"center"} width={"80%"} src="https://files.readme.io/f869a60-Capture_decran_2022-12-21_a_17.28.15.png" />

The form is divided into three sections: **Profile Identity**, **Import File Format**, and **Mapping**. These are described in detail below. When you've completed the sections, click the **Create** button to save the profile.

#### Profile Identity

This section is used to distinguish each import profile and its settings.

<Image title="Capture d’écran 2022-12-21 à 17.28.34.png" alt={2550} align={"center"} width={"smart"} src="https://files.readme.io/92c5292-Capture_decran_2022-12-21_a_17.28.34.png" />

Enter the following information:

<Table align={["left","left","left"]}>
  <thead>
    <tr>
      <th>
        Information
      </th>

      <th>
        Description
      </th>

      <th>
        Mandatory
      </th>
    </tr>
  </thead>

  <tbody>
    <tr>
      <td>
        **Name**
      </td>

      <td>
        The name of the import profile.
      </td>

      <td>
        Yes
      </td>
    </tr>

    <tr>
      <td>
        **Description**
      </td>

      <td>
        Enter text to describe the import profile.
      </td>

      <td>
        No
      </td>
    </tr>

    <tr>
      <td>
        **Object Type**
      </td>

      <td>
        The type of content the profile will import.  

        Possible values:<br/><ul><li>**Assets**</li><li>**Classification**</li><li>**Document** - when selected, a mandatory option to specify the type of document appears. </li><li>**Links** - when selected, a mandatory option to specify the type of document appears. </li><li>**List of values**</li><li>**Variants**</li></ul>
      </td>

      <td>
        Yes
      </td>
    </tr>

    <tr>
      <td>
        **Languages** 
      </td>

      <td>
        The data language to import. <br/><br/>**Note**: Only content for the translatable attributes in the designated language(s) will be imported, however attributes that can't be translated are taken into consideration (e.g., numbers).  

        *Example*\
        Your designated language is French and your import file includes translations in both French and another language. Only the French translations are imported, as well as any attributes that can't be translated (e.g., a *price* attribute with an *number* value).
      </td>

      <td>
        Yes
      </td>
    </tr>

    <tr>
      <td>
        **Empty cell action** 
      </td>

      <td>
        Defines the action to take if empty cells are encountered during the import operation. By default, empty cells are considered = 0.  

        Possible values:  

        <ul><li>**Ignore** - Empty cells in the import file are disregarded and any existing content (if updating objects) remains unchanged.</li><li>**Replace** - Empty cells in the import file overwrites any existing content (if updating objects). <br/><br/>**Note**: It's recommended to complete the columns with the correct values in order to avoid unintended consequences (e.g., set "active" to "1", so it isn't replaced by "0" and setting your content inactive.)</li></ul>
      </td>

      <td>
        Yes
      </td>
    </tr>
  </tbody>
</Table>

<br />

#### Import File Format

> 🚧 Important Note
>
> * File formats can not be changed once a profile is saved.
> * Files can only be imported one at a time.
> * Large files (100+ columns) may impact performance during the import.

This section is used to specify the format and parameters (if any) of your import file. Two options are available:

* **XLSX**

<Image title="Capture d’écran 2022-12-21 à 17.28.59.png" alt={2538} align={"center"} width={"smart"} src="https://files.readme.io/481e6cd-Capture_decran_2022-12-21_a_17.28.59.png" />

> 🚧 Limitation on XLSX files:
>
> * Maximum file size: 10Mb
> * Maximum number of lines: 200,000
> * Maximum number of columns: 1000

> 🚧 Mapping is required for .xlsx imports.
>
> To import .xlsx files, standard settings are used. You don't need to specify any parameters.

In the case of .xlsx files, standard settings are used. You do not need to specify any parameters.

* **CSV (default)**

<Image title="Capture d’écran 2022-12-21 à 17.29.42.png" alt={2544} align={"center"} width={"smart"} src="https://files.readme.io/b568d33-Capture_decran_2022-12-21_a_17.29.42.png" />

> 🚧 Limitations on CSV Files
>
> The following limitations apply to CSV import files:
>
> * Maximum file size: 50 MB
> * Maximum number of lines: 200,000
> * Maximum number of columns: 1,000

> 👍 Good to know
>
> Mapping is optional for .csv imports.

To import .csv files, you have two options for parameters:

* **Standard** - Standard settings are used. You don't need to specify any parameters.
* **Custom** - You must specify the following parameters (you can click the *Fill with default values* link to automatically select the default settings):

| Parameter             | Description                                                             | Possible values                      |
| --------------------- | ----------------------------------------------------------------------- | ------------------------------------ |
| Encoding              | The Unicode character encoding of the import file.                      | UTF-8 (default)                      |
| Attributes separator  | The character used to separate attributes in the import file.           | Comma, Semicolon (default), Tab      |
| Date time separator   | The character used to separate date and time values in the import file. | Space (default)                      |
| Enclosure             | The character used to indicate the beginning and end of a data value.   | Double quote (default), Single quote |
| End of line           | The character used to indicate the end of a line of data.               | \n (default)                         |
| Date format           | The format used for dates in the import file.                           | yyyy/mm/dd, dd/mm/yyyy (default)     |
| Time format           | The format used for times in the import file.                           | hh:mm.ss (default)                   |
| Multi value separator | The character used to separate multiple values within an enclosure.     | Pipe (default)                       |
| Number format         | The format used for numbers in the import file.                         | 00.00 (default), 00,00               |

<br />

#### Mapping

This section allows you to specify which columns of your import file correspond to the content in your Quable PIM.

<Image title="Capture d’écran 2022-12-21 à 17.30.05.png" alt={2548} align={"center"} width={"80%"} src="https://files.readme.io/fccc63d-Capture_decran_2022-12-21_a_17.30.05.png" />

> ❗️ Warning
>
> When mapping is enabled, only the mapped columns are taken into account and imported.

Enabling the mapping option expands the section:

<Image title="Capture d’écran 2022-12-21 à 17.31.05.png" alt={2536} align={"center"} width={"auto"} src="https://files.readme.io/c7e0ef6-Capture_decran_2024-04-26_a_14.55.54.png" />

The expanded section is divided into three columns:

* **File Columns** - This column is used to identify columns in your import file.
* **PIM Attributes** - This column is used to designate the PIM attribute that corresponds to the *file column*.
* **Object Attributes** - The column contains all of the available properties for the selected object type.

To map your import file to your Quable PIM content, select attributes from the **Object Attributes** column and drag / drop them into the area below **File Columns -> PIM Attributes**.

<Image title="Capture d’écran 2022-12-21 à 17.31.23.png" alt={1636} align={"center"} width={"smart"} src="https://files.readme.io/9762d54-Capture_decran_2024-04-26_a_14.55.49.png" />

> 🚧 Important note
>
> * Object Attributes outlined in orange are **mandatory**.  An import can't be started if they're not selected.
> * All of the columns in your import file must be mapped to PIM attributes.

You can modify the titles of the attributes under **File Columns** so that they correspond to the titles of the columns of your import file.

Once you have entered all the information for a new import profile, click the **Create** button to save your changes or the **Return** link (at the top of the form) to return to the **Import Profiles** page without saving the new import profile.

### Editing Profiles

You can modify an import profile by selecting one from the **Current Import Profiles** list and clicking its **Edit** icon.

<Image title="Capture d’écran 2022-12-21 à 17.32.01.png" alt={2880} align={"center"} width={"80%"} src="https://files.readme.io/8286a4d-Capture_decran_2022-12-21_a_17.32.01.png" />

The **Edit import profile** page is displayed. You can modify the:

<ul>
<li>Name</li>
<li>Description</li>
<li>Empty cell action</li>
<li>Import File Format parameters (The format of the file can not be changed.)</li>
<li>Mapping</li>
</ul>

When you've finished making modifications, click the **Save** button to save your changes or the **Return** link (at the top of the form) to return to the **Import Profiles** page without saving the changes.

### Deleting Profiles

To delete an import profile, click on the **Delete** icon on the **Import Profiles** page. A dialog is displayed to cancel or confirm the deletion.

<Image title="Capture d’écran 2022-12-21 à 16.54.04.png" alt={834} align={"center"} width={"50% "} src="https://files.readme.io/01f97fa-Capture_decran_2022-12-21_a_16.54.04.png" />

> ❗️ Attention
>
> This action is irreversible. Once an import profile has been deleted, it can't be recovered.