How to import data in SPSS from excel file (data analysis part-3)

Spread the love

Spss is very easy to use because we can import any types of data set in spss. We can import data set in spss from excel, stata, R, sas etc. data analytics software.

 
Import Data in spss from Excel

Open spss go to “Menu Bar” and select-
“File”“Open”“Data”
import data in spss
Open new data set



Now there open a new box named “open data” and we have go to the “Files of type”  and select as “Excel(*.xls,*.xlsx,*.xlsm)”  


import data
selecting excel data set




Then select your target Excel file and click “open”  and there open a new box named “opening excel data source”, now we have to click on “continue”,


import data from excel
Opening excel data source




And finally our excel file is imported in spss,

import data in spss
Imported data set

The above data set is impoted from spss. First row of excel spreadsheet indicate the variables name which are automatically ditected by spss. The rest rows of excel sheet represents the data or observations. Spss is very simple data analytics software to manage, clean and analysis of data.




How to analyze data using SPSS (for beginners)-part 1
How to analyze data using SPSS (part-2), how to input data in SPSS
How to analyze data using SPSS (part-3), how to import data in SPSS from excel file
How to analyze data using SPSS (part-4), how to sort data in SPSS
How to analyze data using SPSS ( part-5) how to merge file in SPSS?
How to analyze data using SPSS ( part-6), how to merge file in SPSS
How to analyze data using SPSS (part-7), Finding missing values, Replacing missing values, Coding missing values in SPSS
How to analyze data using SPSS (part-8), variable transformation, Recoding variables in spssUnivariate Analysis (data analysis using spss part-9)
Bivariate analysis| How to analyze data using spss (part-10)
Normality check| how to analyze data using spss (part-11)

Leave a Reply

Your email address will not be published. Required fields are marked *