Identity score matrix is not being saved in .xlsx format

[Syeda Wajeeha]

Hello, I am using SDT ver 1.2 right now. When I save my generated data's identity scores in 'Matrix' format then, according to manual it should give .xlsx excel layout. But it is being save din .txt format and I am unable to fix it. Can anyone how can I save it in .xlsx format or I just would have to edit it manualy because it would be time taking as my data set is more than 100.

[Brejnev Muhire]

Open a new excel window and import the matrix using data import tab. In excel there is an option to import data from text, chose that and set the delimiter to ",".

Your will need also to round the numbers in excel. I also this that if you change the file extension from .txt to .csv the matrix will open immediately in  excel. 

The steps to import data in excel are bellow: 

Microsoft Excel 2010

1. Open Microsoft Excel.
2. Click on the Data tab.
3. In the Get External Data group, click From Text.
4. Double-click the text file that you want to import in the Import Text File dialogue box.
5. Click Import. ...
6. Select Delimited and click Next.
7. Uncheck Tab and select Comma.
8. Click Next.