Translate Text Using Google Spreadsheet

If you sell on Walmart.ca, you need to provide French translation for some values such as Title, Description, and attributes.

It is recommended to have a professional translator to convert your English descriptions of products to French, however as an alternative or temporary option you may use Google Translate. It is not a perfect solution, but it works pretty well and Walmart allows users to use this method for translations of product descriptions.

The formula to use in your Google Spreadsheet is:

=GOOGLETRANSLATE(text, "source_language", "target_language")

For example:

=GOOGLETRANSLATE("Hello","en","fr")

To translate text in bulk, create two columns. The first one with English text, and the second one with a formula in a cell B1:

=GOOGLETRANSLATE(A1,"en","fr")

If you now populate this formula down the column B, Google will translate your text.