---
title: "codes and labels from collect to .csv file"
url: "https://openforis.support/questions/869/codes-and-labels-from-collect-to-csv-file"
tags: ["collect"]
status: "answered"
score: 0
answer_count: 5
asked: "2016-11-08T11:45:28"
last_activity: "2016-11-14T10:39:09"
source: "Open Foris Support - Q&A Forum"
license: "Copyright Open Foris, 2026. Some rights reserved under creative commons license."
---

# codes and labels from collect to .csv file

Asked by migonser on 2016-11-08

Hi, 
I have a survey with a lot of codes. When I export it to a .csv file I want to export not only the codes but the labels. Is it possible?
Thanks


## Answer (score 0, by Open Foris on 2016-11-08)

Link: https://openforis.support/questions/869/codes-and-labels-from-collect-to-csv-file/870

Hi Migonser,

If you use the export button in the code list editor this should alreadt create a CSV file with the values, labels and descriptions of the codes...

See the result of exporting the list :

![alt text][1]


After clicking the export button the CSV generated contaisn all of the data *with labels and descriptions for english and spanish, even if the spanish has not been translated yet)!

Example :

    "item_code","item_label_es","item_label_en","item_description_es","item_description_en"
    "41","Ba","Ba","Boreal coniferous forest","Boreal coniferous forest"
    "43","BM","BM","Boreal mountain system","Boreal mountain system"
    "42","Bb","Bb","Boreal tundra woodland","Boreal tundra woodland"
    "50","P","P","Polar","Polar"
    "24","SBWh","SBWh","Subtropical desert","Subtropical desert"
    "22","SCs","SCs","Subtropical dry forest","Subtropical dry forest"
    "21","SCf","SCf","Subtropical humid forest","Subtropical humid forest"
    "25","SM","SM","Subtropical mountain system","Subtropical mountain system"
    "23","SBSh","SBSh","Subtropical steppe","Subtropical steppe"
    "32","TeDc","TeDc","Temperate continental forest","Temperate continental forest"
    "34","TeBWk","TeBWk","Temperate desert","Temperate desert"
    "35","TeM","TeM","Temperate mountain system","Temperate mountain system"
    "31","TeDo","TeDo","Temperate oceanic forest","Temperate oceanic forest"
    "33","TeBSk","TeBSk","Temperate steppe","Temperate steppe"
    "15","TBWh","TBWh","Tropical desert","Tropical desert"
    "13","TAwb","TAwb","Tropical dry forest","Tropical dry forest"
    "12","TAwa","TAwa","Tropical moist forest","Tropical moist forest"
    "16","TM","TM","Tropical mountain system","Tropical mountain system"
    "11","TAr","TAr","Tropical rainforest","Tropical rainforest"
    "14","TBSh","TBSh","Tropical shrubland","Tropical shrubland"
    "90","Water","Water","Water","Water"
    "0","No data","No data","No data","No data"

  [1]: http://www.openforis.org/support/upfiles/chrome_2016-11-08_13-15-16.png


## Answer (score 0, by migonser on 2016-11-10)

Link: https://openforis.support/questions/869/codes-and-labels-from-collect-to-csv-file/872

Hi,
That's an option, but what we need is the possibility to include a column in the CSV data export showing the label of every Code list value.
Thanks,


## Answer (score 0, by Open Foris on 2016-11-10)

Link: https://openforis.support/questions/869/codes-and-labels-from-collect-to-csv-file/873

Hello,

I misunderstood the issue. 
We will add this feature in the coming version of Collect Earth!

/Alfonso


## Answer (score 0, by Stefano (OF) on 2016-11-11)

Link: https://openforis.support/questions/869/codes-and-labels-from-collect-to-csv-file/884

Also in Collect 3.11.9 there is the possibility to export data to CSV including a column with the code list item label, you just have to open the **Additional options** box and check the relative option for that (the last one in the list).  

![alt text][1]

Many thanks,  
Open Foris Team


  [1]: http://www.openforis.org/support/upfiles/Screenshot_from_2016-11-11_11-23-39_2.png


## Answer (score 0, by Open Foris on 2016-11-14)

Link: https://openforis.support/questions/869/codes-and-labels-from-collect-to-csv-file/891

Dear Migonser,

This feature has been added to Collect Earth (version 1.4.5).

You will need to update your Collect Earth by going to the main menu **Help->Check for updates of Collect Earth** 

In this new version, when you choose if you want labels or not after you click on the CSV export!

Thank you for the feature request and let us know if there are other features you are missing!