OmniDocHow to translate English PDF tables into Chinese Excel: translate first or export first
There are two sequences for converting English PDF tables into Chinese Excel: first translate the PDF and then export, or first export the Excel and then translate the table file. This article compares the impact of the two on the table structure, and provides the basis for judgment, operating steps and verification methods.
Key points of this article
- Tables with text version PDF and clear rows and columns are usually exported to Excel first and then translated into .xlsx. The cell boundaries are clear and easy to modify and check.
- The scanned PDF must be OCRed first so that the text can be selected before exporting, otherwise the exported table will often be empty or misaligned.
- Long tables with headers merged and spread across pages are easily misaligned during export. It is recommended to keep the translated PDF for comparison and check page by page.
- The translated numbers, dates, and units must be checked item by item with the original table. Machine translation cannot replace manual checking.
- After finishing the process, use one page to test-transfer, confirm that the rows and columns and translation positions are correct, and then process the entire document.
You have an English PDF report in your hand, which contains dozens of lines of numbers and text. What you want is a table that can be filtered and calculated in Excel, and the header and content are in Chinese. This requires two steps: converting the PDF table into Excel, and then translating the content into Chinese. Depending on the order of the two steps, there will be a significant difference in how well the table structure is retained.
This article is written for readers who need to process English financial tables, experimental data tables, and product parameter tables. We compare two sequences: first translate the PDF in OmniDoc and then export it to Excel; or first export the PDF to Excel and then translate the table file. After reading it, you will be able to judge which order is suitable for your table, and know what to check after the translation.
Should the English PDF table be translated or exported first? One sentence conclusion
For text versions of PDF tables with clear rows and columns, it is recommended to export them to Excel first, and then translate the .xlsx file; for scanned versions or tables with complex layouts, first process them into selectable text, and keep the translated PDF for comparison.
| your situation | Recommended practices | reason |
|---|---|---|
| Text version PDF, table rows and columns are clear | Export to Excel first, then translate .xlsx | The cell boundaries have been separated, making it easy to check and modify cell by cell. |
| Scanned PDF | First OCR to make text selectable, then export, then translate | The words in the picture cannot be exported directly and need to be recognized first |
| Long tables with headers merged and spread across pages | First translate the PDF and keep it for comparison, then export it and check it page by page. | Merged cells are easily misaligned after exporting, so you need to compare them with the original format. |
| Only need Chinese version for others to read | Translate the PDF first, and the translated version will prevail. | The translation remains in the original format and corresponds one-to-one with the original table when reading. |
| There are formulas in the table or calculations need to be continued | Manually check formulas after export and rebuild if necessary | What we translate is text, and we will not restore the calculation relationship for you. |
Before you start: Confirm these points first
First, is the PDF a text version or a scanned version? Open the PDF and try to select a cell in the table with the mouse. If you can select text, it's the text version; if you can't select it, it's mostly a scanned copy or picture. The processing order of the two is different. If the judgment is wrong, the exported table will be blank or garbled.
Second, does the table have merged cells and spread across pages? If the table header spans several columns, a cell spans several rows, or the table continues from one page to the next, the risk of export misalignment will increase. It is recommended to translate this type of form into PDF first for comparison, and then decide how to export it.
Third, do you want translation or bilingual comparison? As long as the results are in Chinese, you can choose translation only; if you need to compare it with the English original text, you can choose bilingual comparison. Bilingual comparison is useful for verification, but the table will become wider and column widths need to be adjusted after exporting.
Fourth, numbers and proper nouns must be checked manually. Machine translation will process the text, but content such as amounts, dates, percentages, models and names must be returned to the original PDF for confirmation one by one. Don’t just look at the translation for important data.
Fifth, whether the form involves sensitive information. For financial statements, contract schedules, and undisclosed experimental data, please confirm the storage and processing methods of the files before uploading. This should also be kept in mind when choosing an online tool.
Steps to export and then translate the table
- Confirm that text can be selected. Open the PDF in the desktop client and use the PDF editor to select the text in the table. If you cannot select, do OCR first and wait until the text can be selected before continuing.
- Select the pages you want to convert. Select only pages containing tables to avoid exporting the main text, headers and footers together, and reduce subsequent cleaning work.
- Export to Excel. Use the export function of the PDF editor, select Excel as the format, and save as an .xlsx file.
- Open the exported file and check it against the original table. Check row by row to see if the number of rows, columns and table headers are consistent with the PDF. If there are any misalignments, go back to the PDF and correct them.
- Upload .xlsx to omnidoc.top. Upload the form file on the web page and select the translation method: translation only, or bilingual comparison.
- Select the document style and download the translation. Financial, technical, academic and other styles will affect the choice of terms. Choose the one that matches the content of the table. After downloading, open it in Excel and check it item by item.
Check each item after completion
| Check items | How to see | What to do if there is a problem |
|---|---|---|
| Number of rows and columns | Compare the number of rows and columns per page with the original PDF, especially the spread | If you mislocate, go back to PDF to check the merged cells and split or merge them in Excel. |
| Number, date, unit | Itemize the amount, date, percent sign and unit | Change back to the original value based on the original PDF, and do not retain the numbers in the translation |
| Headers and terminology | To see whether the same concept is translated into the same word | Use Excel to find and replace unification; change style and re-translate if necessary |
| Formula | Click on the cell containing the formula to see if it is still there and whether the reference is correct. | Formula is missing or referenced incorrectly, rebuild manually |
| Layout | See if line breaks, column widths, and Chinese overflow cells | Adjust the column width and turn on automatic line wrapping |
# Core comparison
Each of the two orders has its own emphasis, and the following are compared according to common judgment points:
| Comparison term | Export first and then translate | Translate PDF before exporting |
|---|---|---|
| Table structure | Depending on whether the row and column identification is accurate at the time of export, a clear table works better. | The layout is the same as the original text, but whether the cells can be separated after export should be checked separately. |
| Translation position | Write it directly in the cell, one grid to one. | First, in the layout, you need to confirm whether the translation falls into the corresponding cell after export. |
| Bilingual | To juxtapose two rows or adjacent cells in Excel. | Internal control of the layout, intuitive reading, but may need to be sorted out after export |
| Scanned piece | OCR is required before you can export | Scanned pieces can be uploaded and translated directly, which is suitable for scenes as long as they are translated. |
| Modification cost | Modify it one by one in Excel to facilitate batch processing | To modify it, you need to go back to PDF or export and then change it, with more steps. |
# which method is suitable for you?
- tables that need to continue to calculate, filter and do perspective : export Excel first, and then translate. Computational relationships and cell boundaries are handled in Excel, making it easier to check. - you need to show colleagues the form in both Chinese and English pages : translate PDF first and retain the translated layout. Export Excel as a supplement for those who need to edit it. - many copies of the same type of form need to be processed : first use one page to try to transfer, compare the results of the two orders, and then determine the fixed process. Don't process the whole batch without trying.
# frequently asked questions (FAQ)
1. What is the method of translating excel into Chinese?
If the form is already a .xlsx file, upload it directly to omnidoc.top, select translation only or bilingual control, and download the translated Excel. Check the numbers and headers item by item after download.
2. Can the scanned PDF form be converted to Excel?
Yes, but first let the text be selected. OCR the scanned piece in the desktop client, and then export the Excel. OCR results also need to be checked against the original table, especially the numbers.
3. How to choose a free tool for converting pdf to excel forms?
You can look at several items when selecting: file size limit, whether the export result is watermarked, whether the file is stored and processed in accordance with your confidentiality requirements, and whether to retain rows and basic formats after export. Financial and similar forms, confirm these items before uploading.
4. What if the translated table number is different from the original table?
The original PDF shall prevail. First find out the location of the difference, go back to the original table to check, and then change the number back to the original value. If it is a batch error, check to see if it is an OCR recognition error, not a translation problem.
# Summary
When an English PDF form is translated into Chinese Excel, the key is to judge whether the form is a text version or a scanned version, and then decide whether to export or translate first. For text forms with clear rows and rows, it is usually safer to export Excel before translation, while complex forms retain the translated layout for comparison. Regardless of the order, numbers and proper nouns should be returned to the original table and checked item by item.
