Export code values in a code list to a CSV file. You can configure the format of the data and the attributes that you want to include in the exported file.
1Open a code list.
2Optionally, filter code values or search for specific code values in the code list.
After you filter the code values, Reference 360 displays the complete hierarchy of the matched code values for hierarchical code lists.
Note:
Reference 360 displays the attributes that you selected in the column settings as filters.
3Optionally, to view the code values at a point in time, select the date and time using the calendar or enter the date and time in the Point in Time field.
4Click Export Values.
The Export dialog box appears.
5On the General tab, enter a file name.
6To export the parent code value for each code value in the hierarchy, select Include hierarchy.
This option is available only for hierarchical code lists.
7To export the display attributes of the code list, select Include Display Attributes.
8To export the metadata of the code list, select Include Metadata Attributes.
You can export the following metadata attributes:
- Last updated date
- Last updated by user
- Created date
- Created by user
- Last updated date of parent relationship
- Last updated by user of parent relationship
Note:
You can export the last updated date of parent relationship and last updated user of parent relationship attributes only for hierarchical code lists.
9In the Values to Export option, select one of the following options:
- All. Exports all code values in the code list.
- Currently Listed. Exports only the filtered set of code values, specific code values based on the search results, or the code values that existed at a specific point in time.
10Optionally, configure how you want the data to be formatted in the file that you export.
Field
Description
Delimiter
Character used to separate values.
Date Format
Format used for dates.
Decimal Mark
Decimal separator used for numbers.
Thousands Separator
Grouping separator used for numbers.
11If you export the code values to back up attribute data before enabling the multilingual property, select Prepare for Localization in the Localization section.
When an export file isn't prepared for localization, you have to manually add the Language field and its values to the export file.
In the exported CSV file, the number of rows is based on the number of target languages, and the file includes the _language and _localizedContent fields. During import, the import process automatically maps the _language and _localizedContent fields.
The following table lists a sample exported CSV file that includes _language and _localizedContent fields:
_language
_localizedContent.Name
Code
Description
status.status.key
effectiveDate
en-US
Female
F
Identifies a person as female.
18-06-2025
pt-BR
Feminino
F
18-06-2025
en-US
Male
M
Identifies a person as male.
18-06-2025
pt-BR
Masculino
M
18-06-2025
en-US
Unknown
U
Indicates that the gender is unknown or not specified.