Today, we will explore the 4 best ways to translate an Excel spreadsheet file.
Method 1: Translate Excel file natively with Microsoft Translator
First, open your Excel spreadsheet and select the text you wish to translate. Then, on the toolbar, select Review > Translate.
The translator menu will appear on the right, where you can set the source language and the target language.
Keep in mind that the translation will only appear on the menu. It does not automatically replace the original text in the Excel file. To prompt this, you must click Insert or manually copy-paste the translated segments into their respective cells.
- Excel’s translator is a machine translation tool (read more about the best machine translation software), which is prone to errors and inconsistent tone. As such, the translated copy is often not suitable for professional use.
- This method requires a lot of manual work involving copy-pasting. If you have a massive Excel workbook to translate, there are better options for you further down this list.
- Only suitable if you want to translate a text for your personal reading and understanding
- The built-in translator in Excel does not preserve the functions and formulas affecting the textual makeup of different cells. However, if you are an advanced Excel user, you can do this by downloading the Functions Translator add-in. This tool will give you access to a categorized list of English functions and their corresponding functions in other languages.
Method 2: Upload the Excel spreadsheet to Google Translate
Is it even a complete translation guide if I didn’t mention Google Translate? Shout-out to all things that are fast and free.
Visit Google Translate on your browser and click on the Documents tab.
You know the drill after that… select your source language and target language. Then, upload your Excel spreadsheet. This method works for both .xls and .xlsx files.
- Translations generated by Google Translate must be reviewed and edited for accuracy and consistency. That’s why businesses generally do not accept Google translations for work purposes.
- The translated copy can only be viewed on your browser and cannot be downloaded as an Excel file. You would need to transfer the text to a new Excel sheet manually.
- Free translation platforms present certain risks, such as data leakage. Never upload documents with sensitive information onto these sites because you can never be certain where they will end up.
- Only suitable if you want to translate a text for your personal reading and understanding (this method can be used when translating pdf documents as well).
If curious to learn more - here are some eye-opening machine translation statistics and even more - here is a detailed guide about how MT has come so far.
Method 3: Use a professional translation software
Using professional translation software like Redokun is more cost-effective because it employs both human and artificial intelligence in translating Excel files. These are commonly known as computer-assisted translation (CAT) tools, whereby the software helps speed up the translation process in many ways.
How exactly does this work, you ask? With cloud-based translation tools like Redokun, you and your team can
- Translate versatile documents such as all the Office documents, subtitles, XML documents, html files and even InDesign.
- Create and track multiple translation projects simultaneously.
- Collaborate remotely with internal or external team members.
- Create, store, and access frequently used terminologies for more efficient and consistent translations. Read this detailed 101 Translation Memories guide or dive a bit deeper by reading how this type of feature can directly help you achieve greater productivity.
- Save 99.98% in translation costs by reducing the translator’s workload.
- Preserve the formatting of your Excel documents. Styles, lists, charts – leave all these details to the translation software.
- Send revised documents to your translator without disrupting completed translations. This comes in handy when you need to make minor changes to the original Excel spreadsheet when the translation project is still ongoing.
Microsoft Excel may be difficult to use for some people, but Redokun is not! You won’t need to spend extra time or money on training your people to use our translation tool.
If you want to learn more about translation software, I've also written a detailed guide here. You can also read about their features, benefits, or even how to choose a translation software.
- Most dedicated translation tools are subscription-based. If you’re not ready to make a commitment, you can make use of free trials to see whether you’re comfortable with the software. In fact, you can click here to try Redokun for free today! No credit card required.
A Quick Overview
Now for the most important question: which Excel translation method should you choose? If you need to distribute the translated document to an important stakeholder, like a potential customer or a business partner, the best choice is to use a professional translation tool like Redokun (here is a list with the best translation software in 2021 and how to choose a tms that suits your needs).
Moreover, the copy you send to your stakeholders must also be properly formatted. The right translation software should take care of that. Here is a summary of the four ways to translate an Excel file:
Till next time,