How to Import an Excel Data Source Into SPSS

Save

IBM's SPSS Statistics program offers two methods for importing data from Excel files: as an ODCB database, or as a data source. Importing an Excel file as a data source is the simplest option, which is useful for novice users. For database imports, you'll need to be more familiar with the SPSS program (see Resources).

Things You'll Need

  • SPSS Statistics
  • Open SPSS. If you are prompted with a window that asks "What would you like to do?," choose the second option, "Type in data."

  • Select the File menu, go down to "Open," then click "Data."

  • In the dropdown box near the bottom of this window, select the type of file (e.g., "Excel" as .xls, .xlsx, or *.xlsm") and navigate to the Excel file you'd like to import. Click "Open."

  • The "Opening Excel Data Source" dialog should appear, allowing you to select an Excel worksheet to import. Check the "Read variable names from the first row of data" box only if the Excel worksheet you selected has variable names in the first row. When you are satisfied with your selection, click "OK."

References

Promoted By Zergnet

Comments

Resources

You May Also Like

Related Searches

Check It Out

Can You Take Advantage Of Student Loan Forgiveness?

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!