If you manage translation terminology in Excel, you may eventually need to turn that spreadsheet into a termbase that can be used inside translation software.
A termbase helps translators and localization teams keep approved terminology consistent across projects. Instead of translating the same product name, technical term, or phrase differently each time, teams can store preferred translations and reuse them.
In 2026, you do not necessarily need to convert every Excel glossary into a TBX file manually. Pairaphrase can now accept a CSV file as a termbase, which makes the process much simpler.
What Is a TermBase File?
A termbase is a structured glossary containing approved source terms and their translations.
For example:
| English | Spanish |
|---|---|
| Customer support | Atención al cliente |
| Account settings | Configuración de la cuenta |
| Translation Memory | Memoria de traducción |
A termbase can help maintain terminology consistency across documents, websites, software, marketing content, and other multilingual materials.
TBX, or TermBase eXchange, is one format commonly used to move terminology between translation tools.
How to Prepare an Excel Glossary for a TermBase
Before importing or converting your spreadsheet, clean the data first.
This is one of the most important parts of the process because incorrect or inconsistent terminology can continue appearing in future translations.
1. Keep the Data Simple
For a basic bilingual termbase, keep one source-language column and one target-language column.
For example:
| English | French |
|---|---|
| Login | Connexion |
| User profile | Profil utilisateur |
| Save | Enregistrer |
Keeping the spreadsheet simple makes it easier for translation software to interpret the data correctly.
2. Check Every Term and Translation
Make sure each source term has the correct translation.
Avoid leaving incomplete rows where possible. If a term has more than one approved translation, review how your translation platform handles alternatives before importing the file.
3. Remove Unnecessary Information
Your working Excel glossary may contain extra information such as:
- URLs
- Notes
- Product numbers
- Internal comments
- Full sentences
- Code
- Formatting instructions
If the platform only expects source and target terminology, remove unnecessary data before uploading the file.
This reduces the chance of unrelated content being imported as terminology.
4. Fix Spelling and Terminology Errors
Review your glossary before importing it.
A small typo in a termbase can become a repeated problem because translation software may keep suggesting the incorrect term in future projects.
Check:
- Spelling
- Capitalization
- Punctuation
- Product names
- Technical terminology
- Approved brand terminology
It is much easier to clean the spreadsheet before importing hundreds or thousands of terms.
Do You Still Need to Convert Excel to TBX?
Not always.
Previously, Pairaphrase offered a TBX Exporter for Excel that converted XLS, XLSX, and CSV files into TBX files. That Excel add-in has now been discontinued.
Today, Pairaphrase allows users to upload a CSV file directly as a termbase.
This means that if your terminology already exists in Excel, you can organize the spreadsheet and save it as a CSV instead of adding another conversion step.
How to Save an Excel TermBase as CSV
Once your spreadsheet is ready:
- Open the glossary in Microsoft Excel.
- Review the source and target language columns.
- Remove unnecessary data.
- Select File > Save As.
- Choose CSV as the file format.
- Save the file.
You can then import the terminology into a translation platform that supports CSV termbase files.
Using Your TermBase in a Translation Management System
The real value of a termbase becomes clear once it is connected to your translation workflow.
Translation Management Systems can use terminology databases to help translators identify preferred terms while reviewing translated content.
For example, Pairaphrase allows teams to manage terminology alongside other CAT tools, Translation Memory, document translation, and human review workflows.
Instead of searching through a separate spreadsheet every time a terminology question appears, translators can access approved terminology during the translation process.
Why Terminology Management Matters
Terminology becomes increasingly difficult to control as translation volume grows.
Imagine several translators working on product documentation across five languages. Without an approved glossary, one product feature could easily be translated three different ways.
A termbase gives teams a shared reference point.
It can help organizations:
- Maintain consistent terminology
- Reduce repeated terminology research
- Improve translation review
- Standardize product names
- Support multilingual brand consistency
- Make future projects easier to manage
This is particularly useful for technical documentation, software localization, healthcare content, education materials, and other projects where terminology consistency matters.
TBX vs CSV: Which Should You Use?
Both formats can be useful.
TBX is a terminology exchange standard that can be useful when moving terminology between compatible translation systems.
CSV is simpler and easier to create directly from Excel.
If your translation platform accepts CSV termbases, using CSV can eliminate the need for an additional conversion step.
The right option depends on the translation software you use and how complex your terminology database needs to be.
Frequently Asked Questions
Can Excel create a TBX file directly?
Excel does not normally provide TBX as a standard Save As format. You typically need a compatible conversion tool or translation platform if TBX is specifically required.
Can I use a CSV file as a termbase?
Yes, if your translation platform supports CSV terminology imports. Pairaphrase now supports uploading CSV files as termbases.
What information should a basic termbase contain?
At minimum, a bilingual termbase generally contains a source-language term and its approved target-language translation.
Why should I clean my Excel glossary before importing it?
Cleaning the glossary helps prevent spelling mistakes, duplicate terminology, unnecessary data, and incorrect translations from being reused across future projects.
Conclusion
Learning how to create a termbase file in Excel is mainly about organizing your terminology correctly before importing it into your translation workflow.
Start with clean source and target terminology, remove unnecessary information, correct errors, and choose a format supported by your translation software.
While TBX remains useful for terminology exchange, CSV support makes the process much easier for teams already managing their glossaries in Excel.
Source: This blog was originally published on Pairaphrase.com
Top comments (0)