If you have created a termbase in Lingo, you can import terms into it. You can import terms from TermBase eXchange (TBX), comma-separated value (CSV), or Microsoft Excel (XLS or XLSX) files.
- TBX TBX is an open, XML-based standard used for exchanging structured terminological data. It has been approved as an international standard by the Localization Industry Standards Association (LISA) and the International Organization for Standardization (ISO). One difference between a TBX file and a Translation Memory eXchange (TMX) file is that a TBX file handles multiple languages, whereas a TMX file handles only two languages.
- CSV CSV is a plain text file format that uses line breaks to separate characters. It is supported by common applications such as Microsoft Excel. While a TermBase eXchange (TBX) file is the standard for compiling termbases, you can use a program like Excel to build and maintain your termbase, and then import it to Lingo using CSV.
- XLS or XLSX XLS and XLSX are spreadsheet files supported by Microsoft Excel. While a TermBase eXchange (TBX) file is the standard for compiling termbases, you can use a program like Excel to build and maintain your termbase, and then import it to Lingo using XLS or XLSX.
Select the Resources ribbon. In the TBX section, select Import Termbase.
The Import Termbase File dialog opens.
- Next to the Termbase File field, click . The Select TBX file to import dialog opens, where you can locate the TBX, CSV, or Excel file.
- Select the file and click Open.
- From the Destination Termbase drop-down, select the termbase to which you want to import the fields in the TBX, CSV, or Excel file.
Click Start Import.
If you are importing a CSV or Excel file, the Column Mapping dialog opens.
From the Term Property drop-down, select the metadata you want to assign to the values in each column.
From the Reference drop-down, select the language to associate with each column.
- (Optional) If you want to use the first row of the spreadsheet as headers in your termbase, select Use first row as column headers.
- Click OK.
Note: Lingo supports TBX-Basic files (not the Full version).