> ## 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 floorplan files and import them into objects in the floorplan files.

## Why you would use this feature

There are many valuable applications for this automation:

* Updating floorplan attributes
* Updating performance data
* Updating data in floorplans & sections
* Create and update drawings
* Create and update fixtures

## 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 header rows

If your data has a header row, you can indicate this here. If you have header rows, 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.

### 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/fp_import_data/fp_field_mapping.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=c6faffbb88470deaa91d4c72cb1a2e5f)

|  #  | |
| - | - |
| ![](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. |

### Create New Object

For sections, drawings (or text boxes), or fixtures, you can create a new object based on the data in your
source file. First, a new object will be created for each item in the data source not found in the floorplan. Then, the data from that row in the data source will be populated into the new record.

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

#### Create unmatched planograms

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

#### Create unmatched fixtures

Create new fixture records for any fixtures not found in your floorplans.  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 floorplan. 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 Floor Planning, which can be used to create new text boxes.
