How to Import Data into SPSS

  • 24/7 Support
  • 100+ Subjects
  • 500+ PhD statisticians
How to Import Data into SPSS

You must be aware that importing an SPSS file (file with extension, .sav) is just straightforward. Here, you only need to double-click on the “.sav” file, and will automatically open in SPSS (provided you’ve SPSS Statistics installed on your machine). However, the challenge now comes whenever you want to import data such as Excel data, Text Data, or CSV data into SPSS. In this case, you need to instruct SPSS to read the file and save it in the SPSS file format (.sav). So, in this article, we uncover how to import data into SPSS. In particular, the article covers how to import Excel data (.xls), Text data (.txt), and Comma Delimited Values data (.csv) into SPSS.

How to Import Excel Data into SPSS

To import Excel data into SPSS, please follow the following procedure:

1. With SPSS Open, Click File from the Main Menu

Our custom responsive image

2. Next, Click Import Data, then Select EXCEL

Our custom responsive image

3. Locate the Excel File on Your Computer and Click on It

My file is named task 1.xlsx and is located in the downloads folder. Once you click on it, you’ll get the following screen;

Our custom responsive image

4. Click Open and then OK to Open the Excel File

Our custom responsive image

5. Once You’ve Clicked the OK button, the Excel Data Will be Opened in SPSS

Our custom responsive image

How to Import Text Data (.TXT) into SPSS

Now, suppose that we have the same data but now saved as text data (Task 1. txt). To import this data into SPSS, follow these 5 simple steps:

1. With SPSS Open, Click FILE From the Main Menu

Our custom responsive image

2. Click IMPORT DATA and Select TEXT DATA

Our custom responsive image

3. Locate the Data from the Computer and Click on It

Our custom responsive image

4. Click Open to See a Preview

This will allow you to confirm whether you’re working on the correct data.

Our custom responsive image

5. Click NEXT and Ensure You Choose the Correct Decimal Symbol

In my case, my data do not contain decimals, so I choose the default settings.

Our custom responsive image

6. Click NEXT and Retain the Default Settings

Our custom responsive image

7. Click NEXT and Specify the Correct Delimiters.

In My case, the delimiter was a tab. So, you should check your .txt file to ensure that you’ve selected the right delimiter. You can play with the various delimitors to match how your data is organized.

Our custom responsive image

8. Click Next, and then Finish to Complete Importing the .TXT Data into SPSS

Our custom responsive image

Still struggling with your data analysis project? Get Started Now & Unlock 15% Off Your First Project