00:00 Select Translate
From the Home ribbon selecting translate will enable you to export or import your desired translation(s) into your existing project.
00:03 Select Export Translation File(s)
00:08 Select the Languages selection box
00:12 Type: french and press Enter
Type in the language for which you wish to translate the project.
00:17 Select French - France : Francais - France (fr-FR)
Select the desired language from the search results.
00:22 Click on Export
You can search for additional languages if you wish to create multiple translation exports. For Google Translate, leave the file format set to Excel. In many cases you can turn off the Page Preview Links and Authoring Metadata, as they are typically not needed in an automatic translation.
00:24 The selected language(s) will download.
If you selected multiple languages you will need to unzip the package before uploading the files for translation.
00:00 Press button: Show Translator for Excel
This will launch the Sheets Translator application in the right panel.
00:06 Click on the drop down arrow in the Original language selector box.
You can keep the Auto Detect, but if you want to be sure, switch to the base language.
00:11 Selected list item: English
00:15 Click on the drop down arrow in the Target language selector box.
00:19 Click on the scroll bar, or drag until the desired language is available.
All the target languages are written in the target language. In this example we are looking for German, but spelled Deutsch.
00:30 Finish drag and drop when Deutsch is present
00:34 Selected list item: Deutsch
This is German.
00:37 Click on the down arrow in the Translate selected column.
00:44 Click on Add a column option.
This will provide a translated column you can copy from and then simply remove.
00:47 Click on Start Translating
00:49 The translation will begin to process.
00:53 Click F3
In the newly created column select the first translated cell.
00:56 Press button: Page down
Scroll down to the bottom of the document.
01:01 Click on F329 with modifiers: Shift
This will select all the translated text in the column.
01:05 Press Ctrl + c
To copy the contents to your clipboard.
01:13 Press Ctrl + v
This will paste all of the translations into the correct column.
01:17 The translated text is now in the correct location.
01:21 Click on F column.
You are now going to remove the extra column.
01:26 Select menu item: Delete
01:30 Repeat these steps for any other Sheets.
In most exports there will be additional Excel sheets for other elements such as pop ups, variables, and glossaries. Repeat these same steps for the remaining elements which will require translation.
00:00 Click on Translate in the Home Ribbon
00:04 Click on Import Translation File(s)
00:09 Select text field: 20250404045512_Protecting_Information_Security_and_Privacy_(102998)_fr-FR.xlsx
If you have translated your project into multiple languages, first select all the translated files and then zip the file and use the zipped file in this step.
00:16 Click on Done.
The updated project will open when done.
00:21 Click on Preview -> Compare
This will open a full project preview with a side by side preview.
00:26 In the preview on the left, use the language selector and click on French - France
This will change the project view on the left to use the French translation.
00:31 Steps completed
While you don't need to use the Compare preview, it does provide a handy side by side view when you need to see a direct comparison between two languages.
Confirm
Comments ( 0 )
Sign in to join the discussion.