How to import Opponents->Sumaries exported CSV into Excel?

[wilkas]

I want to import Opponents->Sumaries exported CSV file into Excel to make some sortings. How do I do that? Choosing Data -> Import external data -> Import data in Excel imports data thats not possible to sort.

[Patvs]

Are you using HM1 or HM2?

HM2: Opponents->Sumaries--> rightclick anywhere in the statistics---> save results as--> save the .csv file.
Open te .csv file in Excel.

In Excel select a colum, and Excel has a "sort and filter" option.

[wilkas]

Are you using HM1 or HM2?

HM2: Opponents->Sumaries--> rightclick anywhere in the statistics---> save results as--> save the .csv file.
Open te .csv file in Excel.

In Excel select a colum, and Excel has a "sort and filter" option.

Have exported Report.csv. Opened in Excel and thats what I see:

import.jpg

Cant sort these. Also tried to select column and choose Data->Text To Columns. Though data moves into correct columns, but data headers stay in single column.

[Patvs]

I can't duplicate your issue.

In my Excel:

http://imageshack.us/photo/my-images/215/captggure.jpg

I can sort by every column and the info is nicely sorted.

[wilkas]

I can't duplicate your issue.

Also tried to open in other PC with newer Excel, same thing. Can you try and open file I got exported? Here is the link: http://www.freefilehosting.net/report_28

[netsrak]

Please don't use the Excel -> file open dialogue to open this file.
Use Data -> External Data -> import instead (i hope this is correct, translated it back from my german Excel installation. Its the left button in the 5th ribbon "data").