This site employs JavaScript, but your browser does not support JavaScript. Please enable JavaScript on your browser, or if your browser does not support JavaScript, access this site with a browser that does support Javascript.

Load Code List

Build an XML Schema file for code sets from an Excel spreadsheet. Use the sample spreadsheet as a template for generating: template.xls


The first row will be used as the type name. The second row is the definition of the code set that will be used as the definition of the type. The third row labels the columns as Code and Description. And the rest of the spreadsheet is the codes and the definitions. The Spreadsheet can have multiple tabs. Each tab will be used as a new Type and Simple Type.


Here is an example zip file generated from the template: template.zip.


The namespace schema location will specify the file to use for the codelist schema.


The Namespace Prefix will be used as the prefix in the schema file and also as the name of the file. Namespace Prefix

The namespace URI will be used as the target namespace of the schema file. Namespace URI

The namespace definition will be used in the schema documentation. Namespace Definition

???en_US.help.codelist.namespaceSchemaLocation??? Namespace Schema Location
example input: local/codes/schema.xsd

The namespace version will be used as the schema version of the file. Namespace Version

The Excel Code List Spreadsheet will be used to generate the schema. A template spreadsheet is provided. Code List Excel Spreadsheet