This module allows to import/export taxonomies, structures or simple lists of terms into/from a vocabulary from/to a CSV file, a url or a copy-and-paste text.
CSV format is a simple list of values separated by a delimiter, often comma (
,) or semicolon (
;), and enclosures, often quotation marks (
"). If you are unsure how to create a CSV file, you might want to use LibreOffice Calc or another spreadsheet application to export your data into a CSV file.
Specific import or export formats can be added simply by a plug-in mecanism (or ask author!).
After enabling the module, permissions "import taxonomy by csv" and "export taxonomy by csv" need to be set. Main "administer taxonomy" permission is not needed to use module, but this is recommended.
Internationalization is supported, except for attached Fields [Taxonomy CSV pour Drupal 7 only]. So you can import a list or a structure of terms, then translate them.
This module supports drush and allows to import or to export taxonomies by csv with command line interface.
Taxonomy CSV for Drupal 7 has got a simpler UI compared to the version for Drupal 6, because taxonomy has been reworked with fields in Drupal 7. Help for Drupal 6 version is available in English or in French.
Multiple formats can be used to import or export vocabulary. Except with some formats, the first column contains the term name. You can specify what you want to export and how additional columns should be imported.
To import a complex taxonomy, it's recommended to import terms in this order:
That's what you can choose in the first tab. You can use "Term ids" format too, specially to update a vocabulary with duplicate terms.
Use this option to import a lot of terms in order to create a flat vocabulary. All items in your file will be imported as terms. Example:
Clothes, Trees, Houses
Use this option to create a tree structure of a vocabulary (geography, classification...). To import a hierarchy with multiple parents as a genealogical one, it's advised to use "Polyhierarchy", "First level children" or "First level parents" imports.Your file can be written with two schemes and a mixed one.
Animal, Mammal, Whale
Animal, Mammal, Monkey
Animal, Mammal, Human
Mammal> is imported as a first level term and not as a <
Animal> term child as in previous line.
World Asia Japan Tokyo Korea Seoul
Paris> will be automatically added as a child of <
France> and so on.
Partial lines are allowed, so a next line can be:
Switzerland> will be added as a child of <
Europe> and of course <
Bern> as a child of <
In same way, above lines can be simplified to:
World, Asia, Japan, Tokyo
,, Korea, Seoul
World, Europe, France, Paris
Seoul> will become a child of <
Use this option to create a a polyhierarchical structure, as a genealogy.
Format is the same than tree structure: each term is the child of previous item: parent, child, sub-child... and so on.
There are four differences. First, the first item doesn't need to be a root. Second, duplicate terms are always merged, except when one is the direct parent of the other one, because it's forbidden in Drupal. So, if the vocabulary is monohierarchical and without non-direct duplicate terms, as in the previous geographical example, result is the same than with previous option. Third, lines can be partial too, but in some case of duplicates, result may differ. Last, polyhierarchy can be recursive.
For example, lines may be:
Grand-Mother, Mother, Daughter
Grand-Father, Mother, Son
Grand-Mother 2, Father, Daughter
Grand-Father 2, Father, Son
, , Son 2
Grand-Mother 2, Uncle
Father, Son 3
Terms are imported with a csv scheme provided by the user.
Structure and Fields can be imported simultaneously. This is particularly recommended when you import a tree with duplicate names.
The csv scheme should contain each column header of the csv input. The column header is the name (not the label) of the field where to import items into. It can be a default header (name, description, weight, vid, vocabulary_machine_name, guid) or a custom field. The first item is always the name or the tid of a term.
For example, you want to import a list of car makers, and you would like each car maker to have custom fields indicating nationality and date of origine(origine of example, fictional):
[Taxonomy Term] - [Custom Field] - [Custom Field]
Car Maker - Country - Year Started
Ford - US - 1900
Renault - France - 1901
Toyota - Japan - 1902
Nissan - Japan - 1903
Daimler Benz - Germany - 1904
So, with 'Fields' format, you can set your format:
name, field_country, field_year_started
or more generically:
name, field_mycustomfield_1_machinename, field_mycustomfield_2_machinename...
Items can be repeated for multivalued fields.
name, description, weight, parent, synonym, synonym, synonym, related_term, related_term, related_term, related_term
The module supports all field types as long as they have a 'value' in their definition. These fields has been checked:
taxonomy_term_reference[Note: if value is a number, the field will be linked to the term with that tid; if value is a string, the field will be linked to an existing or a new term with that name.]
You can import structure and fields simultaneously. The fields are always attached to the last term of the tree:
Europe, continent, Europe is a continent, specific item
Europe, France, , France is a country,
Europe, France, Lyon, , Lyon is a city,
You can add empty names in order to begin the fields at the same column on each line:
Europe, , , continent, Europe is a continent, specific item
Europe, France, , , France is a country ,
Europe, France, Lyon, , Lyon is a city ,
"One term by line" format is supported with fields too:
Europe, , , continent, Europe is a continent, specific item
, France, , , France is a country ,
, , Lyon, , Lyon is a city ,
For these three examples, the custom format will be:
tree, my_specific_field_for_continent, description, specific_field
Note that it's important to add empty content when a field is empty, particuliarly at the end of the line (here for
Custom fields are automatically created if they don't exist and then attached to the vocabulary. By default, a 'text' field is created when the field doesn't exist. If you want to create another type of field, you have to set it with
"|" symbol in the vocabulary section of the form. The field is not created or modified if it exists.
For exemple, you want to import these items (origine of example):
name 1, tax gtin name 1, description 1, /home/robertom/file1.pdf, status 1, related term 1, related term 2, related term 3
name 2, tax gtin name 2, description 2, /home/robertom/file2.pdf, status 2, related term 1, related term 4
name 3, tax gtin name 3, description 3, /home/robertom/file3.pdf, status 3
Your custom format will be:
name, field_internal_name, description, field_file, field_status, related_term, related_term, related_term
Your custom fields will be:
Translation is available only if i18n is installed and the submodule i18n Taxonomy is enabled. Furthermore, the i18n mode of the vocabulary should be "Translate" or "Localize".
Warning: If you have a tree structure, you should import it before fields or translations, and for each translation if you use a full Translate mode.
Format: The term is in the first column followed by its translations. If the i18n mode is Localize, then description and translated descriptions can be added.
For vocabulary with Translate mode:
term name/id, first translated term name, second translated term name...
For vocabulary with Localize mode:
term name/id, first translation of term name... , description, first translation of description...
"United Kingdom", "Royaume-Uni", "Vereinigte Königreich"
"Germany", "Allemagne", "A European country", "Un pays européen"[vocabulary with Localize mode only]
"und") cannot be translated.
Import by "Term ids" uses internal identifiants ("tid") and allows to update flat or structured vocabularies.
term id, term name, term id 2, term name 2...
11, bar, 12, sub-bar
Taxonomy CSV allows to import structure and properties of terms.
Source can be configured with the first field set. See formats.
You can import your terms from a file or with a text area. Simply check your choice. File can be a local file path or a url.
Import need to be utf-8 formatted, without byte order mark in preference.
This group of settings allows to set non standard delimiter and enclosure and specific locales, such as "fr_FR.utf8".
," by default, semicolon "
;" or tabulation) between terms can be chosen in Advanced settings in the second fieldset. You can choose a custom delimiter too. Delimiter is a one character string. Example with delimiter <
term 1¤This field has commas, a semicolon (;), a quotation mark (") and a tabulation, but it will be correctly imported.
"), specialy if they contain non-ASCII letters or if imported items, in particular descriptions, contain the chosen delimiter. Example:
"term 1","This field has a comma, but it will be correctly imported."
") are automatically managed.
You can import your terms in a existing vocabulary or create a new one. You can import your terms too in an existing vocabulary.
When you want to import a new taxonomy into an existing one, it is recommended to process in two steps in order to check import.
If you only want to create a new vocabulary, the first choice is sufficient, unless when you have multiple files for one vocabulary.
Destination can be configured with the next field set. You can specify what will become existing terms when you import a term with the same name.
Update current terms when name matches with imported ones and merge existing descriptions, parents, etc. Duplicates are removed. This choice is recommended. Note: Duplicate terms in trees are fully supported.
Let current terms as they are and create a new term for the first column term.
Warning: This can create duplicate terms. It is recommended to use this option only if you are sure that imported taxonomy contains only new terms or if your vocabulary allows multiple parents.
This group of options allows to choose informations displayed at end of process.
To import big taxonomies (from 1000 or 10000 lines depending on the server) when access to time and memory settings of server are forbidden, it is recommended first to disable some other taxonomy related modules as "pathauto" before import. Settings aren't lost when you disable a module - and not uninstall it -. After import process, modules can be reactivated.
Next, you can use these tweaks (in groups of options).
Stats, terms and notices or warnings displayed at the end of process are memory consomming. So, you can reduce or disable them.
As to calculate vocabulary hierarchy is memory intensive, this option allows to set hierarchy manually without verify it.
If you are sure that vocabulary to import is well formatted (utf8, order of items...), you can disable checks. This option increases import speed by 5%.
Taxonomy CSV allows to export structures and properties of terms of one or all vocabularies.
Simply choose what you want to export (see formats) and how to export. Some formats may be unavailable.
This module supports drush: you can import/export taxonomies from the command line interface with
drush taxocsv-import and
drush taxocsv-export. See command line help for more information.
More generally, this module can be used as an API. You can use the full module as a dependance or directly in your module. Import is run as this:
$csv_lines = '"Europe", "France", "Paris"';
$csv_lines .= "\n". ',, "Lyon"';
$csv_lines .= "\n". ',"United Kingdom", "London"';
$csv_lines .= "\n". ',"Portugal", "Lisbonne"';
$result = taxonomy_csv_import(
'text' => $csv_lines,
'import_format' => 'tree',
'update_or_ignore' => 'update',
Or as this (line level import):
$result = taxonomy_csv_line_import(
array("Europe", "France", "Paris"),
'import_format' => 'tree',
'vocabulary_id' => 2,
'update_or_ignore' => 'update',
Possible formats are explained in comments or above. Some may be unavailable.
Taxonomy Builder API can be more convenient in some cases. Choice depends on your needs. Taxonomy CSV is designed as a run-once module with checks and multiple formats, while Taxonomy Builder is a permanent, light and quick module. A full explanation of the differences in design can be found here.
To import/export terms, user needs 'Import taxonomy by CSV' and 'Export taxonomy by CSV' rights.
Furthermore, user needs general taxonomy permissions (Drupal 6) or taxonomy permissions (Drupal 7). These permissions are often associated with access rights for administration pages.
Another Drupal module allows CSV import too, despite its name: taxonomy XML. Its approach is different: it uses one file compliant to thesauri standard ISO 2788, i.e. a three columns csv file:
term, type of link (relation, description, synonym...), item, or, for specialists,
subject, predicate, object. Additional fields are managed as the third one.
Taxonomy manager can be used too.
For export, you can use Taxonomy XML too or one of backup modules. Taxonomy CSV is a more specialised tool which allows more precise tuning.