# How to map dynamic or specific fields from an Excel worksheet

**URL:** <https://community.synatic.com/t/how-to-map-dynamic-or-specific-fields-from-an-excel-worksheet/244>\
**Category:** Flows\
**Tags:** helper-functions\
**Created:** [June 6, 2022, 4:36pm UTC](https://community.synatic.com/t/how-to-map-dynamic-or-specific-fields-from-an-excel-worksheet/244 "2022-06-06T16:36:03Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![navessa](https://yyz2.discourse-cdn.com/flex032/user_avatar/community.synatic.com/navessa/32/58_2.png) [@navessa](https://community.synatic.com/u/navessa)\
**Post date:** [June 6, 2022, 4:36pm UTC](https://community.synatic.com/t/how-to-map-dynamic-or-specific-fields-from-an-excel-worksheet/244/1 "2022-06-06T16:36:03Z")

</div>

If you require data from **dynamic fields in your Excel worksheet** , the following is how you can pull the data:

Illustrated below is an example of an Excel spreadsheet where we **require the data from the highlighted fields**.

 ![image](https://canada1.discourse-cdn.com/flex032/uploads/synatic/original/1X/9b2c0d4676ce987e599520c693b811afaf398843.png)

An **Excel reader step** is used. Highlighted in the image below is the row number of the header row and the row number of the row where the data starts. The **AutoMap** checkbox has been **enabled**.

 ![image](https://canada1.discourse-cdn.com/flex032/uploads/synatic/original/1X/c7195d0ccd66170265fad2207e463a32c7df7dad.png)

When scrolling down the Excel reader step, under the **Column Mappings section** is where you will map the fields according to the **column letter** in the Excel worksheet as shown in the image below. Click on the highlighted icon to add more fields to map.

 ![image](https://canada1.discourse-cdn.com/flex032/uploads/synatic/original/1X/b40de63f420826e3740d7ec97f73223f9ebbbf42.png)

The below page is the output results of the data that is in the dynamic fields from the Excel worksheet.

![image](https://canada1.discourse-cdn.com/flex032/uploads/synatic/original/1X/f61bbc40e5893840277bd25121e375d1ff25d1ff.png)

If you require **specific fields/ columns from an Excel worksheet,** the following is how you can pull the data:

Illustrated in the image below is an Excel worksheet with many fields in it’s dataset. We require the data that is in the **highlighted fields only.**

 ![image](https://canada1.discourse-cdn.com/flex032/uploads/synatic/original/1X/d354e88653684181edb12fbcea95bc9152e302f0.png)

To get the data, the Excel reader step is used. In the image below is the **Excel reader step**. The **Name Mappings section** is used to map the required fields using the **field names aka headers** in the Excel worksheet. The **AutoMap** is **enabled**. To add a new field to the required dataset, click on the highlighted icon.

 ![image](https://canada1.discourse-cdn.com/flex032/uploads/synatic/original/1X/6bf686552e8103f93fb60137647c84b90f168503.png)

In the below page is the output results of the required fields from the Excel worksheet.

![image](https://canada1.discourse-cdn.com/flex032/uploads/synatic/original/1X/2ec6bd8620ef9ac80cf000527d478da065ddd5e5.png)