Importing Data From SPSS To Excel - PiratePanel



Importing Data To SPSS From Excel

[pic]

On the command bar in the SPSS Data Editor, click File, Open, Data.

[pic]

In the Open File window, select “Excel (*.xls)” in the “Files of type” box and then navigate your way to the folder where the Excel file is located. Select the file you wish to bring into SPSS and click Open.

[pic]

Check or uncheck the “Read variable names from the first row of data” box, as appropriate, and click OK.

[pic]

That is all there is to it.

[pic]

You may want to go to the variable view and fiddle with some of the settings there. You probably should save the file as an SPSS (*.sav) file.

Back to Karl’s SPSS Lessons Page

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download