---
title: "Import Excel or CSV (Runtime Mappings) Step"
slug: "import-excel-or-csv-runtime-mappings-step"
tags: ["csv", "excel", "import", "Mapping"]
updated: 2025-07-09T14:26:22Z
published: 2025-07-09T14:26:22Z
canonical: "documentation.decisions.com/import-excel-or-csv-runtime-mappings-step"
---

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

# Import Excel or CSV (Runtime Mappings) Step

## Overview

| ## Step Details |
| --- |
| **Introduced in Version** | --- |
| **Last Modified in Version** | --- |
| **Location** | **Data > Excel and CSV** |

The **Import Excel or CSV** step takes in a CSV/Excel file and maps the desired columns to an Object List dynamically at runtime**.**

---

## Properties

#### Error Handling

| Property | Description | Data Type |
| --- | --- | --- |
| Extra Columns in Input | Will provide an error if extra columns are found in the input (Add Outcome: provides an outcome path, Throw Exception will throw an exception on reaching error, Ignore and Continue: will add an outcome path and ignore the error.) | --- |
| Less Columns in Input | Will provide an error if the columns found are less than expected (Add Outcome: provides an outcome path, Throw Exception will throw an exception on reaching error, Ignore and Continue: add an outcome path and ignore the error.) | --- |
| Value Conversion Error | Will send an error if a value can not be converted (Add Outcome: provides an outcome path, Throw Exception will throw an exception on reaching error, Ignore and Continue: add an outcome path and ignore the error.) | --- |

#### Import Raw Lines

| Property | Description | Data Type |
| --- | --- | --- |
| Import Raw Lines | Add data of row into the specified field | --- |
|  | Into Property | Specify the mapped data field | --- |

#### Input Data

| Property | Description | Data Type |
| --- | --- | --- |
| Input File Type | Defines what the data type of the input file is | --- |
| Start On Row | Defines what row to input data from | Int32 |
| Worksheet Index | Specifies the starting point of the data | Int32 |

#### Output Data

| Property | Description | Data Type |
| --- | --- | --- |
| Output Data Type | Defines the output data type | --- |

#### Inputs

| Property | Description | Data Type |
| --- | --- | --- |
| File Data | The CSV or Excel file | FileData |
| Mapping | Mapping data | List of DynamicCSVMapping |

#### Outputs

| Property | Description | Data Type |
| --- | --- | --- |
| Done |
|  | Imported Data | Returns the data that was successfully imported | List of [Data Type] |
| Extra Columns Error |
|  | Actual Columns Number | Returns the number of columns | Int32 |
|  | Input Line | Returns the input line or error | Int32 |
|  | Line Number | Returns the line number of error | Int32 |
| Less Columns Error |
|  | Actual Columns Number | Returns the number of columns | Int32 |
|  | Input Line | Returns the input line or error | Int32 |
|  | Line Number | Returns the line number of error | Int32 |
| Value Conversion Error |
|  | Column Number | Returns the column number of error | Int32 |
|  | Error Message | Returns the error message | String |
|  | Input Line | Returns the input line or error | Int32 |
|  | Line Number | Returns the line number of error | Int32 |
|  | Source Value | Returns what the source value is | String |
|  | Target Type | Returns the expected data type | String |

#### ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1661541160909.png)

---

Related Forum Posts[Getting Values from an Excel File](https://community.decisions.com/discussion/25653/getting-values-from-excel-file-via-flow)

Training Video: [Dynamic Excel Creation](https://www.youtube.com/watch?v=hcIiRwi_8wo)

## Related

- [Split Excel Column](/split-excel-columns.md)
- [Get Excel Row](/get-excel-row.md)
- [Convert Excel or CSV to Dynamic Data Rows](/convert-excel-or-csv-to-dynamic-data-rows.md)