How to translate an Excel document? (one cell, multiple cells, the entire document - without losing the format)

Do you get a document in Excel but in another language? Do you want to translate your content easily? Do you want to find a way to translate your entire excel document and not cell by cell ? I´ll show you how to do it in the simplest way I've found.

To translate a spreadsheet into excel in any language, we can use the online “DOC Translator” tool as it translates all excel cells and maintains its format. We can also use "Google Sheets" to translate the entire content of the spreadsheet.

Continue reading and I will show you how to do it step by step and what are the differences between “Doc translator” and “Google Sheets”.

How to translate an excel document in DOC TRANSLATOR?

Translating our document into Doc translator is a very fast and effective way, one of the advantages of translating our spreadsheet in this online application is that it translates the entire document with everything even formulas. It also maintains the same initial format of our Excel spreadsheet. A disadvantage may be that the text translation is not perfect because it is translated by a machine but still, the translation is good. 

1. The first thing we will do is to Open “DOC TRANSLATOR”
2. We click on “Translate Now”
3. We upload the Excel spreadsheet that we want to translate. 
   
4. We select the language to which we want to translate our spreadsheet and translate.
   
5. Finally we download our Excel document and review it.
   

Conclusion of using Doc Translator: It is a useful and fast online tool to translate our excel documents completely (whole).

How to translate an Excel document with Google sheets?

Translating an Excel sheet into Google Sheets requires installing an extension of "Add-ons", called "TRANSLATE MY SHEET" is free and easy to do. 

One of the advantages of installing this extension is that you can select one or multiple cells from your spreadsheet, as well as translate columns, you can also translate the entire document, which you cannot do with DOC translator. 

On the other hand, one of its disadvantages is that it does not translate formulas, and in fact if you try, the previous formula will be deleted. But don't worry so much because you can download the document and open it as an Excel sheet and the formulas will appear in the language that you have configured in your Excel program. (just do not try to translate formulas, just text).

As for the extension of google sheets, it is very good for translating texts. Here I show you how to do it step by step: 

1. First we will go to Google Sheets, we can find it by writing “Google Sheets” on google.
2. Then we will click on the “Add icon”, to add a new document.
3. In the menu in the “Add-ons” tab we click on “Get Add-ons”
   
4. Now we type in the search box “Translate my Sheet”and install the extension.
   
5. We accept the permissions required to install it.
6. Then we go to the “Add-ons” menu, then we go to “Translate my Sheet” and click on “Start a new translation” and the application will appear.
   
7. Finally we add the settings we want and that's it. If we want to download the document, we go to the “File” menu, then click on Download as> Microsoft Excel (.xlsx).
   

If you want to translate several columns at the same time, use the “CTRL” key and keep it pressed while selecting the cells, or to select many cells in the same row, use the “Shift” key (the icon with an up arrow) press the key while selecting with the cursor, the first and last cell you want in the same row.

Conclusion of using Google Sheets: It is very useful to translate fragments or cells separately at the same time and / or the entire document, but we have to install an application (add-on) within Google Sheets.

How to translate a spreadsheet in Microsoft Excel (.xlsx)?

If what we want is to translate our spreadsheet into the Microsoft Excel program, we can do it with its function integrated in the - Review menu - it is very easy to use.

One of the advantages is that it is very practical, if we want to translate few cells and know their content. One of the disadvantages is that you can only translate one cell at a time and only translate text. 

Here I show you how to open the excel translator and where to find it if it does not appear in the menu:

1. First we open "Microsoft Excel"
2. We go to the “Review” menu in the Language section, there is the application of “Translate” and  we  click it.
   
3. Then we select the cell we want to translate and configure the language to which we want to translate the information.

If you do not find in the Excel menu, the tool "Translate", do the following:

1. Let's go to the icon "Customize Toolbar Quick Access"
2. click on "more commands"
   
3. Then click on the menu "commands available in" a drop-down menu will open and we ́ll select the “Review tab”.
   
4. We click on "Translate" and “Add, and accept”.
5. Now we will see the quick access of the Excel translate tool at the top of the document in the Left corner. And that's it.
   

We already have our translation tool visible in Excel ready to use. As a note, in the new versions of Microsoft Excel it has a store section where you can download translators for excel as “Translator” from Microsoft that may be more useful than this tool.

But if you only have the versions of 2010, 2007 and earlier you will not have the option of entering the Microsoft Excel online store. These are some of the best ways to automatically translate our spreadsheets from Excel documents.

Conclusion of translating with Microsoft Excel: It is a simple way to translate Excel cells in versions 2010 and earlier, but we must translate them one by one, and it is not suitable to translate a complete document, but in the new versions of Microsoft Excel it is possible that there may be Applications that have been developed in the Microsoft store that translate the entire document (to translate text). If not, don't worry we can use our two great tools, “Doc translator and Google Sheets”.