# Is it possible to quickly change test data?

**URL:** <https://forum.katalon.com/t/is-it-possible-to-quickly-change-test-data/32561>\
**Category:** Web Testing\
**Tags:** katalon-studio\
**Created:** [September 4, 2019, 11:11am UTC](https://forum.katalon.com/t/is-it-possible-to-quickly-change-test-data/32561 "2019-09-04T11:11:25Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Funkey](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/funkey/32/8068_2.png) [@Funkey](https://forum.katalon.com/u/Funkey)\
**Post date:** [September 4, 2019, 11:11am UTC](https://forum.katalon.com/t/is-it-possible-to-quickly-change-test-data/32561/1 "2019-09-04T11:11:25Z")

</div>

Hey everyone !

I have recently been working on a test scenario with lots of input fields. The data for the input fields is done through data driven testing with an excel sheet.

Now the thing is whenever I want to change some fields for testing purposes I need to make a whole new excel sheet and change every single input field to that new excel sheet.

I have the feeling I am doing something very wrong here. Is there a fast way to edit this data?

Thanks in advance!

---

<div class="post-metadata">

**Author:** ![Eric\_Montou](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/eric_montou/32/915_2.png) [@Eric\_Montou](https://forum.katalon.com/u/Eric_Montou)\
**Post date:** [September 4, 2019, 2:50pm UTC](https://forum.katalon.com/t/is-it-possible-to-quickly-change-test-data/32561/2 "2019-09-04T14:50:41Z")

</div>

I have not personally used the plugin but I believe there is a way to read and write to excel files.

[https://store.katalon.com/product/34/Excel-Keywords](https://store.katalon.com/product/34/Excel-Keywords)

---

<div class="post-metadata">

**Author:** ![Dan\_Bown](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/dan_bown/32/20464_2.png) [@Dan\_Bown](https://forum.katalon.com/u/Dan_Bown)\
**Post date:** [September 4, 2019, 10:02pm UTC](https://forum.katalon.com/t/is-it-possible-to-quickly-change-test-data/32561/3 "2019-09-04T22:02:22Z")

</div>

Hi, the easiest way would be to copy/paste to your spreadsheet if possible? Then save the spreadsheet…  
The only reason to change scripts would be if the spreadsheet file name is different, or worksheet changes. If you can avoid that by copying to the existing file then all should be good.

---

<div class="post-metadata">

**Author:** ![Funkey](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/funkey/32/8068_2.png) [@Funkey](https://forum.katalon.com/u/Funkey)\
**Post date:** [September 5, 2019, 10:09am UTC](https://forum.katalon.com/t/is-it-possible-to-quickly-change-test-data/32561/4 "2019-09-05T10:09:26Z")

</div>

Thanks! I needed this!

---

<div class="post-metadata">

**Author:** ![jjunior](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/jjunior/32/6633_2.png) [@jjunior](https://forum.katalon.com/u/jjunior)\
**Post date:** [September 5, 2019, 12:32pm UTC](https://forum.katalon.com/t/is-it-possible-to-quickly-change-test-data/32561/5 "2019-09-05T12:32:35Z")

</div>

Hello Funkey,

If you want to change the values during the test, I think that this topic will help you:

> [@(TEST DATA) Define specific Excel Sheets to get Excel Values](http://forum.katalon.com/t/test-data-define-specific-excel-sheets-to-get-excel-values/12290):
>
> Hi there, I’m going to share something that might help you when it comes to automation which involves excel file as your test data and defining the “SHEETS” you prefer to make your test data even more dynamic. We have a class named ExcelData but it doesn’t allow us to define what sheet the automation will penetrate. See this link for the ExcelData class for your reference: [Index (Katalon Studio API Specification)](https://api-docs.katalon.com/index.html?overview-summary.html) Meaning the ExcelData is only good for one sheet which is the default sheet. And…