Statistics Package for the Social Science (SPSS)
Importing tab-delimited data
In SPSSWIN click on FILE ⇒ OPEN ⇒ DATA. Look in the appropriate location for the text file. Then select “Text” from “Files of type”: Click on the file name and then click on “Open.” You will see the Text Import Wizard – step 1 of 6 dialog box.
You will now have an SPSS data file containing the former tab-delimited data. You simply need to add variable and value labels and define missing values.
Exporting Data to Excel
click on FILE ⇒ SAVE AS. Click on the File Name for the file to be exported. For the “Save as Type” select from the pull-down menu Excel (*.xls). You will notice the checkbox for “write variable names to spreadsheet.” Leave this checked as you will want the variable names to be in the first row of each column in the Excel spreadsheet. Finally, click on Save.