Free Online Storage

  • Subscribe to our RSS feed.
  • Twitter
  • StumbleUpon
  • Reddit
  • Facebook
  • Digg

Thursday, 1 October 2009

Translation functions in spreadsheets

Posted on 16:20 by Unknown
Earlier this week, we added two functions to Google spreadsheets that add translation and language detection capabilities.
  • =GoogleTranslate("Hola, ¿cómo estás?","es","en") gives "Hi, how are you"
  • =DetectLanguage("Hola, ¿cómo estás?") gives "es"
Breaking down the first function, =GoogleTranslate("field one", "field two," field three"), the first field should be the text you want to translate -- in this case "Hola, ¿cómo estás?". The second field should be the two letter language code of the text you want to translate -- "es" is the two letter code for Spanish. Lastly, the final field indicates which language you want want the text to be translated into -- "en" is the two letter code for English. If you leave out the last field, the function will automatically translate the text into the language of the spreadsheet. The second function, =DetectLanguage("field one") works similarly and outputs the two letter language code of the text.

These functions open up some fun and interesting ways to use forms. For example, you could collect comments in many languages and use the two functions together to automatically translate responses into your native language.


If you hover over a cell with translated text, the original text is displayed.


If you want to try it out for yourself, check out this template. We're excited about the possibilities this opens up and we hope you enjoy translating your spreadsheets.

Posted by: Frank Tang, Software Engineer
Email ThisBlogThis!Share to XShare to Facebook
Posted in Google Apps Blog | No comments
Newer Post Older Post Home

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Popular Posts

  • More Google Experiments That Hide Results URLs
    There are at least two other versions of the Google experiment that removes search results URLs . The first alternate version places site na...
  • Add a Keyboard Shortcut for Chrome's App Launcher
    I'm not sure why Chrome's app launcher doesn't have a keyboard shortcut, but it's pretty easy to add one. For Windows XP, r...
  • Merge cells vertically in Google spreadsheets
    There are many times when you want to format your spreadsheets in a certain way to make your data easier to read and understand. Starting to...
  • We launched Table of Contents, too
    I'm writing this from the Phoenix Sky Harbor airport, just 5 minutes before I hop on a plane back to Google in California. I spent the d...
  • Custom Maps in the New Google Maps
    The new version of Google Maps constantly brings back features from the classic Google Maps, which shows that it's almost ready to becom...
  • Google Maps Easter Egg for Christmas
    The Pegman icon from the new Google Maps looks different: it now has a Santa hat. The classic Google Maps still shows the standard icon. Che...
  • Speakout gears up
    Posted by: Jen We now have lots of schools participating in our Global Warming Student Speakout from each of the locations listed below. We...
  • The New Google+ Photo Editor
    Google+ had a photo editor that used Flash , worked in any desktop browser and it was powered by Picnik. Google changed this and switched to...
  • Google Tests New Desktop Sign-in Page
    Back in August, Google changed the sign-in page for mobile devices. A few readers report that they see the updated sign-in page in the desk...
  • A Google Reader Puzzle From 2007
    Back in 2007, Google accidentally made public an internal video about Google Reader. The video included a lot of useful information about ...

Categories

  • Acquisitions
  • Ads
  • Android
  • Annoyances
  • April Fools Day
  • attachments
  • back to school
  • Blogger
  • charts
  • chat
  • Chrome
  • Chrome extensions
  • chrome web apps
  • Cloud Connect
  • collaboration
  • comments
  • community
  • discussions
  • DMCA
  • docs
  • document list
  • documents
  • documents list
  • drawings
  • drivebacktoschool
  • Easter Egg
  • education
  • Faces of Docs
  • forms
  • gmail
  • gone google
  • Google Alerts
  • Google Analytics
  • Google Apps Blog
  • Google Apps Script
  • Google Calendar
  • Google Cast
  • Google Checkout
  • Google Chrome
  • Google Chrome OS
  • Google Cloud Connect
  • Google Contacts
  • Google Dictionary
  • Google Docs
  • Google Docs Viewer
  • google documents
  • google drive
  • Google Earth
  • Google Goggles
  • Google Hangouts
  • Google Instant
  • Google Keep
  • Google Latitude
  • Google Local
  • Google Maps
  • Google Music
  • Google News
  • Google Notebook
  • Google Now
  • Google Pack
  • Google Photos
  • Google Play
  • Google Plus
  • Google Reader
  • Google Sites
  • Google Suggest
  • Google Takeout
  • Google Talk
  • Google Toolbar
  • Google Translate
  • Google Trends
  • Google Voice
  • Google Wallet
  • Google+
  • googlenew
  • Greasemonkey
  • Guest Post
  • holiday
  • iGoogle
  • Image Search
  • images
  • InOut
  • iOS
  • Keep
  • Knowledge
  • mobile
  • OCR
  • offline
  • OneBox
  • paperless
  • pdfs
  • photo
  • photos
  • Picasa Web Albums
  • presentations
  • product ideas
  • profiles
  • quickoffice
  • Reddit
  • research
  • save to drive
  • scripts
  • Security
  • sharing
  • sheets
  • shortcut
  • slides
  • spell check
  • spreadsheets
  • stock photos
  • storage
  • students
  • tables
  • teachers
  • templates
  • Tips
  • User interface
  • videos
  • Viewer
  • Visualization
  • Voice Search
  • Web Search
  • Yahoo
  • YouTube

Blog Archive

  • ►  2013 (519)
    • ►  December (33)
    • ►  November (44)
    • ►  October (64)
    • ►  September (50)
    • ►  August (63)
    • ►  July (60)
    • ►  June (57)
    • ►  May (62)
    • ►  April (49)
    • ►  March (33)
    • ►  February (1)
    • ►  January (3)
  • ►  2012 (34)
    • ►  December (4)
    • ►  November (4)
    • ►  October (5)
    • ►  September (4)
    • ►  August (2)
    • ►  July (1)
    • ►  June (3)
    • ►  May (2)
    • ►  April (2)
    • ►  March (2)
    • ►  February (5)
  • ►  2011 (80)
    • ►  December (4)
    • ►  November (1)
    • ►  October (7)
    • ►  September (10)
    • ►  August (11)
    • ►  July (8)
    • ►  June (9)
    • ►  May (1)
    • ►  April (8)
    • ►  March (8)
    • ►  February (8)
    • ►  January (5)
  • ►  2010 (118)
    • ►  December (11)
    • ►  November (16)
    • ►  October (6)
    • ►  September (13)
    • ►  August (13)
    • ►  July (7)
    • ►  June (15)
    • ►  May (11)
    • ►  April (7)
    • ►  March (7)
    • ►  February (6)
    • ►  January (6)
  • ▼  2009 (82)
    • ►  December (14)
    • ►  November (4)
    • ▼  October (10)
      • Taking charge of your document sharing
      • Google Docs now more consistent
      • Data Liberation, "Mark as viewed", and New!
      • Spotlight: Great public templates in the template ...
      • Google Docs previews in Gmail
      • Shared folders and more in Google Docs
      • New features for drawings in Google Docs
      • Picasa Web Albums integration, site feeds, and pag...
      • Quickly view formatted PDFs in your search results
      • Translation functions in spreadsheets
    • ►  September (10)
    • ►  August (4)
    • ►  July (6)
    • ►  June (6)
    • ►  May (5)
    • ►  April (4)
    • ►  March (8)
    • ►  February (7)
    • ►  January (4)
  • ►  2008 (97)
    • ►  December (6)
    • ►  November (4)
    • ►  October (6)
    • ►  September (8)
    • ►  August (5)
    • ►  July (7)
    • ►  June (11)
    • ►  May (20)
    • ►  April (13)
    • ►  March (6)
    • ►  February (6)
    • ►  January (5)
  • ►  2007 (25)
    • ►  December (1)
    • ►  November (1)
    • ►  October (2)
    • ►  September (3)
    • ►  August (3)
    • ►  July (4)
    • ►  June (3)
    • ►  May (2)
    • ►  April (2)
    • ►  March (1)
    • ►  February (2)
    • ►  January (1)
  • ►  2006 (10)
    • ►  December (2)
    • ►  November (4)
    • ►  October (4)
Powered by Blogger.

About Me

Unknown
View my complete profile