# Import Test Data into Web Application Testing **URL:** \ **Category:** Miscellaneous\ **Tags:** katalon-studio\ **Created:** [June 24, 2019, 9:10pm UTC](https://forum.katalon.com/t/import-test-data-into-web-application-testing/28499 "2019-06-24T21:10:48Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![prachuprasanna](https://avatars.discourse-cdn.com/v4/letter/p/a9a28c/32.png) [@prachuprasanna](https://forum.katalon.com/u/prachuprasanna)\ **Post date:** [June 24, 2019, 9:10pm UTC](https://forum.katalon.com/t/import-test-data-into-web-application-testing/28499/1 "2019-06-24T21:10:48Z")
I have installed Katalon in my Mac. I created test case which will do the testing and it works fine. Now I have a Excel file which contains the test data. I have imported the excel file as Test Data. I have some button clicks which works fine with the xpath. `WebUI.click(findTestObject('Object Repository/Test/TestNavigator/span_Not at all'))` In the Excel file, I have the value for the button click, to select specific option. I’m trying to fetch the value from the excel file and pass it as input to the Click function. But it fails. How to resolve this issue? ---
**Author:** ![kazurayam](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/kazurayam/32/333_2.png) [@kazurayam](https://forum.katalon.com/u/kazurayam)\ **Post date:** [June 25, 2019, 1:46am UTC](https://forum.katalon.com/t/import-test-data-into-web-application-testing/28499/2 "2019-06-25T01:46:24Z")
> [@prachuprasanna](#): > > But it fails. OK. Have a look at this post [[TIP] How To Help Us Help You!](http://forum.katalon.com/t/tip-my-test-is-broken-nothing-works-please-help-me/12919) And let us see your code, and the log which shows how it failed. ---
**Author:** ![prachuprasanna](https://avatars.discourse-cdn.com/v4/letter/p/a9a28c/32.png) [@prachuprasanna](https://forum.katalon.com/u/prachuprasanna)\ **Post date:** [June 25, 2019, 9:43pm UTC](https://forum.katalon.com/t/import-test-data-into-web-application-testing/28499/3 "2019-06-25T21:43:55Z")
Im new to Katalon. I have recorded the complete flow, and worked on testing initially. I understood that, button click works using xpath. I need your help for the below activity. 1. The tool has multiple questions, with various radio buttons, check boxes. I have a test data in excel format, which has the exact answers to be captured for each question. I need your help to read the values for the button clicks, and pass the flow. ---
**Author:** ![kazurayam](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/kazurayam/32/333_2.png) [@kazurayam](https://forum.katalon.com/u/kazurayam)\ **Post date:** [June 26, 2019, 12:08am UTC](https://forum.katalon.com/t/import-test-data-into-web-application-testing/28499/4 "2019-06-26T00:08:03Z")
The following article would help you: > **[Data-driven testing approach with Katalon Studio](https://www.toolsqa.com/katalon-studio/data-driven-testing-approach-katalon-studio/)** > > Katalon Studio supports data-driven testing which allows users to define data sets and execute test scripts that use these data sets. ---
**Author:** ![prachuprasanna](https://avatars.discourse-cdn.com/v4/letter/p/a9a28c/32.png) [@prachuprasanna](https://forum.katalon.com/u/prachuprasanna)\ **Post date:** [June 26, 2019, 6:51am UTC](https://forum.katalon.com/t/import-test-data-into-web-application-testing/28499/5 "2019-06-26T06:51:37Z")
@kazurayam, Thank you. The above approach works well for selecting values from the drop down and text boxes. But clicking on the specific radio button option is not working. Can you please help me how to achieve it? Thanks in advance ---
**Author:** ![kazurayam](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/kazurayam/32/333_2.png) [@kazurayam](https://forum.katalon.com/u/kazurayam)\ **Post date:** [June 26, 2019, 6:58am UTC](https://forum.katalon.com/t/import-test-data-into-web-application-testing/28499/6 "2019-06-26T06:58:18Z")
Please have a look at the follwoing guideline: > [@\[TIP\] How To Help Us Help You!](http://forum.katalon.com/t/tip-my-test-is-broken-nothing-works-please-help-me/12919): > > My test is BROKEN! NOTHING WORKS! HELP ME! Relax. We get it. We really do. There are some pretty smart and clever people on this forum, but you must realize, they are not magicians or wizards or gods. They cannot see your code, they can’t see your errors and they don’t even know what your AUT is meant to do even though it might seem perfectly obvious to you. So please relax and follow the advice below, before you start writing your post. The advice below will tell you the exact information … ---
**Author:** ![albert.vu](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/albert.vu/32/20595_2.png) [@albert.vu](https://forum.katalon.com/u/albert.vu)\ **Post date:** [August 8, 2022, 7:43am UTC](https://forum.katalon.com/t/import-test-data-into-web-application-testing/28499/7 "2022-08-08T07:43:35Z")