How to batch translate multiple Excel tables into Chinese

Key points of this article

It is recommended to upload multiple Excel tables one by one and use the same set of settings instead of merging them into one file.
Unify into .xlsx format before translation, first list the proper nouns and abbreviations to be unified.
Choose bilingual comparison or only translation according to the purpose: use bilingual for checking yourself, use only translation when sending to others.
Check formulas, references, numbers and units after translation, machine translation results require manual review.
The results are saved according to the original file name and number to facilitate subsequent search and comparison.

I have a batch of English Excel tables in my hand, such as several months of sales reports, supplier quotations, or experimental data records. I need to translate them into Chinese, but I don’t want to manually change the cells one by one. Many people search for "excel batch translation to Chinese". In fact, what they want to solve is two things: how to process multiple files in sequence, and whether the structure, formulas and numbers of the translated table can be preserved.

This article is written for office workers, finance and researchers who need to work with multiple Excel files. After reading, you will know how to translate Excel tables one by one in OmniDoc, how to unify settings to make the translation style consistent, and what to check before delivery.

This article talks about the method of "uploading one by one and repeating the same set of settings". OmniDoc supports Excel (.xlsx) document translation. The output can be bilingual or translated only, and the table structure will be retained.

How to translate multiple Excel tables into Chinese? One sentence conclusion

Treat each table as a separate file, upload translations one by one with the same set of settings, and archive the results under the original file name. Don't merge multiple tables into one workbook to save trouble. After merging, the original worksheet names, reference relationships, and division of labor can easily be messed up.

your situation	Recommended practices	reason
There are not many tables, and the content is mainly text explanations.	Upload one by one, select only translations	The translation can be delivered directly and the operation is simple
Need to check with the original text	Choose bilingual comparison	The original text and the translated text are side by side, making it easy to find errors.
There are a lot of formulas and cross-table references in the table	Focus on checking formulas after translation	Table names and cell references in the translation need to be confirmed not to have been changed.
Multiple tables come from different sources and terminology is inconsistent	Organize the glossary first and then unify it	The same word must be translated consistently in different tables so that it can be read coherently
Table content is embedded as an image	First confirm whether the text can be selected	The text in the picture may not be translated normally and needs to be processed separately.

Before you start: Confirm these points first

Spending a few minutes tidying up before starting can reduce rework later.

Unified file format. OmniDoc's Excel translation object is .xlsx file. If you have the old .xls format, use Excel to save it as .xlsx before uploading. This way the file type will be the same and you won’t have to switch settings repeatedly.
Clean up useless content. Delete blank worksheets, temporary draft pages and obsolete data to avoid a large amount of meaningless content that needs to be checked after translation.
List proper nouns. If the company name, product model, personal name and abbreviation appear repeatedly in multiple tables, first write a small table to clarify which ones should be retained in the original text and which ones need to be translated into Chinese. This ensures that the same term is translated consistently across documents.
Determine whether the form is sensitive. Before uploading data such as contract amount, customer list, and employee salary, please confirm whether it is suitable for online processing. When sensitive data is involved, consider using a desktop client and comply with the confidentiality requirements of the company or unit.
Determine the purpose of the translation. Reading by yourself, reporting to leaders and sending to external parties have different requirements for translation. The purpose determines whether you choose bilingual comparison or translation only, and how carefully you need to check.

Steps to translate Excel tables one by one in OmniDoc

The following takes a set of 5 English quotation tables as an example to explain how to process them one by one and keep the settings unified.

Gather files into a folder. Place the .xlsx files that need to be translated in the same folder, and the file names are numbered in sequence, such as "01_Quotation_East China.xlsx" to facilitate subsequent correspondence.
Open the translation portal. Upload on the omnidoc.top web page, or use the desktop client (download.omnidoc.top). Both methods operate according to the process of a single file.
Upload the first file. Select the Excel file, confirm it is in .xlsx format, and wait for the file to load.
Confirm that the target language is Chinese. Check your target language settings to make sure you are translating to Chinese instead of keeping English or translating to another language.
Select the output method and style. Select bilingual comparison when verification is required, and select translation only when only translation is delivered. The business style can be selected for quotation and financial content, and the technical style can be selected for technical parameters, and they should be consistent in this batch of documents.
Start translation and download the results. Wait for the processing to be completed to download the translation file, and change the name immediately after downloading, for example, "01_Quotation_East China_Chinese.xlsx".
Repeat steps 3 to 6 for the next file. Use the same set of output methods and styles for each file. Do not change the settings midway, otherwise the styles of the same batch of results will be inconsistent.
Centralized archiving. Put all the translations into a new folder, correspond one-to-one with the original files, and then enter the verification link below.

Check each item after completion

Both machine translation and form processing require manual review. It is recommended to go through the following check items one by one, and be sure to check important contents.

Check items	How to see	What to do if there is a problem
Worksheet number and name	Compare the original file to see if each worksheet is present and the order is normal.	If the worksheet is missing, go back to the original file to confirm whether it has been deleted before translation, and re-translate if necessary.
Formulas and references	Click on a few cells with formulas to see if the calculation results are consistent with the original file	When the formula result is incorrect, check whether any cell references have been changed and manually correct it before delivery.
Numbers, dates and units	Compare amount, percentage, date and unit item by item, such as USD, kg	If there are numerical errors, please refer directly to the original document for correction. Do not rely on the numbers in the translation.
proper noun	Check the translation of the company name, model, and abbreviation against the glossary.	Replace any inconsistencies and go back to check whether other files also need to be changed.
cell format	Check whether the table header, merged cells, borders and column widths remain the same	When the format is messed up, you can compare the translation and the original file side by side and adjust them manually.
Translation fluency	Check a few long paragraphs to see if the sentences are fluent and the meaning is accurate.	Machine translation may cause mistranslations, and key content must be rewritten manually rather than delivered directly.

After the verification is completed, mark "Verified" in the translation file name, or put a verification record in the archive folder so that other people in the team can take over.

❓ Frequently Asked Questions (FAQ)

1. Can multiple files be selected for translation at the same time?

The method introduced in this article is to upload files one by one and repeat the operation with the same set of settings. After each file is processed, the results are downloaded and renamed before starting the next one. In this way, the settings of each file are clear, and it is easy to locate when errors occur.

2. Can tables in the old .xls format be directly translated?

It is recommended to use Excel to save as .xlsx before uploading. OmniDoc's Excel translation targets .xlsx. After unifying the format, multiple files will be processed in the same way.

3. Will the formula be lost after translation?

The translation process preserves the formulas in the table, but the translation still needs to be checked. Focus on cross-table references and formula results with text, and confirm that the calculation results are consistent with the original documents before delivering them.

4. Do the numbers and dates in the translation need to be changed?

Numbers, dates and units must be verified against the original documents. If there are format changes in the translation, such as different date writing or unit symbols, they should be changed back to be consistent with the original file to avoid misinterpretation of the data.

5. Why is it not recommended to merge multiple tables into one file and then translate them?

After merging, the division of labor between worksheet names, cross-table references and files may be disrupted, and the difficulty of verification will be greatly increased. Processing and filing each form one by one makes it easier to ensure the integrity of each form.

📝 Summary

To batch translate multiple Excel tables into Chinese, the key is to upload them one by one, set them uniformly, file them according to the original file names, and check formulas, numbers, and proper nouns before delivery. Organizing the format and terminology before translating can save a lot of rework time.

Open OmniDoc, upload the document and start translation