Importing Excel file into SPSS

April 10th, 2006 andris

This weekend we got a question from Zakya, who desperately needs information on how to import Excel data into SPSS.

Actually, importing from SPSS is not that hard at all. But before you import, there are some steps to take to make importing more easy:

- Close the Excel file (otherwise SPSS will give an error message)
- Make a header row in Excel with column names (keep them brief and descriptive)
- Do not mix up numbers and text in the same column

In SPSS, select Open -> File from the menu. In the Open file dialog, select Excel file as file type. Browse to the right directory and select the Excel file. Click Open. After this, you will get a new dialog (Hurray!) “Opening Excel Data Source”. If you have made a header row with column names, check the box “Read variable names from the first row of data”. If you do not have other irrelevant data in your Excel file, just click OK. Otherwise select the right worksheet and range, and click OK. If everything went allright, you now have your data in SPSS. Now you can start adjusting the Variables to the right types etc.

Entry Filed under: 1. Getting data into SPSS,Questions and answers

3 Comments

  • 1. SPSSlog.com » Findi&hellip  |  April 11th, 2006 at 12:12 pm

    [...] Zakya asked us another question. After getting his Excel data into SPSS, he wanted to find possible correlations between a couple of variables. Zakya, please find below an explanation on finding correlations with the Chi-square test. [...]

  • 2. ramesh  |  May 29th, 2008 at 4:50 am

    Hai

    Pls tell me in excel file how to import in spss format.

    & DBF file how to import in spss format……..

  • 3. carlos  |  July 3rd, 2008 at 9:48 am

    does anybody know if spss 16 when import a file from excel it can change rows in columns?
    thanks


Calendar

April 2006
M T W T F S S
« Mar   May »
 12
3456789
10111213141516
17181920212223
24252627282930

Most Recent Posts