OmniDocHow to translate Excel with many worksheets: separate processing by worksheet
When an Excel workbook has multiple worksheets, first determine which tables can be translated as a whole and which ones need to be split, then upload them one by one on OmniDoc and check the table names, numbers and formulas.
Key points of this article
- If there are no cross-sheet formulas between worksheets, but only text descriptions, you can upload the translation of the entire work, and then read it one by one after translation.
- If there are cross-sheet formulas or summary tables, back them up first, then save each worksheet as an independent .xlsx file and translate them one by one.
- When you only need a few of the sheets, copy them to a new workbook first to avoid translating irrelevant content.
- After translation, first check the number and names of worksheets, then spot-check numbers, units and cells with formulas, and finally unify terminology.
When there are more than a dozen worksheets in a workbook, many people subconsciously throw the entire workbook into the translation tool. As a result, there are three common types of problems: the table name has been changed, the references of cross-table formulas are misplaced, and the translation of a certain table does not match the original text. Readers who search for "Where is the Excel translation batch" are probably in the same situation: they want to process many tables at once, but don't know where to start.
This article only talks about multiple worksheets in one workbook: when can the entire work be translated, when should it be disassembled first, how to upload one by one on OmniDoc, and how to check table by table after getting the results. If you have multiple independent Excel files and need to process multiple files at one time, that is another problem that will not be discussed in this article.
After reading this article, you can first determine which type your form belongs to, and then follow the steps to complete the translation and verification.
How to translate Excel with multiple worksheets? One sentence conclusion
If there are no formula dependencies between worksheets and are mainly text explanations, the entire work can be uploaded; if there are cross-sheet formulas that require separate proofreading or different terminology requirements, they should be split into independent files first and then translated one by one.
| your situation | Recommended practices | reason |
|---|---|---|
| Each worksheet is a text description or list, and there are no cross-sheet formulas. | Upload the entire book and translate it at once | The structure is simple, just read it table by table after translation |
| There are formula references or summary tables between worksheets | Back it up first, then split it into independent files and translate them one by one. | When the table name or reference is changed, it is easier to locate the problem |
| Only a few of the tables are needed | Copy the required tables to a new workbook and then upload it | Irrelevant content does not need to be translated, and the file size is smaller |
| Legal, medical, academic and other professional content | Select the corresponding text style and ask a professional to check it after translation | The accuracy of professional terminology requires manual inspection |
| There are more charts or pictures in the table | First confirm the correspondence between the chart and the text, and then decide on the splitting method | After translation, check whether the diagrams, titles, and descriptions still correspond to each other. |
Before you start: Confirm these points first
1. Back up the original file first. Translation generates a new file, and the original file will not be changed, but splitting and subsequent modifications will produce copies. Keep an original copy so you can go back to the starting point and start over if something goes wrong.
2. Confirm the format is .xlsx. OmniDoc supports Excel file translation. If you have an older .xls file, save it as .xlsx in your desktop office software and then upload it.
3. Check formulas and cross-table references. Open the worksheets one by one to see if there are formulas in the cells that reference other tables, for example, a summary table references a cell in the detail table. This type of reference is prone to errors after the table name changes, so write it down in advance.
4. Decide which tables need to be translated. For example, for a budget table with 12 worksheets, only the "Description" and "Abstract" pages may need to be translated, and the data page can retain the numbers and English codes. Making a list first can reduce unnecessary translation and checking work.
5. Confirm the purpose of the translation. If it is only for internal reference, just read the translation first; if it is to be submitted or used externally, it must be manually checked item by item before submission.
Steps to translate multiple worksheets Excel in OmniDoc
- Decide on the approach. According to the judgment in the previous section, the entire translation will go directly to the next step; if it needs to be split, first use desktop office software to copy each worksheet to a new workbook, and save each table as an .xlsx file.
- Upload files. Open omnidoc.top and upload the .xlsx file to be translated. One file is processed at a time, and the split files are uploaded one by one in order.
- Select the output method. Select bilingual comparison to facilitate comparison of the original text frame by frame; select translation only for direct use in the final version.
- Select text style. Choose academic, legal, medical, technical, business or literary styles based on the content; if the same term appears repeatedly in multiple tables, pay attention to the settings related to terminology consistency.
- Start translation and download. After waiting for completion, download the result file and put it in the same folder as the original file for easy comparison.
- The structure of the checklist. Open the result file and first check whether the number and name of the worksheets are consistent with the original file. If there are any gaps, return to the original file and process it again.
- Compare the original text table by table. Focus on the title row, numbers, units, and the location of cells with formulas.
- Merge or save. If it is split, use desktop office software to copy each translation back to the same workbook in the original order, save it as a new file, and keep the original backup intact.
Check each item after completion
| Check items | How to see | What if there's a problem? |
|---|---|---|
| Number and name of worksheet | Compare the worksheet label at the bottom of the original file | Change the table name back to its original name when it is changed, and check the formula that references it |
| Numbers, dates and units | Spot check whether the amount, date and percentage are consistent with the original table. | The number should not be translated and changed. If there is any deviation, go back to the original table and correct it manually. |
| Formulas and references | Click on several cells with formulas to see if the result is the same as the original file. | Re-establish the reference if the reference is misplaced, or keep the original table formula |
| Headers and classification words | Check whether the row and column headings are smooth and whether the same term is consistent. | The list of terms is unified, and the professional content should be checked manually. |
| Column widths, line breaks, and merged cells | Check whether the text is truncated and whether the merged area is normal. | It is acceptable to adjust column width or line wrapping without affecting the data. |
# frequently asked questions (FAQ)
1. Where is the batch of Excel translation?
This article discusses a single workbook, and the operation on OmniDoc is to upload file by file. If you want to work with multiple separate files, you can first group them by category, and then follow the steps in this article to complete them one by one.
2. I just want to translate one of the worksheets. Can you choose only this one?
As in this article, it is safe to copy this table to a new workbook and upload it separately. In this way, the structure of the original document remains unchanged, and the translation only contains what is needed.
3. If the table name is changed into English after translation, will the formula go wrong?
A change in the table name affects the formula that references it. Check the cells with cross-table references, change the table name back to its original name if necessary, and then recheck the results.
4. After the translation, the typesetting has changed, what if the column width and the grid do not match?
Confirm the completeness of the data before adjusting the column width and line wrapping. If you want to print the form, you can take a look at the print preview in the desktop office software, and then make fine-tuning.
5. Can I submit the Excel translation directly?
Incorrect words or contextual deviations may occur in machine translation. Please check the important contents manually before submitting them. It is recommended that the forms in the field of expertise be reviewed by the relevant personnel.
# Summary
The Excel with many worksheets first looks at whether there is any dependence between the table and the table: the direct translation of the whole text needs to be split according to the worksheet one by one. After the Excel translation is completed, the table name, number and formula are checked table by table, and then the terminology is unified, the result is reliable.
