How to batch Chinese-English translation in Excel tables_Tutorial sharing on batch Chinese-English translation in Excel

Encountered the need to translate a large amount of text content in Excel tables from Chinese to English? PHP editor Banana has specially compiled a detailed tutorial on this task to help you easily implement batch Chinese-English translation in Excel and say goodbye to tedious manual operations. Come and find out, let you deal with translation work efficiently from now on!

1. Open the Excel document that needs to be translated, and add a column to place the corresponding translated English content.

2. Enter the formula in the first column: =FILTERXML(WEBSERVICE("http://fanyi.youdao.com/translate?&i="&A2&"&doctype=xml&version "),"//translation")

(You can copy it directly, but please note that the cells must correspond).

3. After entering the formula, click [Enter] to confirm. You can see that after the translation is performed directly through Youdao, the translation result is entered into the specified cell.

4. After the above is successful, the contents of the corresponding column can be translated in batches just like ordinary drop-down cells.

The above is the detailed content of How to batch Chinese-English translation in Excel tables_Tutorial sharing on batch Chinese-English translation in Excel. For more information, please follow other related articles on the PHP Chinese website!