# Data Driven testing from Excel

**URL:** <https://forum.katalon.com/t/data-driven-testing-from-excel/32046>\
**Category:** Web Testing\
**Tags:** katalon-studio\
**Created:** [August 23, 2019, 12:22pm UTC](https://forum.katalon.com/t/data-driven-testing-from-excel/32046 "2019-08-23T12:22:22Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![veeren17](https://avatars.discourse-cdn.com/v4/letter/v/439d5e/32.png) [@veeren17](https://forum.katalon.com/u/veeren17)\
**Post date:** [August 23, 2019, 12:22pm UTC](https://forum.katalon.com/t/data-driven-testing-from-excel/32046/1 "2019-08-23T12:22:22Z")

</div>

Test data in excel with multiple sheets has been created and variable mapping. Select Test Suite ,Select Test Data from Test data selection with either Add before or Add Later , then under Variable Binding section for the first time we set type,Test data and Value. This feature works great if we have only sheet in excel test data. If we have to switch from sheet 1 to sheet 2 , variable binding is not retaining. I have 10 rows in my sheet. For each run i have to set type, Test data selection ,value for all 10 rows recommendation. Please recommend any other alternative to retain variable binding after selecting corresponding test data.

 ![Switched%20to%20different%20sheet%20and%20came%20back%20to%20same%20sheet%20-%20Variable%20binding%20cleared-%20Forced%20user%20to%20set%20again](https://europe1.discourse-cdn.com/katalon/original/2X/4/4e15aac2970056339b5b66c6a2f75519550183bd.png)

---

<div class="post-metadata">

**Author:** ![HeleneB](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/heleneb/32/2775_2.png) [@HeleneB](https://forum.katalon.com/u/HeleneB)\
**Post date:** [August 23, 2019, 12:29pm UTC](https://forum.katalon.com/t/data-driven-testing-from-excel/32046/2 "2019-08-23T12:29:39Z")

</div>

Hi,  
Rename your column on testData with the name of the variables. Then you only have to click on “Map All”

---

<div class="post-metadata">

**Author:** ![veeren17](https://avatars.discourse-cdn.com/v4/letter/v/439d5e/32.png) [@veeren17](https://forum.katalon.com/u/veeren17)\
**Post date:** [August 23, 2019, 5:04pm UTC](https://forum.katalon.com/t/data-driven-testing-from-excel/32046/3 "2019-08-23T17:04:06Z")

</div>

thank you for your reply.It worked.

---

<div class="post-metadata">

**Author:** ![bhargavia](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/bhargavia/32/16103_2.png) [@bhargavia](https://forum.katalon.com/u/bhargavia)\
**Post date:** [June 19, 2020, 9:38am UTC](https://forum.katalon.com/t/data-driven-testing-from-excel/32046/4 "2020-06-19T09:38:58Z")

</div>

Hi,  
Can’t we copy the csv data files into katalon Data Files folder.