# How to select the random data from excel and use that particular data

**URL:** <https://forum.katalon.com/t/how-to-select-the-random-data-from-excel-and-use-that-particular-data/32934>\
**Category:** Web Testing\
**Tags:** web-testing, katalon-studio\
**Created:** [September 11, 2019, 11:49am UTC](https://forum.katalon.com/t/how-to-select-the-random-data-from-excel-and-use-that-particular-data/32934 "2019-09-11T11:49:07Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![priyasharmaa1819.ps](https://avatars.discourse-cdn.com/v4/letter/p/ecd19e/32.png) [@priyasharmaa1819.ps](https://forum.katalon.com/u/priyasharmaa1819.ps)\
**Post date:** [September 11, 2019, 11:49am UTC](https://forum.katalon.com/t/how-to-select-the-random-data-from-excel-and-use-that-particular-data/32934/1 "2019-09-11T11:49:07Z")

</div>

I am not able to select the random data(url) from excel and need to open that url on the next page.

---

<div class="post-metadata">

**Author:** ![Timo\_Kuisma](https://avatars.discourse-cdn.com/v4/letter/t/8baadc/32.png) [@Timo\_Kuisma](https://forum.katalon.com/u/Timo_Kuisma)\
**Post date:** [September 11, 2019, 3:51pm UTC](https://forum.katalon.com/t/how-to-select-the-random-data-from-excel-and-use-that-particular-data/32934/2 "2019-09-11T15:51:34Z")

</div>

hi,

you will need to do custom keyword where to read one random value from excel sheet  
needed java programming skills

---

<div class="post-metadata">

**Author:** ![manpreet.mukkar](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/manpreet.mukkar/32/16103_2.png) [@manpreet.mukkar](https://forum.katalon.com/u/manpreet.mukkar)\
**Post date:** [September 11, 2019, 4:07pm UTC](https://forum.katalon.com/t/how-to-select-the-random-data-from-excel-and-use-that-particular-data/32934/3 "2019-09-11T16:07:02Z")

</div>

@priyasharmaa1819.ps Another way if you don’t want to do some custom programming is to use a workaround.

In your excel sheet you need to create a cell that pulls a random value from the set of data “urls in your case”. The call that excel in your test script.

---

<div class="post-metadata">

**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:39am UTC](https://forum.katalon.com/t/how-to-select-the-random-data-from-excel-and-use-that-particular-data/32934/4 "2022-08-08T07:39:54Z")

</div>

Archived on August 8, 2022, 7:39am UTC