How to Create a TermBase File in Excel in 2024
**TBX Exporter For Excel has been discontinued as an add-on. Instead, similar functionality is now available in the Pairaphrase application. Also, you can now upload a CSV file as your termbase in Pairaphrase.**
Need to create a TermBase eXchange file (TBX) from an Excel file? You’ve likely built out your glossary in Excel, navigated to the “Export” menu item and then realized there is no option to export to TBX format. The same goes for attempting “Save As.”
Sound like you? What you need is a Microsoft Excel add-in that converts an .xls, .csv or .xslx file to a .tbx file. Essentially, a glossary converter.
In this post, you’ll learn how to create a TermBase file using TBX Exporter For Excel. It’s a free Microsoft Excel add-in we developed at Pairaphrase.
It will help you export your TermBase glossary from Excel as a TermBase eXchange file format, also known as TBX. Read this whole post to have a successful outcome. Or, watch the video below. Please note our add-in only works on Windows machines.
1. Prepare Your Excel Spreadsheet to be Converted to TBX
If you want to know how to create a TermBase file in Excel successfully, our first pointer is to make preparations. You must compare your glossary worksheet to the following checklist to ensure you have a successful outcome.
Check for Complete Data
Make sure each row with a source term contains a translation and vice versa. It’s okay if your translation row contains more than one translation of the source term.
Follow the 1:1 TBX Standard
Check that your worksheet only contains two columns of text.
Remove Header Rows
Header rows aren’t required when using TBX Exporter For Excel. It will count them as terms in your glossary if you keep them, so be sure to remove them.
Fix Typos
Typos will create more work for you down the road. If you upload terms with typos to your translation software, you will receive those same typos forever more until you correct them.
Remove Excess Data
If your spreadsheet contains a notes column, part numbers, sentences, URL’s, code, etc, remove them. Comb through your worksheet for any extraneous code or characters that were included.
2. Export Your Spreadsheet to TBX
3. Upload the TBX File to Your Translation Management System
Now that know how to convert an Excel file to TBX, it’s time to upload it to your translation management system. We’ll use Pairaphrase as an example for this process, as it’s easy to use and compatible with TBX files, plus many more. TBX is just one tool in our suite of CAT tools meant to enhance your productivity.
Simply follow these steps to upload your TBX file to Pairaphrase:
- Log in at Pairaphrase.com
- Go to your account settings by clicking your name in the upper right-hand corner of the user interface
- Select “Translation Memories”
- Click “Upload a TMX or TBX File”
- Select a source language and a target language
- Choose the TBX option
- Upload the file
When you upload a TBX file to Pairaphrase:
Your termbase glossary is updated. In the Translation Editor, you can use the Lookup box to type a term in the source language and find the glossary translation. When using the Google Translation Engine, the Translation Editor will additionally identify all terms Pairaphrase picked up in the termbase glossary with a blue underline. What’s more, you can click on the underlined term to perform the Lookup and replace the term with the term found in your glossary.
Upload Your TermBase File To a Better Translation Management System
Now that you know how to create a TermBase file in Excel, it’s time to get started with Pairaphrase.
PDF Translation Problems & Solutions: Troubleshooting Guide [2024]
Learn common issues involved with translating PDF documents and discover why Pairaphrase is the best PDF document translator.
Most Accurate Translator Tool: What to Look for [2024]
While a 100% accurate translator does not yet exist, this post will tell you how to get the most accurate translator tailored to your company’s words and phrases.
11 AI Translation Industry Trends in 2024
Explore 2024 translation industry trends! Learn about 10 AI translation industry trends 2024 will bring, according to our predictions.
How to Translate JSON Files Online Effectively [2024]
Want to translate JSON files? Learn why Pairaphrase is the best way to auto-translate JSON files online.
How to Translate HTML Files to Another Language [2024]
Want to translate HTML files to another language? Learn why Pairaphrase is the best way to translate HTML files.
How to Translate PO Files Online [2024]
Need to translate PO files online? Learn why Pairaphrase is the best way to translate PO files.
OpenAI Language Translation: Pros & Cons for Enterprises
Exploring OpenAI language translation capabilities? In this article, discover the pros & cons of OpenAI translation for enterprise use.
File Translation 101: Your Guide to the Basics
Learn all about file translation in this 2023 guide to gain an understanding of the different kinds of file translation services & formats.
Best Way to Translate Elucidat Course Content
Learn how Pairaphrase makes Elucidat course translation reusable, secure, fast and easy.
5 Tips for eLearning Localization in 2024
Need to localize eLearning content? Familiarize yourself with these 5 eLearning localization tips for effective multilingual training.
How to Translate a Text File Online [2024]
Want to translate a text file? Learn why Pairaphrase is the best way to translate a text file for your organization.
Best DocTranslator Alternative (2024)
Want a secure enterprise alternative to DocTranslator? Learn why Pairaphrase is the best DocTranslator alternative for enterprises here »
Top 8 Translation Industry Trends (2023 Outlook)
Explore 2023 translation industry trends! Learn about 8 translation industry trends 2023 will bring, according to our predictions »
How to Translate a Google Doc Most Efficiently [2024]
Want to translate Google Doc text? Learn why you should use Pairaphrase as your Google Docs translator.
Best English to Polish Document Translation Software [2024]
Looking for English to Polish translation software, but not sure what features you need? Access this buying guide.
Translation Services 101: Your Guide to the Basics
Need translation services? First, learn the basics! This way, you can make an informed decision. Explore this guide to translation services.
Best Redokun Alternative for Enterprises (2024)
Want a secure enterprise alternative to Redokun? Learn why Pairaphrase is the best Redokun alternative for enterprises here »
Localization 101: Your Guide to the Basics
Curious about localization? Learn about localization vs translation, what it is, how it works, benefits & more in this guide to the basics!
Best Memsource Alternative for Enterprises (2024)
Want a secure enterprise alternative to Memsource? Learn why Pairaphrase is the best Memsource alternative for enterprises here »
How to Translate Entire Google Sheets (All Cells) [2024]
Want to translate entire Google Sheets? Learn why you should use Pairaphrase as your Google Sheets translator.
How to Translate an Entire Google Slides Presentation [2024]
Want to translate Google Slides presentation text, notes & charts? Learn why you should use Pairaphrase as your Google Slides translator.
Fast Turnaround Translation: How to Get it
While fast translation turnaround and linguistic quality is a delicate balance, this post will tell you how to best use Pairaphrase to get fast translations.
Best English to Arabic Document Translation Software (2024)
Looking for English to Arabic translation software, but not sure what features you need? Access this buying guide.
Best OnlineDocTranslator.com Alternative (2024)
Considering an alternative to OnlineDocTranslator.com? Explore why Pairaphrase is the best OnlineDocTranslator.com alternative for enterprises.
How to Translate an IEP Document [2024]
Need to translate an IEP document? Learn how to translate IEP documents in the most efficient and secure way possible.
Machine Translation (MT): Your Guide to the Basics [2024]
Curious about Machine Translation (MT)? Learn about machine translation, how it works, benefits of machine translation & more.
How to Translate XML Files Online (2024)
Need to translate XML files online? Learn about the best features to use when translating XML files.
Best English to Italian Document Translation Software (2024)
Want the best English to Italian document translation software for business? Read about the 10 best English-Italian translator app features.
Terminology Management in Translation: Essential Guide [2024]
Learn all about terminology management in this comprehensive guide.
Smartling Alternative for Enterprises in 2024
Want a Smartling alternative? Explore 10 possible reasons you need one, and why Pairaphrase might be your best alternative.
How to Translate XLIFF Files Online Successfully (2024)
Need to translate XLIFF files online? Learn why Pairaphrase is the best way to translate an XLIFF file.
Best Japanese to English Document Translation Software (2024)
Looking for Japanese to English translation software, but not sure what features you need? Access this buying guide.
How to Translate SRT Files Effectively [2024]
Learn how to translate SRT files in 2022! Explore the reasons Pairaphrase is the best way to translate an SRT file effectively.
Best English to Japanese Document Translation Software (2024)
Looking for English to Japanese translation software, but not sure what features you need? Access this buying guide.
Brochure Translation Software Features to Look for
Need brochure translation? Look for these 10 top brochure translator features (before you buy).
Best Way to Translate Articulate Course Files
Need to translate Articulate course files? Learn why Pairaphrase is the best way to translate Articulate files (XLIFF 2.0).
Best Way to Translate Multiple Files Simultaneously Online [2024]
Need to translate multiple files simultaneously online? Learn why Pairaphrase is best for batch translation.
Using Pairaphrase Translation Software with Amazon Translate
Curious about translating with Amazon Translate (AWS)? Learn about using Amazon’s machine translation engine with Pairaphrase.
Best English to Hindi Document Translation Software (2024)
Looking for English to Hindi translation software, but not sure what features you need? Access this buying guide.
How to Translate Large Files with Ease [2024]
Need to translate large files? Learn about the best tools to use when translating large PDF’s, documents & more (10MB+).
Catalog Translation Software Features to Look for
Need catalog translation? Look for these 10 top catalog translator features (before you buy).
Best English to Vietnamese Document Translation Software (2024)
Looking for English to Vietnamese translation software, but not sure what features you need? Access this buying guide.
How to Create Effective Termbase Glossaries for Machine Translation
Need to create a termbase glossary? Get our top 5 tips for creating effective termbase glossaries for machine translation.
Best English to Korean Document Translation Software (2024)
Looking for English to Korean translation software, but not sure what features you need? Access this buying guide.
Best DeepL Alternative for Enterprise Teams (2024)
Explore various DeepL drawbacks and user-specific needs you might identify with. This way, you can conclude whether alternatives to DeepL could fill these gaps.
Top 10 Translation Industry Trends in 2022
Explore 2022 translation industry trends! Learn about 10 translation industry trends 2022 will bring, according to our predictions »
Secure Transcription Software That Translates Languages
Need secure transcription software that translates languages? Learn what features to look for and how Pairaphrase will benefit you.
Best English to Portuguese Document Translation Software (2024)
Looking for English to Portuguese translation software, but not sure what features you need? Access this buying guide.
Translation KPIs for Translation Management Success
Establishing translation KPIs (Key Performance Indicators)? Here are the 5 Most Important KPIs for translation management success.