#IMPORT DATA FROM EXCEL TO EXCEL ON MAC HOW TO#

This is how the latest version of SPSS assigns a data type to your variables. Mainly these are self-explanatory, but it is probably worth explaining the вЂњPercentage of values that determine data typeвЂќ option. This dialog box offers a number of options. Open the file, and youвЂ™ll get the Read Excel File dialog box. Then navigate to the folder that contains your Excel file, and youвЂ™ll see your Excel file pop up (see 2 above). In the Files of type box, you need to select Excel (see 1 above, though obviously things will look slightly different if youвЂ™re using a Mac). Once you click Data, the Open Data box will appear. To start, click File -> Open -> Data (as below). WeвЂ™re going to use a method that allows backward compatibility with older versions of SPSS. There are a number of different ways to import data into SPSS. Once you have got your worksheet straight, you can open up SPSS. For example, if you had coded one of the Frisbee Throwing Distance items as вЂњ50mвЂќ rather than just вЂњ50вЂќ, this would be a good time to make a correction. Our worksheet satisfies both these requirements.

You can see in our example that we have 5 columns of data.Д«efore you begin the process of importing your data into SPSS, you need to ensure that your variable names are in the first row of the worksheet, and that there is no gap between the first and second rows.

Open the Excel spreadsheet from which you wish to import data.

#IMPORT DATA FROM EXCEL TO EXCEL ON MAC HOW TO#

This tutorial explains how to import data from Excel into the SPSS statistics package.

Import data from excel to excel on mac