I would like to ask when you have exported stats or info from the game by the "Export to CSV" option then are there any particular pieces of software i should use to open those files as Excel seems to reduce everything to Subject ID numbers than actual player information. I must admit my Microsoft Excel subscription has expired so when the document opens it tells me that some functions of the software are not available.

Pretty much excel or you can try importing into google sheets. It's a pretty standard csv format so any program that can read that should work.