Your Excel sheet should contain two columns, one for each language (i.e. source and target). Each cell should contain the translation of the neighbouring cell.

1. One column per language, one segment per row: Make sure that you populate only two columns, one for each language. Columns should not have a heading. Each row should contain only a single translation unit (i.e. the source-language segment, and its translation in the target language).
2. Case sensitivity: Translation Memory is case-sensitive, which means that the capitalization of words is taken into account when checking for a 100% match. The two segments shown in the screenshot are not an exact match.
3. Multiple translations: If you want to add multiple translations for a segment (i.e. a one-to-many relationship), you may duplicate the source language segment in another row. However, if more than one translation match exists for a segment of text, the user will need to manually choose which match to use. In other words, the automatic pre-translation cannot itself make a decision about which 100% match to use.
4. Empty cells: Translation matches are stored in pairs. If no pair is available, the row will be ignored.

NOTE: One language must be common to each XML file. This is typically the source language (i.e. the language used in the original documents).

NOTE: All content of the Excel XML file will be uploaded to the one2edit™ Translation Memory. Therefore, your file should contain only the translation matches. Do not put headings on columns, as these will be treated as a translation match.

After you have finished preparing your Excel sheet, you must save it in the correct format.

In the Save As... dialog:

1. Choose the format option Excel 2004 XML Spreadsheet (.xml). This will have a file extension of .xml, not .xls or .xlsx.
2. Click Save.

NOTE: If you do not save your file in the Excel 2004 XML Spreadsheet format, your data cannot be imported into one2edit™.

NOTE: The screenshots above are from macOS.

To open the Translation Memory (TM) view for a Language Set:

1. Select the Language Set.
2. Ensure that all languages to be imported have been assigned to the Language Set, including the source language.
3. Click Open Set TM in the set's option menu to open its Translation Memory.

NOTE: Ensure that your Language Set contains all of the languages from your TMX file. If a language is missing from the Language Set, you will not be able to import any segments to that language.

NOTE: Each Language Set in one2edit™ contains its own, separate translation memory.

NOTE: There are no Language Sets in one2edit™ by default. If no Language Sets are displayed, please refer to the lesson for creating a Language Set.

Drag and drop the Excel XML file from your file browser to the area marked Drop your TMX of XML file here.

A Translation Memory Import dialog will open, showing a summary of the TMX content.

No language codes are present in an Excel XML file, so you will need to manually assign a language to each column. The drop-down menu at the top of each column allows you to select the languages from your Language Set.

NOTE: If no languages are chosen, the content cannot be imported.

When you have assigned the correct languages to the columns, click Save.

NOTE: Make sure that you choose the correct language. For example, if you choose English (United States) for two columns, this will corrupt the import.

NOTE: Not all translations are shown when importing a file to the Translation Memory. Only a sample is shown for verification purposes. All translations will be imported from the Excel XML file when you click Save.

1. Select Languages: Use the drop-down menus to select which languages to view. You may choose as many languages as you wish for a side-by-side comparison. The language selected in the left-hand column is the language which will be searched by any terms in the Search field.
2. Navigate TM Content: Use the arrows to navigate through pages of 50 segment matches at a time.
3. Hide a Language Column: If you wish to remove a language column from the display, click the X button beside the drop-down menu. This only closes the column view – it does not delete anything from the TM.
4. Edit a Translation Unit: Clicking the Edit button beside a translation until allows you to edit that translation directly in the TM.
5. Delete a Translation Unit: Clicking the Trashcan button beside a translation unit will delete that segment from the Translation Memory. This is permanent and cannot be undone except by re-importing that segment. A confirmation dialog is shown when this button is clicked.
6. Clear All: Clicking this option under the Action Menu will delete ALL content from this Translation Memory. This action is final and cannot be undone. Two confirmation dialogs are shown when this option is clicked, which makes it difficult to accidentally trash the TM.
7. Export: Click this option to export TM content as a TMX (Translation Memory eXchange) file.

NOTE: Clicking Clear All displays two confirmation dialogs, one after the other. Clicking Yes on both warning dialogs will permanently erase the entire Translation Memory. Therefore, please read all pop-up messages before accepting them.

Click the X beside the Language Set name in the breadcrumbs to close this view.

Alternatively, you can navigate away using the main Navigation menu.

1. To change or edit a segment in the Translation Memory (TM), click on the Edit icon beside the segment. This opens an editor dialog.
2. Click Save to save your changes to the TM segment. The time of the change, as well as the user who made the change, will be recorded.

NOTE: one2edit™ is not a full-featured tool for editing translation memory content in bulk. If you wish to do wholesale editing of your TM, please check online for a more suitable tool.