Export a viw as csv

Hi,
I am trying to export a view as csv via APOP, but my view is coming weird in Target Sheet. It is just showing Row Headers and that too with dimension name instead of dimension items. When i download that as csv it shows correct but while exporting it to another tool it is showing weird results. 

Please someone explain me the reason and what am i missing?

Thanks