From Excel to Single Source of Truth

Is there terminology in the company? Marketing has a long Excel with proper names? The technical editorial team one terminology list per product? There is a lot of time and love in creating terminology lists – but it doesn’t reach the end users? Time for terminology consolidation in a termbase!

Termbase as single source of truth

To ensure that users are aware of terminology, a common terminology database is needed. Concept-based terminology systems that are made available to all employees on the intranet are suitable for this purpose. You can see the terms used for a concept, definitions, and other metadata such as context and subject areas.

The cross-valid termbase can be connected to editorial systems and translation systems, so that authors and translators are referred to the correct terminology when writing. Another big advantage: the structured information units contained in the termbase can be made available to AI as a knowledge resource.

Terminology consolidation: make one out of many

The big question is: how do I get to the central database from many Excel lists? Terminology consolidation requires analysis, matching, and merging of existing lists. Duplicate names and spelling variants must be standardized. Synonyms are determined and assigned to each other in concepts. Comprehensive definitions must be created and verified. Metadata records, for example, specialist areas and contexts.

What is hardly possible manually can be easily automated. The blc Data Toolkit can be used to selectively merge different terminology lists. Precise rules can be set for overlapping naming and metadata. Duplicates and unique cases are merged fully automated. We provide a recommendation for less clear cases.

The terminology lists are then merged into a common target format that can be imported directly into the terminology system. In the terminology system, the terminologists can then review the result and evaluate and implement the recommendations from terminology consolidation.

Simply throw everything together?

Of course, consolidating terminology assets is not about bringing all the names in circulation together unchecked. The goal of the exercise should be to clean up and unify terminology.

For cleaning, the merged terminology list should be quality checked before importing. A useful first step is to validate terminology for its technical relevance using the blc Data Toolkit. We sort out unsuitable terms such as general language or phrases before importing them. We also identify special features such as special characters, numbers, hyphens to ensure uniform naming.

For standardization, we automatically identify synonyms in various specialist areas and prepare them as a basis for discussion. The discussion can take place in the future in the terminology system when all synonyms are combined in one concept. Ideally, the departments now agree on an overarching preference term for all departments. This ensures a consistent and unambiguous corporate language. However, if different terms are required (e.g. for technology and marketing), they are clearly marked as synonyms in the same concept.

Conclusion: termbase as a treasure trove of knowledge

The result is a clear termbase with compressed corporate knowledge. As a valuable resource, it supports knowledge building, editing, translation and AI applications. For this, it is essential that the termbase continues to live after the Excel lists have been consolidated. In the best case, employees from all specialist areas control their terms at the first use. In terminology workflows, they are then validated, cross-aligned, and shared.

Get in touch with us for further input on consolidating and standardizing terminology assets.

Related Posts