majestic bulk backlink .csv question

Hey, Ive been using majestics bulk backlink checker, and it exports to a zip file.
When I extract the zip file, I have a csv. But when I open the csv in excel, openoffice, googlesheets.

NONE of it is showing adequate data. It's just a jumbled mess, only the first column is filled in with some broken text.

Anyone else have this problem? Solutions?

Maybe you should sort the text in different columns first? Take a look at this tutorial if you don't know how to do it:
http://www.excel-easy.com/examples/text-to-columns.html