# Search and get Value from Web Formular

**URL:** <https://forum.katalon.com/t/search-and-get-value-from-web-formular/84635>\
**Category:** Web Testing\
**Tags:** katalon-recorder, web-testing\
**Created:** [February 23, 2023, 8:02am UTC](https://forum.katalon.com/t/search-and-get-value-from-web-formular/84635 "2023-02-23T08:02:35Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![nas](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/nas/32/22419_2.png) [@nas](https://forum.katalon.com/u/nas)\
**Post date:** [February 23, 2023, 8:02am UTC](https://forum.katalon.com/t/search-and-get-value-from-web-formular/84635/1 "2023-02-23T08:02:36Z")

</div>

Hello everyone,  
I unfortunately can not program and use the KatalonRecorder for testing. However, I need your support here and there.  
I have managed to have data read from an excel spreadsheet and written to an online form and submit the form. Now I have to read a value from this excel table, enter it in the form and copy the result back into the excel table i.e. into the CSV file in a certain column in the corresponding row. Example:  
File number | Case\_ID  
14323  
66563  
88787

and so on. The file number is available, the corresponding case ID is to be determined on the page using the search button and then copied into the corresponding line. Can you help me please?

Thanks

Adem Akyüz

---

<div class="post-metadata">

**Author:** ![guy.mason](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/guy.mason/32/20660_2.png) [@guy.mason](https://forum.katalon.com/u/guy.mason)\
**Post date:** [February 23, 2023, 3:54pm UTC](https://forum.katalon.com/t/search-and-get-value-from-web-formular/84635/2 "2023-02-23T15:54:44Z")

</div>

Katalon Recorder includes the following script which shows you how to save data into a CSV file, but it won’t let you save it to a specific row or column, it’ll just add it to the end of the file

 ![image](https://europe1.discourse-cdn.com/katalon/original/3X/a/6/a6ee148a2cd7cee2770c57f9574358f3fd12fc59.png)

To load the data it from the CSV file you have more controls by comparison.

“loadVars” allows you to open the CSV file and extract data (by row names) one line at a time.

“storeCsv” allows you to open the CSV file and fetch data from a specific line and specific row, by comparison (which you can then use with while / endwhile loops, to run through things).

If you search on the forum, or just use the built-in ‘Reference’ tab in Katalon Recorder, it will show you how to use these commands, too.