I have an excel spreadsheet of projects that I need to import into Clarity? what is the best way of doing that?
You have to convert it into an XML file that can be XOGged in. If you search around there has been a lot of discussion about this in the past, and there are tools out there to assist.
The thread here is probably a good starting point
How to use Microsoft Excel to Map Data into XOG Files, then Update Directly to CA PPM