To translate French into English in Google Sheets, enter a source phrase in a cell and use the GOOGLETRANSLATE function: with French text in A2, enter =GOOGLETRANSLATE(A2,"fr","en") in B2. Sheets returns an English translation, and you can fill the formula down to translate more rows.
The quickest way to translate French to English
Google Sheets can translate text through a built-in spreadsheet function rather than a separate translation column in another application. The basic pattern is to give the function the text to translate, the source language, and the target language. For French to English, the language codes are fr and en.
- Put the French text in a cell, such as A2.
- Select the cell where you want the English result, such as B2.
- Type
=GOOGLETRANSLATE(A2,"fr","en")and press Enter. - To translate additional rows, select B2 and drag its small fill handle down the column, or copy and paste the formula into the cells below.
With the French word “Bonjour” in A2, the example formula returns “Hello.” The cell reference adjusts as the formula is filled down: in the next row, it will refer to A3. Keep the source and translated text in separate columns so the original remains available for review.
How GOOGLETRANSLATE works
GOOGLETRANSLATE is a Google Sheets function that requests a translation of the supplied text. Its general form is GOOGLETRANSLATE(text, [source_language, target_language]). The square brackets in the description mean those language arguments can be omitted; they are not characters to type into the formula.
For predictable results, specify both language codes. With French text in A2 and the English result intended for B2, use =GOOGLETRANSLATE(A2,"fr","en"). Stating the source language makes the instruction explicit and avoids asking the service to identify it automatically. If you have a mixed-language source column, automatic detection may be useful; it is not a substitute for checking that the detected language is right.
The function returns translated text, not a bilingual dictionary entry or a guarantee that the wording is suitable for publication. A short expression may have several valid translations depending on context, audience, and tone. For example, a French word that can mean either “light” or “lamp” may need a full sentence to make its intended sense clear.
Language codes and automatic detection
Language arguments use short language identifiers. For this task, use fr for French and en for English. If you do not know the source language, Google Sheets supports auto as the source-language argument. With text in A2 and an English translation in B2, the automatic-detection version is =GOOGLETRANSLATE(A2,"auto","en").
Automatic detection can help when a list contains several languages, but it can be less dependable for a single short word, a name, a typo, or a phrase that resembles more than one language. It may also choose a language you did not intend when text contains only a few characters. If the source column is known to be French, specifying fr is generally the clearer setup.
Language identifiers are not the same thing as a country or regional setting. A simple fr identifies French, but it does not tell the function whether the text is from France, Canada, Belgium, or another French-speaking region. Where regional vocabulary matters, include context in the source text and review the output with a speaker familiar with the intended audience.
Translating a whole column
For a modest list, put one source phrase per row and fill the translation formula down beside it. A practical layout is column A for the original French, column B for the English translation, and an optional column C for a reviewer’s correction or notes. Add clear headers, such as “French source” and “English draft,” so other people know which values are original and which are machine-generated.
Before filling formulas down a long sheet, check a few varied rows first. Include a complete sentence, a short phrase, punctuation, and any terminology that matters. This can reveal an issue with the source data or language direction before the same mistake is copied throughout the column.
When you copy a formula down, ordinary cell references move with each row. If a formula in B2 refers to A2, the copied formula in B3 refers to A3. For a small set of entries, this is usually the simplest workflow. For a larger list, divide the work into sensible sections and review the output as it appears rather than assuming every row translated successfully.
Blank source cells may not be useful to translate, so it can help to keep them out of the input range or handle blanks deliberately. If you later sort or filter the table, include the original and translated columns together; otherwise, the two versions can become detached and make the results difficult to interpret.
Checking translation quality
Automatic translation is useful for understanding a message, creating a first draft, or working through a list of routine phrases. It should not be treated as proof that the translation is complete or appropriate. Machine translation can miss tone, implied meaning, wordplay, technical definitions, and cultural references even when the English sentence looks fluent.
Review carefully when the material includes instructions, product claims, medical information, legal terms, financial wording, or public-facing copy. For high-stakes or polished content, ask a qualified human translator or an appropriate subject-matter reviewer to check both the source and the translation. A reviewer needs the original French because a smooth English sentence can still represent the wrong interpretation.
- Check names and specialist terms: Brand names, abbreviations, and industry vocabulary may be translated, left unchanged, or interpreted incorrectly.
- Read the surrounding context: A phrase may be ambiguous when separated from the sentence or conversation it came from.
- Watch for formality and audience: French and English forms of address and tone do not always map neatly onto one another.
- Preserve the source: Keep an unchanged copy of the French so errors can be traced and corrected.
- Review numbers and formatting: Translation does not replace a separate check of amounts, dates, units, or other critical data.
For a spreadsheet that will be shared as a final deliverable, consider copying reviewed translations and pasting them as values into a separate output area. That makes the approved wording easier to preserve if the source data changes. Keep a copy of the formula-driven version if you may need to regenerate drafts later.
Common problems and how to address them
If a formula is rejected, first check that the function name is spelled GOOGLETRANSLATE, that the text cell reference exists, and that the quotation marks around language codes are straight double quotes. Also confirm that the formula begins with an equals sign. A pasted formula can fail if punctuation was changed by a word processor or if a cell was formatted as plain text before the formula was entered.
Spreadsheet locale settings can affect how formulas are entered. Google Sheets commonly uses commas between function arguments, but some locales use semicolons. If the comma version is rejected, check the spreadsheet’s locale under File > Settings and use the argument separator expected by that sheet. This is a locale difference, not a change to the language codes.
If the result is not in English, verify the order of the source and target arguments: the second language argument is the target. For French-to-English translation, that means "fr","en", not "en","fr". If a phrase looks wrong, check the source spelling and surrounding context, then try a complete sentence rather than an isolated word.
For a cell that displays an error or an unexpected result, try a short, ordinary French sentence in a new row. If that works, the original entry may contain an unusual character, ambiguous wording, or a data issue. Avoid repeatedly editing the entire sheet before testing one example; a small check helps separate a formula problem from a translation-quality problem.
Google Sheets compared with other options
Google Sheets is convenient when the phrases already live in a spreadsheet and you want results aligned row by row. The function can be copied, shared with collaborators, and used alongside sorting or filtering. A dedicated translation application may be easier for a person translating a document line by line, while a professional translation workflow may offer review, terminology management, or approval steps that a basic sheet does not provide.
Google Sheets is not Microsoft Excel. Excel does not provide Google Sheets’ GOOGLETRANSLATE function as a standard worksheet function, so a formula copied from Sheets should not be expected to work in Excel. If a workbook must operate in Excel, choose an available translation service or workflow supported by that environment rather than assuming the function is portable.
Google Translate’s website is another option for one-off phrases or text that does not need to be organized in rows. A human translator is preferable when nuance, audience, confidentiality requirements, or consequences of an error make review essential. The right choice depends on whether the goal is quick comprehension, a working draft, or approved final copy.
Cost, access, and privacy considerations
For ordinary spreadsheet use, GOOGLETRANSLATE is available as a Google Sheets function, and there is no separate price displayed for each formula result inside the sheet. Access to Google Sheets and account or Workspace features can depend on the account and organization. Administrators may also set policies that affect which services are available, so work or school users should follow their organization’s guidance rather than assume every account has identical settings.
Consider the sensitivity of the text before using an online translation function. Treat the content as being processed by Google’s translation service, and check the applicable Google account terms and organization policies if the text is confidential, personal, regulated, or commercially sensitive. Do not use a spreadsheet formula to bypass a workplace rule against sending particular information to an external service.
For public or low-risk phrases, a spreadsheet can be an efficient drafting aid. For private customer details or confidential documents, ask the data owner or administrator what tools are approved. Removing names or other identifying information may reduce exposure, but it does not automatically make every dataset safe to share.
Frequently Asked Questions
Can Google Sheets translate French to English automatically?
Yes. Use GOOGLETRANSLATE with French as the source and English as the target. For French text in A2, enter =GOOGLETRANSLATE(A2,"fr","en") in the result cell.
What is the formula for French to English in Google Sheets?
With the French phrase in A2 and the translation wanted in B2, use =GOOGLETRANSLATE(A2,"fr","en"). The function returns an English translation of the text in A2.
Can I translate many rows at once?
Yes. Put a formula beside the first source row, then drag its fill handle down or copy it into the rows below. Check that each translated result remains aligned with its original French entry.
Can Google Sheets detect the source language?
Yes. Use auto as the source-language argument, for example =GOOGLETRANSLATE(A2,"auto","en"). Detection may be less reliable for short, misspelled, or ambiguous text than for a full sentence.
Does the Google Sheets translation formula work in Excel?
No. GOOGLETRANSLATE is a Google Sheets function, not a standard Excel worksheet function. Use a translation option supported by the spreadsheet program you plan to use.