Shopping Cart

TRANSLATE YOUR E-COMMERCE SITE QUICKLY AND WITHOUT MONEY IN 24 LANGUAGES

TRANSLATE YOUR E-COMMERCE SITE QUICKLY AND WITHOUT MONEY IN
Simply by translating your e-Commerce site into different languages, more than 24 languages to be precise. So you're going to tell me that translating a site is time consuming, it's expensive, yes it's true, but I found a simple way to do it quickly and without spending money. Now you're wondering how? I'll try to explain it to you in this article.

Do you know how to acquire new traffic without effort, without adding new products?

Simply by translating your ecommerce site into different languages, more than 24 languages to be precise. So you’re going to tell me that translating a site is time consuming, it’s expensive, yes it’s true, but I found a simple way to do it quickly and without spending money. Now you’re wondering how? I’ll try to explain it to you in this article.

Translate your website with the google sheets formula: google translate

Do you know this formula =GOOGLETRANSLATE( )? This formula will allow you to translate in several languages your product descriptions, your product names, H1 tag, title tag… well all the places where there is content. Who has never used Google translation?

When you want to translate something instinctively you go to google to translate

When you want to translate something instinctively you go to google to translate the sentence in question and you come across the google translation service. On google sheets (google excel), Google has added this feature, it will allow you to translate text in mass. So I grant you that the translation won’t be perfect but to start and get started quickly it can do the trick.

Prerequisite:

you must be able to export and import your descriptions via an excel file (CSV, XLSX).

Use the google translate formula

To use the formula you have to put =GOOGLETRANSLATE( l “he number of the cell you want to translate”; “the source language”; “the translation language”)

Example: =GOOGLETRANSLATE(A2; ” fr ” ; ” de “)

List of languages available for translation


Arabic – ar / Bulgarian – bg / Czech – cs / Danish – da / German – de / Greek – el /

English – en / Spanish – es / Finnish – fi / French – fr / Hindi – hi / Croatian – hr /

Italian – it / Japanese – ja / Korean – ko / Dutch – nl / Norwegian – no / Polish – pl /

Portuguese – pt / Romanian – ro / Russian – ru / Swedish – sv / Chinese – zh /

You just have to change the country code to translate into the desired language.

Example:

for China: =GOOGLETRANSLATE(A2; “fr”; “zh”)

for Russian =GOOGLETRANSLATE(A2; ” fr ” ; ” ru “)

Once you have added your formulas in the first line you only have to expand your formula by clicking on the cell as follows:

In conclusion

All you have to do is re-import your descriptions on your ecommerce site and you have a translated site in a few minutes.

And you, how do you translate your product sheets? Put me a nice comment if this tip helped you a lot.