By whatever means you prefer, create a list of member names - writing the list to a disk file rather than the screen or a sysout. Edit the file to discard any unneeded info.
FTP the file from the mainframe to your desktop system. Import the file into excel and then you have the members in a spreadsheet.
I don't get it. How do I discard the unneeded info. Do you mean copy the entire PDS into a flat file? But that flat file will have all rows from all the members... I just need member names from the PDS.