Welcome to the forum.
You would want to do the following steps in the test case:
1. Test Request
2. Groovy Script
Once you get the response, you can do the stuff using groovy script and not really required properties step. For this, you need to access the response of previous step in the groovy script. And navigate thru values using getNodeValue of given element's xpath. For this you can search for Soapui tips where it has examples.
Also you do not have to manually copy the output to excel. You may be able to do it using Apache POI. You can google for it and it has good samples as well.