Hello Jaywardhan,
If I have got your requirement right, you want to see the values of your opportunities in excel. This can be achieved OOB. Kindly add all the fields for which you want to see this in your view. Once you have added, export to excel and select Dynamic Worksheet
while exporting.

The exported file will be saved as a XML file. Open with excel and you will have all the details of the opportunity. Every time data in those fields will be modified, the values in the excel will change accordingly.
I hope it helps!
Regards, Abhishek Bakshi If you find this post helpful then please Vote as Helpful and Mark As Answer. Check my blog on https://mydynamicscrmblog.wordpress.com/