I am likely going to be given an Excel file that has a list of projects and tasks I'll need to create. Is there a way to use this Excel file as an import mechanism?
You supplement the data you get with the required data fro XOGing and modify what you get to be in the correct format for XOGing.
Then you convert the spreadsheet into an XML file for XOGing.
You can do that manually by just writingthe XML attributes and tags or using formulas or VBA for that.
Some of the XML editors can do that as well.
ITROI has a short video how to do that with Excel only.
How to use Microsoft Excel to Map Data into XOG Files, then Update Directly to CA PPM.
They also have commercial Excel integration solution if you want to to that on a continuous basis.
The XOG query bridge is a user friendly UI to replace the command line XOG client.
The XOG query bridge is a cool tool. We have it here.
Retrieving data ...