Hello ,
Depending upon your functional needs and resource availability you can take one of the below mentioned approaches to solve the issue
1. create a macro in excel and XOG data directly from excel to CA PPM.
2. Convert the xls to csv, write a gel to read csv data and XOG into clarity
3. Create a custom JAVA code using the POI libraries to perform the complete activity of reading, sanitizing, transforming and loading the data to CA PPM.
If you need help in terms of macros, java code or gel script then please let me know I can email you some material for reference.
Hope this helps.