Comma-separated values (CSV)

Comma separated-values (CSV) is a data format that separates data fields using one or more specific characters (e.g. comma, semicolon or tab). Data records are divided by line breaks, i.e. each data record starts a new line. CSV files usually use the file extension *.csv.

ESCO data in CSV files

The download section of the ESCO portal allows downloading partial ESCO datasets in CSV format. This file format can be used to import data for further use in various software products, e.g. spreadsheet software or database systems. Currently, the following data subsets can be downloaded in CSV format:

The CSV files with occupations and skills/competences concepts are mono-lingual. Any ESCO language can be selected before downloading the file.

Files with relationships contain the Uniform Resource Identifier (URI) and the preferred term (PT) in English of the concepts that are related to each other. If applicable, the files also include a note with additional information about the relationship.

Importing ESCO CSV files in Microsoft Excel

CSV files can be imported into Microsoft Excel. In order to import a CSV file into a new Microsoft Excel 2010 spreadsheet, select the option "From text" from the "Get external data" section of the "Data" tab. Select the ESCO CSV file you downloaded and click on "Import". The import wizard opens.

Open wizard

In step 1, select the options "Delimited" for "Original data type" (default), "1" for the first row (default) and "65001 : Unicode (UTF-8)" for "File origin" (not default). Click on "Next".

Step 1

In step 2, select "Semicolon" as separating character (deselect "Tab"). Click on "Next".

Step 2

In step 3, you can select the data format of each data field. Go through the data fields by clicking on "General" on top of each field. Change all fields to "Text". Click on "Finish" and afterwards on "OK".

Step 3

Reading an ESCO CSV file

ESCO CSV files with occupation data are structured in the following way:

  • Concept URI: URI of the occupation concept
  • Concept type: "OG" stands for occupation group, "OC" stands for occupation
  • ISCO code: ISCO-08 code of occupation groups
  • Concept PT: Preferred term of the concept in the selected language
  • Definition: Definition of the concept (if available)
  • Parent Concept URI: URI of the parent concept
  • Parent ISCO code: ISCO-08 code of the parent concept

ESCO CSV files with skills/competence data are structured in the following way:

  • Concept URI: URI of the skill/competence concept
  • Concept type: "SK" stands for skill/competence, "SG" stands for skill/competence group
  • Concept PT: Preferred term of the concept in the selected language
  • Definition: Definition of the concept (if available)

Links

Wikipedia: Comma-separated values

Microsoft: Import or export text (.txt or .csv) files