View Full Version : How to import Opponents->Sumaries exported CSV into Excel?
wilkas
02-09-2012, 05:44 AM
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
02-11-2012, 12:35 AM
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
02-13-2012, 11:49 AM
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:
50571
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
02-13-2012, 11:18 PM
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
02-14-2012, 05:46 AM
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
02-14-2012, 09:53 AM
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").
Powered by vBulletin® Version 4.2.3 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.