Data from Open Site Explorer to Excel

[PedroM]

Hello,

Im having a problem with the data I pull off from Open Site Explorer. Everytime I download a report in CSV, when I open it in Excel 2007, all the information is like this:

http://i.imgur.com/rwMxO.png

What can I do to extract the information exactly as it appears in the Open Site Explorer with all the fields in the right place?

Tks guys,

Regards,

Pedro Pereira

[](<a href=)" target="_blank">a> rwMxO.png

[PracticeFusion]

My hunch is that your your version of Excel has a semicolon set as the "list separator" rather than the comma. With that being the case, when you try to open the file, Excel doesn't quite know where to separate things.

To help out, I found this great guide for you that provides a few different ways for you to solve your issue.

http://www.paessler.com/knowledgebase/en/topic/2293-i-have-trouble-opening-csv-files-with-microsoft-excel-is-there-a-quick-way-to-fix-this

[SanketPatel]

Open site Explorer export directed as a graph data in CSV Format.Each and every connections linking as root domain of the link.Excel to access the link of the URL Metrics APIs so the most perhaps style approach selecting scope and filters for OSE for Excel sorts.

[PedroM]

Thanks Phil, it solved my problem.

I change the regional setting and boom, problem solved!

Cheers!