# How to read data from specific individual worksheets in an Excel file

**URL:** https://community.synatic.com/t/how-to-read-data-from-specific-individual-worksheets-in-an-excel-file/276
**Category:** Flows
**Tags:** flows, helper-functions
**Created:** [July 28, 2022, 8:52pm UTC](https://community.synatic.com/t/how-to-read-data-from-specific-individual-worksheets-in-an-excel-file/276 "2022-07-28T20:52:11Z")
**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: [July 28, 2022, 8:52pm UTC](https://community.synatic.com/t/how-to-read-data-from-specific-individual-worksheets-in-an-excel-file/276/1 "2022-07-28T20:52:11Z")

</div>

If you require to **read data from specific individual worksheets in an Excel file** , follow the below instructions:

Illustrated below is an example of a flow where the SFTP Server source step is used and a Parallel control flow is used to read the data from each worksheet in the Excel file.

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

1. Add a Pass Through step as a reader step.

2. Add a source step where you can pull the file from such as a SFTP Server, Relay Base File System, Google Drive, Amazon S3 Bucket, etc.

3. Add a Parallel control flow.

4. Add a sub-flow on the Parallel flow by clicking the highlighted icon in the below image. The number of sub-flows you will add is the number of Excel worksheets that you want to read from.

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

1. In each sub-flow, add an Excel Reader step. Change the configuration in each Excel reader step by inputting the Worksheet number as highlighted in the below image. eg. The 1st sub-flow will reference worksheet 0. The 2nd sub-flow will reference worksheet 1. The 3rd sub-flow will reference worksheet 2.

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