My Account:

Username:
Password:

Importing Excel Databases Into SPSS

To import an Excel file into SPSS, use the following steps:

  1. Open SPSS.

  2. Click on File on the menu bar. Select Open Database and then New Query.

    Importing Excel Databases Into SPSS - File - Open Database - New Query Screen Shot

  3. This will open the SPSS Database Wizard. Select Excel Files from the selection window and click on Next.

    Importing Excel Databases Into SPSS - Database Wizardd - Welcome to the Database Wizard!  Screen Shot

  4. In the ODBC Driver Login window, click on the Browse button.

    Importing Excel Databases Into SPSS - ODBC Driver Login - Browse Screen Shot

  5. Find the appropriate database file and click on the Open button.

    Importing Excel Databases Into SPSS - Open File - Look in - testfolder database Screen Shot

  6. Click OK to the ODBC Driver Login window.

  7. In the Select Data window, click and drag the appropriate tables from the Available Tables box to the Retrieve Fields In This Order box.

    Importing Excel Databases Into SPSS - Database Wizard - Step 2 of 6 - Select Data  Screen Shot

    Click Next once all the tables are selected and in the appropriate order.

  8. This will bring you to the Limit Retrieved Cases window, where you can assign certain conditions to table variables. Fields and functions can be added to an expression by dragging and dropping into an expression cell.

    Importing Excel Databases Into SPSS - Database Wizard - Step 4 of 6 - Limit Retrieved Cases Screen Shot

    Click on Next once you complete this window.

  9. This will bring you to the Define Variables window, where you can name the variables in the new SPSS file. Otherwise, SPSS will use the default names of the variables.

    Importing Excel Databases Into SPSS - Database Wizard - Step 5 of 6 - Define Variables Screen Shot

    Click Next once you complete this window.

  10. This will bring you to the SQL Query window, where you edit the SQL query string in the editor window.

    Importing Excel Databases Into SPSS - Database Wizard - Step 6 of 6 - Results Screen Shot

    Click Finish once you complete this window. The Excel file is now open in SPSS.