Note: When Import with Excel
Importing Translation Memory into Excel: Key Points to Note
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.

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.

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.
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.

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.

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
Thank you!