CSP_import_SPSS%20_EN.pdf

Type: Document | Status: ready
← All sources

Official Statistics Portal | Research and study data

1

Importing .CSV files into SPSS software

The Official Statistics Portal promotes open formats therefore all research datasets are available in CSV files. This is a short tutorial on how to import CSV files into SPSS.

  1. Open SPSS and select ‘File → Open → Data…

  2. Click on ‘Files of type’ and select Text (*.txt, *.dat, *.csv)’.

Official Statistics Portal | Research and study data

2

  1. Select CSV file.

  2. In the Step 1, select ‘No’ for ‘Does your text file match a predefined format?’

Official Statistics Portal | Research and study data

3

  1. In the Step 2, select ‘Delimited’ for ‘How are your variables arranged?’ and ‘Yes’ for ‘Are variable names included at the top of your file?’.

  2. In the Step 3: select ‘2’ for ‘The first case of data begins on which line number?’, ‘Each line represents a case’ for ‘How are your cases represented?’, and ‘All of the cases’ for ‘How many cases do you want to import?’.

Official Statistics Portal | Research and study data

4

  1. In the Step 4, select ‘Semicolon’ (or another option that corresponds the data structure) for ‘Which delimiters appear between variables?’ and ‘Double quote’ for ‘What is the text qualifier?’.

  2. In the Step 5, see the file and find variables needing 0 at the beginning, e.g., for the Classification of Administrative Territories and Territorial Units select the ‘Data format’ to be ‘String’.

Official Statistics Portal | Research and study data

5

  1. In the Step 6, select all that applies to your specific needs and click on ‘Finish’.