WPS Spreadsheets translation add-in
In WPS Spreadsheets sidebar for full-sheet, selection and selected-text translation across all worksheets. After translation, use Table display to switch between Translation, Bilingual and Original. You can also set the Translation font while preserving formulas and number formats as far as possible.
Free download · Same installer as the Excel add-in · No exporting and pasting back
For whole-sheet WPS translation with formatting preserved, open the current worksheet and translate its text cells in one pass. For just one area, select a rectangle and use Selection Translation.
Download and install the WPS Spreadsheets translation add-in
The installer is shared with the Excel translation add-in、WPS translation add-in — one download covers them all.
- Completely close WPS Spreadsheets, WPS Writer, Excel and Word before installing
- Download and run the TopCopilot installer. It automatically matches 32/64-bit systems and usually requires no administrator privileges
- Open WPS Spreadsheets, click the AI Assistant tab in the ribbon, open the sidebar and sign in
- Choose full-sheet or selection translation, set the target language, and start translating
What you can do in WPS Spreadsheets
The same core tools as the Excel sidebar: whole-sheet WPS translation with layout preserved, selection translation and selected-text translation. Enable Translate All Worksheets to process all visible sheets. After translation, Spreadsheet Display switches betweenTranslation, Bilingual and Original; advanced settings let you choose a translation font while leaving formula columns unchanged where possible.
Translation font
Choose a translation font in advanced settings; by default, it follows the original. Specify a font when you need to standardize on Microsoft YaHei, SimSun, Arial, or another font.
Also works in WPS Writer
The same installer supports whole-document, selection and selected-text translation in WPS Writer, with no separate Writer download.
Copying to a website vs the WPS Spreadsheets sidebar
Copying a whole WPS sheet into a translation website can turn formulas into text and disrupt column widths. The sidebar reads and writes cell by cell, modifying only text cells.
| Aspect | Copy-and-paste translation | WPS Spreadsheets translation add-in |
|---|---|---|
| Batch full-sheet translation | Often requires copying a range to a translation website and pasting it back into WPS Spreadsheets | Whole-sheet translation writes back cell by cell, reducing column misalignment |
| Translate just one area | No consistent workflow for translating only a selected rectangle | Selection translation processes only the selected rectangle, leaving other cells unchanged |
| Comparing after translation | The original is overwritten, or you must add a comparison column yourself | Table display switches between Translation, Bilingual and Original without translating again |
| Translation font | Pasting often resets fonts or creates inconsistent formatting | Choose a translation font in advanced settings; follows the original by default |
| Formulas and numbers | Pasting can turn formulas into text and reset number formats | Formula cells are skipped where possible; number and date formats are preserved |
| Installer | — | One Windows installer shared with Excel, Word and WPS Writer |
Frequently asked questions
Are the WPS Spreadsheets and Excel translation add-ins separate programs?
No. The same TopCopilot Windows installer adds an AI Assistant tab to both WPS Spreadsheets and Microsoft Excel. Both product pages provide the same installer.
How do I download and install the WPS Spreadsheets translation add-in?
Close WPS, then download and run the installer from this page or the official download page. Open WPS Spreadsheets 2023 or later, open the sidebar from the AI Assistant tab and sign in to translate whole sheets or selections.
How do I translate a rectangular selection in WPS Spreadsheets?
Select the cells you want to translate, such as a product-name column or a block of notes. Choose Selection Translation in the sidebar, set the target language and start. Cells outside the selection stay unchanged; leave formula columns outside the selection to exclude them.
Can I view the original and translation together afterward?
Yes. Table display in the sidebar offers Translation (translated text only), Bilingual (original above translation in the same cell), and Original (restore the pre-translation content). Switch at any time without translating again. Translations are not written into cell comments.
Can I choose the translation font?
Yes. Click the gear beside the target language and choose Translation font. The default is Automatic (follow original); you can also specify Microsoft YaHei, SimSun, Arial or another font to use when writing back translations.
Can translation damage formulas?
Whole-sheet translation tries to recognize and skip formula cells; selection translation lets you select only text columns. Check important formulas such as SUM and VLOOKUP afterward. Translation formulas such as TRANSLATE or GOOGLETRANSLATE can also be used in a separate column.
Can I use this add-in in WPS Writer too?
Yes. The same installation adds an AI Assistant sidebar to WPS Writer for whole-document, selection and selected-text translation. See the WPS translation add-in overview for details.
What if I do not have a Windows computer?
Use online Excel translation: upload an .xlsx file and download the translated workbook. Formula and numeric cells are skipped. It works in Mac and mobile browsers.
How do I translate Japanese or English into Chinese in WPS Spreadsheets, or Chinese into English?
Choose Whole-Sheet Translation and set the target to Simplified Chinese to translate Japanese and English cells together. Choose English to translate Chinese content into English. Mixed source languages can be handled in the same sheet.
On a Mac or translating occasionally? Try the web app
Translate spreadsheets or convert tables in images and PDFs to xlsx without installing an add-in.
Online Word document translation
Upload .docx and download the AI translation, preserving the original layout where possible.
Learn more →Online Excel spreadsheet translation
Upload .xlsx to translate cell by cell while preserving formulas and workbook structure.
Learn more →Online image translation
Translate screenshots and photos: upload or paste an image with text, then generate and download a translated image.
Learn more →English grammar analysis
Enter a long, complex English sentence to label its subject, predicate, object, attributive, adverbial, complement, clauses, tense and voice.
Learn more →Image to Word online
Turn screenshots and scans into editable .docx files while preserving the original formatting and illustrations where possible.
Learn more →Image to Excel online
Turn table screenshots, pasted images and photos into editable .xlsx files.
Learn more →PDF to Excel online
Turn bank statements, quotes and scans into editable .xlsx files.
Learn more →Online PDF translation
Powered by Tencent Hunyuan Hy-MT2-Pro. Upload a PDF with a text layer and download bilingual and translation-only PDFs, preserving the original layout where possible.
Learn more →Download the WPS Spreadsheets translation add-in
Windows with WPS Spreadsheets 2023 or later. After installation, open the sidebar from the AI Assistant tab. Supports bilingual comparison and translation font settings.