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