Your Excel sheet should contain two columns, one for each language. Each cell should contain the translation of the neighbouring cell.

1. One translation per row: Add one translation to each row of the Excel sheet.
2. One column per language: Best practice is to only have two languages per Excel file. Each language should be placed in its own column.

Because each file will contain two languages, you will need one language that is common to each XML file. This is typically the source language of your documents.

Therefore, if you are importing translations from 4 languages, you will import 3 different XML files. Each file will contain:

• a column of text segments in the common source language (in the above example, it is English).
• a column of text segments containing translations to the target language (in the above example, it is German).

This is required for the database to match translations across languages.

NOTE: Do not put headings on your columns, because those headings will be imported as translations. You will assign a language to each column during the import process.

NOTE: Translation Memory (TM) is case-sensitive, which means that capitalization is taken into account when checking for translation matches. For example, if your TM contains the segment "Hello.", but your document contains the text "HELLO.", these will not be a 100% match.

After you have finished preparing your file, you must then save it in the correct format.

When saving the file using Excel:

3. Choose the File Format of: Excel 2004 XML Spreadsheet (.xml)
4. Click 'Save'.

NOTE: You may get a warning when saving your file in this format. Ensure that you choose to save the file as XML anyway. Your data cannot be imported to one2edit™ if you do not save your file in an XML format.

NOTE: This file will have an extension of .xml, not .xls or .xlsx. If your file has an extension of .xls or .xlsx, please re-save it as XML.

In order to import an Excel XML file to a Language Set, you will first need to open the Translation Memory for that Language Set.

To do this:

• Open the Language Sets dialog via Settings > Language Sets in the main navigation menu.
• Choose Open Set TM from the Set's option menu.

NOTE: You must ensure that your Language Set contains all required languages. If a language used in your XML file is missing from the Language Set, the translation units for that language cannot be imported.

NOTE: Each Language Set in one2edit™ contains its own Translation Memory. Please ensure that you are importing the XML file to the correct Language Set.

NOTE: You must create your own Language Sets. If no Language Sets can be found, please refer to the lessons about creating Language Sets.

1. Once you have opened the Language-Set Translation Memory view, simply drag-and-drop your TMX file into the browser.

NOTE: If you have any issues, please ensure that your file was saved as Excel XML.

This opens the Translation Memory Import dialog.

2. Here you can see a sample of the translation units being imported from the XML file. The translation units are displayed side-by-side, with one language in each column.
3. You must choose the language for each column via the drop-down menus at the top.

NOTE: All languages from your Language Set will be available in the drop-down menu. You must ensure that the correct language is selected for each column. If the required language is not displayed, then you must add that language to your Language Set.

NOTE: Not all of the translations are shown in this dialog. Only a small sample is shown for verification purposes. However, all translations from the TMX file will be imported when the Save button is clicked.

4. If the translations look correct, click Save to write them to your Translation Memory. This will close the import dialog.

NOTE: Clicking Cancel will cancel the import, and nothing will have been added to this Translation Memory

You can now check your imported translation units.

1. Languages: Select the two languages that were in your XML file (the source and target languages) from the drop-down menus.
   • Clicking the X beside a language name will remove the language from the current view. It will not remove the language from your Translation Memory.
2. Search: To search for specific words or text segments, you can use the search field in the upper-left corner. The Search is performed on the text in the left-most column.
3. Browse Pages: Translation Memories can become very large, and are displayed in pages for performance reasons. The arrows at the top are used to page through long Translation Memories.
4. Edit a Segment: Click the pencil button beside a segment of text to edit it within the Translation Memory. See the next step for more details.
5. Delete a Translation: Click the trashcan button next to a text segment to delete it from your translation memory. This action is final and can not be undone.
   • Only the segment from that specific language will be deleted. Any matches in other languages will remain intact.
6. Action Menu: The action menu in the lower-right corner has two options:
   • Clear All: Clicking Clear All will delete ALL content from this Translation Memory. This action is final and cannot be undone. For this reason, the Clear All command should be used with caution.
   • Export: Click to export the contents of your translation memory to a TMX (Translation Memory eXchange) file.

NOTE: A warning message will be displayed if Clear All is clicked. You will need to confirm your decision twice in order to delete all content from the Translation-Memory.

1. To edit the content of a segment in the Translation Memory, click on the pencil icon beside the segment. This opens an editor window.
2. Click Save to save your changes to the Translation Memory.

NOTE: one2edit™ is not a full-featured CAT tool. If you wish to do wholesale editing of your Translation Memory, please check online for a tool.