{"id":416,"date":"2021-02-27T21:07:30","date_gmt":"2021-02-27T19:07:30","guid":{"rendered":"https:\/\/www.aswinlutchanah.com\/blog\/?p=416"},"modified":"2026-08-03T22:06:57","modified_gmt":"2026-08-03T20:06:57","slug":"tip-of-the-week-google-sheet-automatic-translation","status":"publish","type":"post","link":"https:\/\/www.aswinlutchanah.com\/blog\/tip-of-the-week-google-sheet-automatic-translation\/","title":{"rendered":"Tip of the week &#8211; Google Sheet automatic translation"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Did you know that you can translate text automatically in Google Sheets? By now, if you are an active user in the digital world, you already know about <strong>Google Sheets<\/strong> and <strong>Google Translate<\/strong>, right? How about combining both? Yes, it&#8217;s possible. Let me show you how by using the <em>GoogleTranslate<\/em> function.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">How to translate text automatically in a Google Sheet?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">I&#8217;d recommend that you watch the video below for a start. It&#8217;s simple once you see it.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Open a <strong>Google Sheet<\/strong><\/li><li>Type a text in English in a cell: <em>Smile<\/em> in cell A2 for example<\/li><li>In cell B2, use the function <strong>GoogleTranslate<\/strong><ul><li>=GOOGLETRANSLATE(A2,&#8221;en&#8221;,&#8221;fr&#8221;) where<ul><li>A2 is the cell containing the <strong>original text<\/strong>; it could be directly some text between inverted commas: &#8220;Smile&#8221; instead of a cell.<\/li><li>&#8220;en&#8221; is the second parameter which should be the <strong>source language<\/strong>, i.e. the language of your original text.<\/li><li>&#8220;fr&#8221; is the third parameter and it&#8217;s your <strong>target language<\/strong>; the language in which you want the original text to be translated.<\/li><\/ul><\/li><\/ul><\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Video showing how to automatically translate text in Google Sheets<\/h3>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"Google Sheet automatic translation\" width=\"678\" height=\"381\" src=\"https:\/\/www.youtube.com\/embed\/p8gPDlsElu8?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">What are you waiting for? Open a Google Sheet and give it a try. I&#8217;d love to know how you will use this digital tip in real life.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Like, Share &amp; Comment. ?<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Smile. Create. Inspire. ?<br>Take Care,<br>#SocialMediaManager<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">LinkedIn publication of the second tip of the week: Google Sheet automatic translation<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">The <em>automatic translation in Google Sheet<\/em> tip was originally published on my LinkedIn profile on Saturday 20 February 2021. It&#8217;s the second tip in the &#8220;<strong>Tip of the week<\/strong>&#8221; series. Feel free to <a href=\"https:\/\/www.linkedin.com\/posts\/aswinlutchanah_tipoftheweek-howto-iphone-activity-6771422443472064512-Cm_e\">check my LinkedIn profile for the third tip of the week<\/a> that I published earlier today.<\/p>\n\n\n\n<iframe loading=\"lazy\" src=\"https:\/\/www.linkedin.com\/embed\/feed\/update\/urn:li:ugcPost:6768947309318426624\" height=\"869\" width=\"504\" frameborder=\"0\" allowfullscreen=\"\" title=\"Embedded post\"><\/iframe>\n\n\n\n<p class=\"wp-block-paragraph\">? Before you leave my blog, make sure you read the first tip of the week: <a href=\"https:\/\/www.aswinlutchanah.com\/blog\/tip-of-the-week-double-tap-screenshot-iphone\/\">double tap screenshot on iPhone<\/a>; it will make your life easier especially if you often make screenshots. People working in the marketing field often have to make screenshots to prove, test or for reporting purposes. Enjoy this digital tip as well and do not hesitate to ask for more.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Did you know that you can translate text automatically in Google Sheets? By now, if you are an active user in the digital world,&hellip;<\/p>\n","protected":false},"author":1,"featured_media":418,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"wpai_generated_summary":"","footnotes":""},"categories":[101,102],"tags":[104,106,107],"class_list":["post-416","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-digital-hybrid","category-tip-of-the-week","tag-tipoftheweek","tag-google-sheet","tag-marketing-tips"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Tip of the week - Google Sheet automatic translation - Aswin Lutchanah<\/title>\n<meta name=\"description\" content=\"Did you know that you can translate text automatically in Google Sheets? Let me show you how to do Google Sheet automatic translation.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.aswinlutchanah.com\/blog\/tip-of-the-week-google-sheet-automatic-translation\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Tip of the week - Google Sheet automatic translation\" \/>\n<meta property=\"og:description\" content=\"Did you know that you can translate text automatically in Google Sheets? Let me show you how to do Google Sheet automatic translation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.aswinlutchanah.com\/blog\/tip-of-the-week-google-sheet-automatic-translation\/\" \/>\n<meta property=\"og:site_name\" content=\"Aswin Lutchanah\" \/>\n<meta property=\"article:published_time\" content=\"2021-02-27T19:07:30+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-08-03T20:06:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.aswinlutchanah.com\/blog\/wp-content\/uploads\/2021\/02\/tip-of-the-week-google-translate-google-sheet-aswin-lutchanah-digital-hybrid.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Aswin Lutchanah\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Tip of the week - Google Sheet automatic translation\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/www.aswinlutchanah.com\/blog\/wp-content\/uploads\/2021\/02\/tip-of-the-week-google-translate-google-sheet-aswin-lutchanah-digital-hybrid.png\" \/>\n<meta name=\"twitter:creator\" content=\"@aswinlutchanah\" \/>\n<meta name=\"twitter:site\" content=\"@aswinlutchanah\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Aswin Lutchanah\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Tip of the week - Google Sheet automatic translation - Aswin Lutchanah","description":"Did you know that you can translate text automatically in Google Sheets? Let me show you how to do Google Sheet automatic translation.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.aswinlutchanah.com\/blog\/tip-of-the-week-google-sheet-automatic-translation\/","og_locale":"en_GB","og_type":"article","og_title":"Tip of the week - Google Sheet automatic translation","og_description":"Did you know that you can translate text automatically in Google Sheets? Let me show you how to do Google Sheet automatic translation.","og_url":"https:\/\/www.aswinlutchanah.com\/blog\/tip-of-the-week-google-sheet-automatic-translation\/","og_site_name":"Aswin Lutchanah","article_published_time":"2021-02-27T19:07:30+00:00","article_modified_time":"2026-08-03T20:06:57+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/www.aswinlutchanah.com\/blog\/wp-content\/uploads\/2021\/02\/tip-of-the-week-google-translate-google-sheet-aswin-lutchanah-digital-hybrid.png","type":"image\/png"}],"author":"Aswin Lutchanah","twitter_card":"summary_large_image","twitter_title":"Tip of the week - Google Sheet automatic translation","twitter_image":"https:\/\/www.aswinlutchanah.com\/blog\/wp-content\/uploads\/2021\/02\/tip-of-the-week-google-translate-google-sheet-aswin-lutchanah-digital-hybrid.png","twitter_creator":"@aswinlutchanah","twitter_site":"@aswinlutchanah","twitter_misc":{"Written by":"Aswin Lutchanah","Estimated reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.aswinlutchanah.com\/blog\/tip-of-the-week-google-sheet-automatic-translation\/#article","isPartOf":{"@id":"https:\/\/www.aswinlutchanah.com\/blog\/tip-of-the-week-google-sheet-automatic-translation\/"},"author":{"name":"Aswin Lutchanah","@id":"https:\/\/www.aswinlutchanah.com\/blog\/#\/schema\/person\/4e55fc3c7e19ea287db84544691cff76"},"headline":"Tip of the week &#8211; Google Sheet automatic translation","datePublished":"2021-02-27T19:07:30+00:00","dateModified":"2026-08-03T20:06:57+00:00","mainEntityOfPage":{"@id":"https:\/\/www.aswinlutchanah.com\/blog\/tip-of-the-week-google-sheet-automatic-translation\/"},"wordCount":362,"commentCount":0,"publisher":{"@id":"https:\/\/www.aswinlutchanah.com\/blog\/#\/schema\/person\/4e55fc3c7e19ea287db84544691cff76"},"image":{"@id":"https:\/\/www.aswinlutchanah.com\/blog\/tip-of-the-week-google-sheet-automatic-translation\/#primaryimage"},"thumbnailUrl":"https:\/\/www.aswinlutchanah.com\/blog\/wp-content\/uploads\/2021\/02\/tip-of-the-week-google-translate-google-sheet-aswin-lutchanah-digital-hybrid.png","keywords":["#TipOfTheWeek","Google Sheet","Marketing Tips"],"articleSection":["Digital Hybrid","Tip of the week"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.aswinlutchanah.com\/blog\/tip-of-the-week-google-sheet-automatic-translation\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.aswinlutchanah.com\/blog\/tip-of-the-week-google-sheet-automatic-translation\/","url":"https:\/\/www.aswinlutchanah.com\/blog\/tip-of-the-week-google-sheet-automatic-translation\/","name":"Tip of the week - Google Sheet automatic translation - Aswin Lutchanah","isPartOf":{"@id":"https:\/\/www.aswinlutchanah.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.aswinlutchanah.com\/blog\/tip-of-the-week-google-sheet-automatic-translation\/#primaryimage"},"image":{"@id":"https:\/\/www.aswinlutchanah.com\/blog\/tip-of-the-week-google-sheet-automatic-translation\/#primaryimage"},"thumbnailUrl":"https:\/\/www.aswinlutchanah.com\/blog\/wp-content\/uploads\/2021\/02\/tip-of-the-week-google-translate-google-sheet-aswin-lutchanah-digital-hybrid.png","datePublished":"2021-02-27T19:07:30+00:00","dateModified":"2026-08-03T20:06:57+00:00","description":"Did you know that you can translate text automatically in Google Sheets? Let me show you how to do Google Sheet automatic translation.","breadcrumb":{"@id":"https:\/\/www.aswinlutchanah.com\/blog\/tip-of-the-week-google-sheet-automatic-translation\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.aswinlutchanah.com\/blog\/tip-of-the-week-google-sheet-automatic-translation\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.aswinlutchanah.com\/blog\/tip-of-the-week-google-sheet-automatic-translation\/#primaryimage","url":"https:\/\/www.aswinlutchanah.com\/blog\/wp-content\/uploads\/2021\/02\/tip-of-the-week-google-translate-google-sheet-aswin-lutchanah-digital-hybrid.png","contentUrl":"https:\/\/www.aswinlutchanah.com\/blog\/wp-content\/uploads\/2021\/02\/tip-of-the-week-google-translate-google-sheet-aswin-lutchanah-digital-hybrid.png","width":1920,"height":1080,"caption":"Portrait of Aswin Lutchanah with the title of the tip of the week : Google Sheet automatic translation"},{"@type":"BreadcrumbList","@id":"https:\/\/www.aswinlutchanah.com\/blog\/tip-of-the-week-google-sheet-automatic-translation\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.aswinlutchanah.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Tip of the week &#8211; Google Sheet automatic translation"}]},{"@type":"WebSite","@id":"https:\/\/www.aswinlutchanah.com\/blog\/#website","url":"https:\/\/www.aswinlutchanah.com\/blog\/","name":"Aswin Lutchanah","description":"Hybrid Social Media Manager","publisher":{"@id":"https:\/\/www.aswinlutchanah.com\/blog\/#\/schema\/person\/4e55fc3c7e19ea287db84544691cff76"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.aswinlutchanah.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":["Person","Organization"],"@id":"https:\/\/www.aswinlutchanah.com\/blog\/#\/schema\/person\/4e55fc3c7e19ea287db84544691cff76","name":"Aswin Lutchanah","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.aswinlutchanah.com\/blog\/wp-content\/uploads\/2026\/08\/cropped-icon-512-1.png","url":"https:\/\/www.aswinlutchanah.com\/blog\/wp-content\/uploads\/2026\/08\/cropped-icon-512-1.png","contentUrl":"https:\/\/www.aswinlutchanah.com\/blog\/wp-content\/uploads\/2026\/08\/cropped-icon-512-1.png","width":512,"height":512,"caption":"Aswin Lutchanah"},"logo":{"@id":"https:\/\/www.aswinlutchanah.com\/blog\/wp-content\/uploads\/2026\/08\/cropped-icon-512-1.png"},"description":"Hybrid Social Media Manager based in Belval, Luxembourg, with 11+ years of experience in social media strategy, community building, storytelling, analytics and web development. Social media lead at the University of Luxembourg and founder of I Love Belval.","sameAs":["https:\/\/www.aswinlutchanah.com"]}]}},"_links":{"self":[{"href":"https:\/\/www.aswinlutchanah.com\/blog\/wp-json\/wp\/v2\/posts\/416","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.aswinlutchanah.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.aswinlutchanah.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.aswinlutchanah.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.aswinlutchanah.com\/blog\/wp-json\/wp\/v2\/comments?post=416"}],"version-history":[{"count":9,"href":"https:\/\/www.aswinlutchanah.com\/blog\/wp-json\/wp\/v2\/posts\/416\/revisions"}],"predecessor-version":[{"id":426,"href":"https:\/\/www.aswinlutchanah.com\/blog\/wp-json\/wp\/v2\/posts\/416\/revisions\/426"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.aswinlutchanah.com\/blog\/wp-json\/wp\/v2\/media\/418"}],"wp:attachment":[{"href":"https:\/\/www.aswinlutchanah.com\/blog\/wp-json\/wp\/v2\/media?parent=416"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.aswinlutchanah.com\/blog\/wp-json\/wp\/v2\/categories?post=416"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.aswinlutchanah.com\/blog\/wp-json\/wp\/v2\/tags?post=416"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}