This is a tough one, so I'll give you what I think is your best strategy.
First, the primary problem your facing is that you are using a Comma Delimited file and your text values have commas in them, not to mention you have a lot of special characters on the dollar figures, like "$". Commas are okay for numeric values. Anaplan is parsing your file thinking that each column is separated by a column. So, you guessed it, you have to use a different delimiter, or you have to remove the commas in the text values and the special characters on your numeric values.
Second, I would encourage you to reformat the spreadsheet. Remove column 1, for example. And remove all the rows that are summary values or empty. Also remove any other columns you don't need. If this is a spreadsheet that is a template and you'll have to do this often, I would recommend creating a macro that can reformat all future spreadsheets. Just turn the macro recorder on before you format the sheet.
Lastly, Add a unique identify in the first column that identifies what makes that row unique. You don't need the time hierarchy in that since you can dimensionalize time. Create a list from that first column, and a system module that contains the properties.