OmniDocExcel only translates one column, leaving other columns as they are.
There is only one English column in the table that needs to be translated into Chinese, and the numbers, numbers, and formulas in other columns cannot be moved. This article talks about how to separate the target column, translate it, and paste it back into the original table, and gives the verification method.
Key points of this article
- It is easy to change numbers, numbers and dates by directly translating the entire table. It is more suitable to separate out the column that only needs to be translated and process it separately.
- Keep the serial number column when splitting, so that the translation can be pasted back to the original table in row alignment to avoid row errors.
- Back up the original file before pasting it back, and keep a copy before overwriting the original column so you can restore it if something goes wrong.
- After translation, check the number of rows, whether other columns have changed, whether formula errors are reported, and spot-check professional terms.
A common situation in the table is: Column A is the English product name, column B is the price, column C is the inventory number, and column D is the remarks. You only want to translate the English column into Chinese, and leave the other columns unchanged. If the entire table is handed over directly to the translator, the numbers, numbers, and dates may also be rewritten, and subsequent filtering, summing, and formula references will be affected.
This article talks about a practical method: first separate the target column, and then put it back into the original table by row after translation. After reading, you can judge which situations need to be handled first, how to operate step by step, and what to check before returning the results to the original form.
How to translate only one column? One sentence conclusion: taking it out, translating it, and then pasting it back can preserve other columns better than translating the entire table.
First put the target column into a new file separately. After translation, only the translation column is pasted back to its original position, and the other columns are not touched at all. Suggestions are given below according to the situation.
| your situation | Recommended practices | reason |
|---|---|---|
| The target column is plain text, such as product name, description | Separate the column and translate it separately, and paste the translation back | Text content is suitable for translation and will not affect other columns |
| Other columns have formulas referencing the target column | First convert the formula result into a numerical value, and then split it | The formula will change with the content and will be easily disconnected after pasting it back. |
| The target column contains a mix of numbers, codes, and models | Only the text part is translated, and the numbers are kept separately. | Avoid numbers being overwritten or misspelled |
| Need to compare Chinese and English for easy verification | Select bilingual comparison output and organize it into two columns | The original text and the translation are side by side for easy line-by-line inspection |
| The target column is very long and there are many rows | Separate them in batches and check after adding serial numbers to each batch. | When there are many rows, it is easier to find missing rows and wrong rows |
Before you start: Confirm these points first
1. Confirm the range of the target column. Header rows, empty cells and merged cells will all affect the split results. Before splitting, take a look at which row this column starts and ends, and whether there are any merged cells in the middle.
2. Check if there is any formula referencing this column. If column E is a calculation such as =B2*2, or other tables refer to the target column, the formula may become invalid after being removed and pasted back. In this case, copy the formula result into a numerical value first, and then perform subsequent operations.
3. Back up the original files first. Save a copy and all operations will be performed in the copy. Before overwriting the original column, make sure that the original column is retained in the copy so that it can be restored if an error occurs.
4. Decide where to place the translation. There are two common methods: one is to insert a column to the right of the target column to contain the translation, and the original text is retained for easy comparison; the other is to directly overwrite the original column, which is suitable for situations where only Chinese is required. The former is more reliable, and it is recommended to use the former first.
5. Pay attention to technical terms. Machine translation may not be accurate in processing product models, industry terms and abbreviations. After getting the results, you must check them against the original text.
Steps to translate only one column in OmniDoc
- Save a copy and create a new worksheet. Create a new worksheet in the copy, just for the content to be translated.
- Copy the target column and sequence number. In the first column of the new table, fill in 1, 2, 3... as the serial number, and paste the content of the target column (including the title row) in the second column. The serial number corresponds one-to-one with the row number of the original table, which is the basis for pasting back by row later.
- Save as .xlsx file. Save the new table as a separate Excel workbook, keep only this table, and mark the file name as "to be translated" to avoid confusion with the original table.
- Upload to omnidoc.top. Open the website, upload the .xlsx file you just saved, and select Excel file as the table type.
- Set translation into Chinese and select the output method. Target language is set to Chinese. If you select "Translation only" as the output method, the result will be more concise and easy to paste back directly; if you select "Bilingual comparison", you can see the original text and the translation at the same time.
- Download the translation file. After the translation is completed, download the result, open it in Excel, and confirm that the header row and content have been processed.
- Paste it back to the original form according to the serial number. Based on the serial number, paste the translation line by line to the right side of the target column of the original table (or overwrite the original column). Before pasting, compare the serial numbers to ensure that the translation of the nth row corresponds to the nth row of the original table.
- Save and check item by item. Save a copy of the original table and check with the checklist in the next section that the other columns remain unchanged.
Check each item after completion
| Check items | How to see | What to do if there is a problem |
|---|---|---|
| Check if the number of rows is consistent | Compare the number of the last line in the translation with the number of lines in the original table | If the number of rows is small, it means missing rows. Go back to the splitting step and realign them. |
| Are other columns unchanged? | Compare values and text column-by-column with the original copy | If there are changes, restore the column using the original copy |
| Numbers, dates, serial numbers | Randomly check the beginning, middle, and last few lines | Revert the rewritten content to its original value and check if it has been mistakenly inserted into the numeric column |
| Is the formula incorrect? | Check for prompts like citation errors | Redefine the range of the formula reference, and use a numerical value if necessary |
| Whether the terminology is accurate | Spot check professional terms, abbreviations, and models against the original text | Manually modify and organize commonly used terms into a comparison table |
| Whether the layout is appropriate | Check if line breaks, column width, and text are truncated | Adjust column width or enable auto-line breaks to keep the table readable |
If you find many issues during verification, it's recommended to go back to the copy for correction first, rather than repeatedly modifying the original table, as this makes it easier to find the error points.
📊 Core Comparison
| Method | Check if other columns are affected | Suitable for the scene | Notes |
|---|---|---|---|
| The entire table is translated directly | Numbers and serial numbers may be affected; they need to be checked | The entire table is written content | Needs to be checked column by column, making it easy to alter non-text content |
| Split the target column, translate it, and paste it back | Basically unaffected, provided the serial numbers are aligned | Just translate a specific column | There are many steps for splitting and re-pasting, requiring careful alignment |
| Frame-by-frame manual translation | Unaffected | Very few lines, simple content | Having many lines is time-consuming and prone to inconsistency |
❓ Frequently Asked Questions (FAQ)
1. Why not translate the entire table directly?
Whole table translation processes all text in the table, and numbers, numbers, and dates may also be changed together. If the entire table needs to be translated, direct translation is much easier; If only one column is needed, post-splitting processing is more controllable.
2. Will removing it into a new table lose format?
The split columns are mainly plain text, and cell colors, fonts, and other formats may not be fully preserved. After re-pasting the original table, you need to review the format again. It is recommended to keep copies of key columns for easier comparison.
3. The table is an image or screenshot, not an editable table. What should I do?
First, convert the content in the image into editable table text, then split and process the columns as described above. If the text is scanned text, the recognition results must be checked item by item to avoid errors in numbers and symbols.
4. After translating into Chinese, the text becomes longer and the table looks messy. How should I handle this?
You can adjust the column width of the target column or enable auto-line wrap to display long text fully within the cell. If you only need the Chinese result, you can also keep only the translation column and hide or save the original text column as well.
📝 Summary
Only translate one column in Excel; the key is to first split the target column, align it with serial numbers, then paste it back into the original table line by line after translation. This not only completes the translation but also ensures that the numbers, numbers, and formulas in other columns remain intact. Machine translation results still need to be compared with the original text, especially for technical terms and models.
