TMs can be modified directly in the UI itself. Performing large-scale editing and modifications to the TM can only be done outside the UI. Appending the segment ID with update in the .XLSX file triggers an update on import.
To batch update a translation memory in a spreadsheet editor, follow these steps:
-
Export a TM to XLSX and ensure it is formatted correctly for import.
-
Open the file in an editor.
-
Insert two additional columns between the column and the first language column.
-
Keeping the ID information in column A, remove the column label and place it in column C.
-
Fill the cells in column B with the word update.
-
In the first cell of the column, create the formula
=(A2&"|"&B2)and click Enter.Cell C2 is populated with the ID from cell A2 and the word update (from cell B2) separated by
|. -
Copy the formula to the rest of the column.
All column cells are populated with the appended ID information.
-
Make required modifications to the segments.
-
Save the file.
-
Import the file back.
All segments with the appended ID are updated.
Appending the ID with the word delete instead of update will delete those segments on import.