Bonjour, guten tag and buenos dias, Google Forms!How to display a Google Form in a particular language

Google Forms are one of the lesser-known and more powerful features of Google Docs. They let you capture data from your users in a Google Spreadsheet, via simple web-based forms that can stand on their own or sit embedded in a web page. Like this:

Now, suppose you need to create that form in, say, English and French. Not hard: two forms, two spreadsheets, and you're done. But when you look at the French version, the questions may be in French but all of the interface text is still in English:

Here's how you fix that: just change the URL for the form by adding a parameter for the language you want the form to appear in... in our case, "fr" for French.

This is the original embed code that Google creates for the form:


<iframe src="http://spreadsheets.google.com/embeddedform?key=pnY7RN2L8C5h3PQUcS0RKIg"
width="310" height="455" frameborder="0" marginheight="0"
marginwidth="0">Loading...</iframe>

Change that source URL to read http://spreadsheets.google.com/embeddedform?key=pnY7RN2L8C5h3PQUcS0RKIg&hl=fr. Adding &hl=fr is all it takes:

You can find a list of codes for each of the languages Google supports here, from Afrikaans (af) to Zulu (zu).

Comments

Anonymous says

March 8, 2010 - 2:56pm

Hi, thanks for the tip... unfortunately it doesn't look like it's working right now. Your forms above still features an English language interface. Is it because Google can tell I am browsing in English? Or have they changed how this works?

Thanks,

Helen

Anonymous says

March 8, 2010 - 2:57pm

Hmm... wait, it seems to work in IE, just not in Firefox. Weird. (Annoying.)

Thanks for posting this.

Leave a comment

The content of this field is kept private and will not be shown publicly.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <p> <b> <i> <br> <blockquote> <img> <object> <embed> <iframe> <h2> <h3> <h4> <h5> <style> <br> <table> <td> <tr> <xmp> <del> <span> <s> <fieldset> <legend> <h6> <div> <form> <input>
  • Lines and paragraphs break automatically.
Bookmark and Share

Join Newsletter

Rob on Twitter