If you have a look at the import syntax, you can see that it’s doing exactly what we told it to do. This will paste the syntax to import the data – it hasn’t imported the data yet!

In that same dialogue box, select the “Data” worksheet to import (that’s where the data are stored).

A new dialogue box will appear – you should tick the box “Read variable names from first row of data”, as the H&S excel file has variable names in the first row.

Click “Paste”, to paste the syntax to your syntax file.

Navigate to and select the HLTH1025_2016.xlsx file that you saved to your working directory.

Click the “Files of type:” drop down box and select Excel (.xls.

When you’re happy with the Excel file, Close it.

For instance, how many records are there? How many variables? What format are the data for each variable? If the data are numeric, make sure the format is set to “Number”.

Have a look at how the Data worksheet is set up.

Open the Excel file you downloaded earlier – HLTH1025_2016.xlsx.

Save all your SPSS files, and Close SPSS.

Also, make sure you take note of a few key data elements in your original data, such as the total number of respondents or records, and the number of variables. My best advice would be to make sure that you have set up your data well in Excel – this can make the importing process much easier. We are going to have a go at importing a data file from Excel to SPSS, so that we can see firsthand some of the issues that may come up. This can be relatively straightforward, but there are a few things to look out for in the conversion process. If you want to work with your data in SPSS, however, you’ll need to import the data from Excel to SPSS. One of the more common formats for entering and storing raw data is Microsoft Excel.

Spss code sheet