Create a flat taxonomy by uploading a CSV

Create a flat taxonomy by uploading a CSV#

Tags: educator how-to

Note

Users must be organization or instance level administrators in order to import taxonomies.

Tags that can be applied to content are organized into hierarchical taxonomies. Currently, the only way to create or modify a taxonomy is by uploading a CSV or JSON file.

The simplest type of taxonomy is a flat taxonomy that doesn’t have any hierarchy. For example, if you want to tag the “difficulty” of problems as either “Easy”, “Medium”, or “Hard”, you could do that by creating a flat taxonomy. Here’s how to do that:

  1. Open any spreadsheet application (Excel, Numbers, Google Sheets, etc.) and create a new blank spreadsheet. In the first row, add two columns called id and value.

    Screenshot showing new blank spreadsheet with one row and two columns, the first column called id and the second called value.

  2. Below that, enter the new tags that you want to create in the “value” column, and give each tag an ID in the “id” column. The “id” for each tag is required, but mostly relevant when you are aligning your taxonomy with some external system that uses IDs for each tag. If you don’t have that use case, just enter the same text for the id as for the value.

    Screenshot showing a spreadsheet with two columns, the first column called id and the second called value. The same tag values are populated in the id column and the value column.

  3. Save the spreadsheet using the default format, in case you want to edit it later.

  4. Export the spreadsheet to a CSV file.

    1. In Excel, use File > Save As…, and set the “File format” to “CSV UTF-8 (comma-delimited) (.csv)” (preferred) or “Comma Separated Values (.csv)” then enter a filename and save it.

    2. In Google Sheets, use File > Download > Comma Separated Values (.csv).

    3. In Numbers, use File > Export To > CSV… and use the default options.

  5. Import the taxonomy following the Import and Export A Taxonomy guide.

See also

Build a taxonomy using a template (how-to)

Import and Export A Taxonomy (how-to)

Update/Re-import a taxonomy (how-to)

Why does each tag need an ID when importing a taxonomy? (concept)

Manage Permissions on a Taxonomy (how-to)

Add and delete tags on courses (how-to)

Export tag data from a course (how-to)

Add and delete tags on course content (how-to)

Maintenance chart

Review Date

Working Group Reviewer

Release

Test situation

07/07/2025

Leira (Curricu.me)

Sumac

Pass