Saving json request in a excel format

I'd strongly urge you to use a Database not Excel for this.

In the Community edition, if you must use Excel then you will need to use Groovy, which is covered in this question/answer:  https://community.smartbear.com/t5/SoapUI-Open-Source/How-to-save-response-data-in-Excel-CSV-format-in-SOAP-UI-5-2-1/m-p/115816#M20008

Groovy provides the most flexibity approach for Excel or DB but requires that you use or learn some Groovy Programming.  Groovy is what makes SOAPUI such a powerful test tool and it is worth the effort.

If you use a DB then you do not need to learn programming and could use a JDBC step: see: https://www.soapui.org/resources/tutorials/tutorial-data-driven-testing.html

IF you have Pro, you can do this with Excel or DB and take a look at this tutorial 

https://www.soapui.org/docs/data-driven-tests/functional-tests.html

Hi durgapandey ,

For storing the request and response, you can use Text file instead of Excel which get created after each run.

and use those request and response whenever you need it later on in any request.

If you need more help do let me know.