> ## Documentation Index
> Fetch the complete documentation index at: https://docs.gocrisp.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Import Data

> Allows importing text or Excel data into any object within a project.

This allows users to use data they have acquired outside the planogram files and import them into objects in the planogram files.

## Why you would use this feature

There are many valuable applications for this automation:

* Updating product attributes
* Updating performance data
* Updating data in fields of planograms, fixtures, text boxes
* Creating text boxes
* Creating new products

## Feature Options

### Data File Options

Data file options allow you to select the file you will be importing and configure various settings, so it will import as expected.

#### Where is the data file you want to import?

You can select the file you want to use as a data source for your import. CSV and all Excel format files (XLS/XLSX/XLSM/XLSB) are supported.

Click on the **...** button to browse for the file containing the data to be imported.

#### Which sheet do you want to import?

This will default to the first sheet in your workbook for Excel files. If you want to use a different sheet, you can
select from the list of available sheets. Data will be imported from your selected sheet.

#### Imported data has a header row

If your data has a header row, you can indicate this here. If you have a header row, you will be
able to use the data automapping options.

#### Data starts in row

By default, your data will be imported starting from the first row. If you have a title, blank lines,
or anything at the top of your file, you can indicate where your header rows or first row of data
starts.

### Target Object

#### Which object do you want to import data into?

Select the primary object you want to import data into.  For example, if you are importing Unit Movement values into the performance records of your planogram, choose Performance.

The option you select here will affect the objects shown in the **Which other objects do you want to import data into** section of the interface.  For example, if you choose Performance, you will have the option to also import data into the Product, Planogram, and Project objects within your planograms as these objects are all related to the Performance object.

#### Create unmatched

If the object you are importing data into is Drawing, Fixture, Performance, Position, or Product, you will be given the option of creating the object (or a related object) for any objects in the input file that don't match existing items on the planogram.

For example, if you are importing performance data and a matching product cannot be found for the performance data being imported, you will be able to have a new product record created for that performance data to match to.

> [!NOTE]
>
> Unmatched records can only be made for objects you have a **match on** set in your data source.

##### Create unmatched products

Create new product records for any products not found in your planograms.  This option is only available when you have selected either Match on/ID(Product), Match on/UPC(Product) or Match on/Key(Product) for a column of your data.

##### Create unmatched fixtures

Create new fixture records for any fixtures not found in your planograms.  This option is only available when you have selected Match on and any fixture field for at least one column of your data.

##### Create unmatched drawings

Create new drawing records for any drawings not found in your planograms. This option is only available when you have selected Match on and any drawing field for at least one column of your data.

Text boxes are considered drawings in Space Planning, which can be used to create new text boxes.

#### Which other objects do you want to import data into?

### Field Mapping Options

Select any objects you want to use as a matching option or an update location. Adding fields
here will increase the selection options when you map fields.

#### Field Mapping

![Folder options image](https://mintcdn.com/crispinc/BhWWiYvsoitb8WXT/mission-control/images/import_data/field_mapping.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=a94e12aed7b88b291cf3414ac85591af)

|  #  | |
| - | - |
| ![](https://mintcdn.com/crispinc/BhWWiYvsoitb8WXT/mission-control/images/numbers/1.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=1d6ed169143a636c5f4525966967614f) | If your data source has headers, you can use the Automap Fields button to automatically match your headers with field names in the selected objects. Each matched field will be set as **Update To**. |
| ![](https://mintcdn.com/crispinc/BhWWiYvsoitb8WXT/mission-control/images/numbers/2.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=c3e5beb246e7871550c37ea4c09f8eef) | The **Clear All** button will clear any matches selected for the available columns, uncheck **Clear data in unmatched fields** and will set all fields back to **Do Nothing**. |
| ![](https://mintcdn.com/crispinc/BhWWiYvsoitb8WXT/mission-control/images/numbers/3.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=e3bc67ceab892288710996ffc3d09324) | Headers from your data or the first line of your data file will be listed here so you can determine the mapping that should be used. |
| ![](https://mintcdn.com/crispinc/BhWWiYvsoitb8WXT/mission-control/images/numbers/4.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=957b491a87ac5465ed026e7e5bd7dfa6) | Import action determines how that column of data should be used.  **Match On** - Use data in this column to compare with the selected mapping field and only update records where the data matches.  You can select multiple 'match on' fields.   **Update to** - When a match is found, the data in this column will be copied into the specified mapped field.   **Do Nothing** - Data in this column will be ignored. |
| ![](https://mintcdn.com/crispinc/BhWWiYvsoitb8WXT/mission-control/images/numbers/5.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=aee7533a7cfe5f520502ab10b7c75777) | Selecting **Clear data in unmatched fields** clears out any values in the selected field for all records that did not have a match in the data source. |
| ![](https://mintcdn.com/crispinc/BhWWiYvsoitb8WXT/mission-control/images/numbers/6.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=652dc593c6e4b1f4ac82733bbfdfc285) | Select the field you want to either match on or update to. |
| ![](https://mintcdn.com/crispinc/BhWWiYvsoitb8WXT/mission-control/images/numbers/7.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=37d5df58429a87bd6cd5bcc29d803ce4) | The data preview section will show a preview of the data in the original spreadsheet format. The preview will display the first 50 rows of the file. |
| ![](https://mintcdn.com/crispinc/BhWWiYvsoitb8WXT/mission-control/images/numbers/8.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=70ad90c311a37cfa09af28ffc58bdcaa) | By default, the data preview section is collapsed.  Clicking on the arrow in the header of the preview will open the section so you can see a preview of the data. |
| ![](https://mintcdn.com/crispinc/BhWWiYvsoitb8WXT/mission-control/images/numbers/9.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=cda508f17f57a7ac0f44883ac894a49b) | Visual indicators in the header row will indicate which fields are being used to match on (shown with an equal sign between the two fields), which ones are being updated to (shown with an arrow between the two fields), and which ones are being ignored (shown with a strikeout through the column name). |
