How to do Batch Updates to Translation Memories

Memsource allows users to modify TMs directly in the UI itself. However, performing large-scale editing and modifications to the TM can only be done outside the Memsource UI. The sections below provide guidelines for updating TMs using Microsoft Excel.

Exportation of TMs

  • In your Memsource account, click on the Translation Memories section and open the translation memory you wish to update.
  • Once in the TM, scroll down to the Import/Export section and select Export.
  • Select XLSX as the format for the export.
  • In the dialog window, you can specify what information the exported XLSX file should contain. Each box you check will create a column containing that information.
  • Select Export and download the XLSX file.

MS Excel Preparation

Note: If you want to update your translation memory with content processed in MS Excel, you will need to make sure that the file is formatted correctly.

Below, you'll find an easy way to add "update" to the translation unit IDs in the entire document, which can then be used to update the translation memory in Memsource. This procedure can also be used to delete the translation units completely—in this case, by using "delete" instead of "update".

  • Insert 2 additional columns between *ID* and the first language column.
  • Move the *ID* header right next to the 2nd newly created column. Keep the rest of the information in Column A.
  • Fill the 1st empty column (Column B) with the word update.
  • Next, you'll insert a formula into the new *ID* column. Highlight the cell in Column A (with the translation unit's ID) and the cell in Column B (with the word update).
  • With the cells in Columns A and B still highlighted, enter 
  • Insert the formulate below into the new *ID* column. 
    • =(CELL1&"|"&CELL2)
    • Make sure you are selecting the correct columns (the column with translation unit IDs needs to be selected in place of CELL1, the column containing the word update should be selected in place of CELL2).
    • You can also specify the location of the cells manually using your mouse.
  • Once the formula is completed, press Enter.
  • The first line of the column *ID* now contains the correct attribute added to the end of the ID.
  • Drag the corner of this cell to the rest of the file to pre-fill the entire column with the same formula results.
  • The segments in the file are now ready to update your TM in Memsource.
  • Once all the edits are done, Save the file.

Updating the TM

The updated file can now be imported back into Memsource and used to update the original translation memory.

  • In your Memsource Account, navigate back to the translation memory from which this XLSX was downloaded.
  • Use the Import button and select the updated XLSX file.
  • Once selected, click Import.
  • The XLSX file will be imported. However, instead of creating new segments, the segments in the document will update the content of your translation memory. Segments that were changed will replace the older versions. Unchanged segments will remain intact.


Click below to see a short video detailing this process:

Was this article helpful?



Please sign in to leave a comment.