Note: When Import with Excel

Importing Translation Memory into Excel: Key Points to Note

1. One sentence per cell

Issue: Each cell should contain only one sentence, meaning there should be only one period (.) per cell.

Solution: Split sentences into separate cells.

2. No broken sentences in cell

Issue: Sentences should not be broken in each cell.

Solution: Merge broken sentences back together.

Sometimes a sentence might be broken within a cell without being immediately noticeable. In such cases, expand the input box to check if the sentence is split.

3. Avoid long sentences in cell

Issue: If a sentence is too long (e.g., more than three normal lines), the chances of finding a similar translation memory entry decrease. This is similar to searching "white cat" versus "a big, fat, greedy, and mischievous white cat" in a search engine—"white cat" is more likely to yield more results.

Solution: Break long sentences into multiple shorter sentences while maintaining their meaning and place each sentence in a separate Excel cell.

Updated on: 02/16/2025