# Data driven test case

**URL:** <https://forum.katalon.com/t/data-driven-test-case/11708>\
**Category:** Web Testing\
**Tags:** katalon-recorder\
**Created:** [June 25, 2018, 3:09pm UTC](https://forum.katalon.com/t/data-driven-test-case/11708 "2018-06-25T15:09:59Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ashwani](https://avatars.discourse-cdn.com/v4/letter/a/ce7236/32.png) [@ashwani](https://forum.katalon.com/u/ashwani)\
**Post date:** [June 25, 2018, 3:09pm UTC](https://forum.katalon.com/t/data-driven-test-case/11708/1 "2018-06-25T15:09:59Z")

</div>

I want to execute multiple data from csv/excel file how can i do it using katalon recorder only , for example submitting form of personal details of 20 persons in a website

---

<div class="post-metadata">

**Author:** ![Cybes](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/cybes/32/20464_2.png) [@Cybes](https://forum.katalon.com/u/Cybes)\
**Post date:** [July 4, 2018, 9:29am UTC](https://forum.katalon.com/t/data-driven-test-case/11708/2 "2018-07-04T09:29:54Z")

</div>

Hi Ashwani

You can do this if you store the details of the 20 people (and all the details related to those 20 people) in a CSV file.

e.g. CSV file called “UserDetails.csv” with the contents:

“Number,FirstName,LastName,Age,Postcode,Email  
[1,Bob,Geldof,61,20004,test1@email.com](mailto:1,Bob,Geldof,61,20004,test1@email.com)  
[2,Jane,Katies,39,20003,test2@email.com](mailto:2,Jane,Katies,39,20003,test2@email.com)  
[3,Grant,Kemp,24,20002,test3@email.com](mailto:3,Grant,Kemp,24,20002,test3@email.com)  
[4,Richard,Hampsted,18,20001,test4@email.com](mailto:4,Richard,Hampsted,18,20001,test4@email.com)”  
…etc… (making sure that you put in the details for all 20 people here)

You can then load this CSV file into Katalon Recorder via the “Data Driven” tab in there

In Katalon Recorder you can then create a script like so

loadVars | UserDetails.csv |  
open | [https://www.websiteaddress.com/form.html](https://www.websiteaddress.com/form.html) |  
type | name=firstname | $FirstName  
type | name=lastname | $LastName  
select | id=age-dropdown | label=$Age  
type | name=age | $Age  
type | name=postcode | $Postcode  
type | name=emailaddress | $Email  
clickAndWait | xpath=(//button[@type=‘submit’])[1] |  
endLoadVars | |

This will then run the steps between loadVars and endLoadVars and keep looping through these steps till it reaches the end of the file.

Hope that this helps!