OmniDocAfter scanning the mobile phone number in the table, how to verify it before entering Excel?
The mobile phone numbers identified by the scanning form are prone to errors in form, missing digits, and missing zeros at the beginning. This article talks about the confirmation items before identification, the steps to do OCR in OmniDoc and export to Excel, and the item-by-item verification method after export.
Key points of this article
- OCR the scanned document first, then check it against the original after recognition, and then export it to Excel, which is more reliable than directly copying and pasting.
- Close digits such as 1 and 7, 3 and 8, 0 and 6 are common mistakes in mobile phone number recognition. Please check them one by one.
- Set the mobile phone number column to text format before exporting to prevent the leading 0 from being swallowed by Excel.
- Use the LEN function to check the number of digits and use filtering to find abnormal lines, which can quickly locate the number that needs to be returned to the original for verification.
If you have a scanned address book, registration form or return visit list, the mobile phone numbers in the form usually need to be recognized into text before being sorted into Excel. The recognition results look neat, but the numbers are misplaced, one digit is missing, 1 is regarded as 7, or the leading 0 is swallowed. These problems are often not easy to detect at a glance. If you miss them, there will be problems in subsequent mass mailings and follow-up visits.
This article is written for people who need to enter the mobile phone number in the scanned form into Excel. After reading, you will know: what to confirm before recognition, how to OCR the scanned PDF in OmniDoc and export it to Excel, and which items to use to check whether the mobile phone number is reliable after exporting.
How to handle the identified mobile phone number so that it can be entered into Excel with confidence? One sentence conclusion
Check it against the original first, then export it to Excel. After exporting, check the number of digits and format to prevent most recognition errors. How to choose specifically depends on the situation below.
| your situation | Recommended practices | reason |
|---|---|---|
| The scanned copy is clear and there are not many numbers. | Check item by item against the original and then export to Excel | Manual comparison can detect similar word errors |
| There are many numbers and the form is neat | After exporting, check with the number of digits, and then spot-check the key lines. | Checking in batches is faster than looking at items one by one |
| Scans are smudged, skewed, or blurry | Re-scan or take a clear picture before identifying | The quality of the identification source is poor, and subsequent verification will be very laborious. |
| Table spans multiple pages | Check by page and record the number of lines per page | Easily detect missing pages or duplicate pages |
Before you start: Confirm these points first
- Confirm whether the file is a scanned copy: Use the mouse to drag a piece of text in the PDF. If you can select a text version, it can be directly exported; if you cannot select a scanned copy, which is usually a picture, you need to do OCR first.
- Confirm scan clarity: OCR is prone to errors when digital strokes are stuck or blurred. If the original document itself is unclear, change it to a clear scanned copy first, which will save time rather than revising it later.
- Confirm the purpose of the mobile phone number: for mass sending, return visits or archiving, which determines the strictness of the verification. In the list used for mass mailing, if one wrong number is used, the wrong person may be sent, so check more carefully.
- Confirm table structure: Merged cells and cross-page tables are easily misaligned after recognition. It is easier to take a look at the number of columns and table headers before exporting than to split them after exporting.
- Keep an original copy: When checking, compare it with the original copy, not just the recognition result. The original is also the basis for backtracking when errors occur.
Steps to export Excel after recognizing scanned tables in OmniDoc
- Download and open the desktop client: Go to download.omnidoc.top to download the desktop client, install it and open it.
- Open scanned PDF: Open the file to be processed in the PDF editing function of the client.
- Perform OCR recognition: Perform OCR on the scanned page and wait for the recognition to be completed. OCR will convert the text in the image into selectable and editable text.
- Check the recognition results against the original: Find the area where the mobile phone number is located on the page, and compare it line by line with the original. Don’t rush to export it yet.
- Export to Excel: Use the export function, select the Excel format and save.
- Check the structure in Excel: Confirm that the number of columns and headers are consistent with the original, and that the column containing the mobile phone number is not split or misplaced.
- Set the mobile phone number column to text format: Before or after importing, set the mobile phone number column to text format to prevent the leading 0 from being discarded as a number.
Check each item after completion
| Check items | How to see | What to do if there is a problem |
|---|---|---|
| Number of digits | Use the LEN function to count the number of characters in each number. Mainland mobile phone numbers are usually 11 digits. | Find the lines with wrong digits and correct them one by one. |
| Beginning number | Mainland China mobile phone numbers generally start with 1. Is the 0 at the beginning still there? | The leading 0 is replaced when missing, and the column is changed to text format. |
| Katakakuji | Focus on easily confused numbers such as 1 and 7, 3 and 8, 0 and 6, 5 and 6, etc. | Make corrections one by one according to the original, do not make changes based on impressions |
| Correspondence between rows and columns | Whether each number is aligned with the name on the same line | When misaligned, go back to check the merged cells and spread positions before exporting. |
| Missing lines and duplications | Compare the total number of lines in the original and use filtering to find duplicate numbers | Fill in missing lines and delete duplicate lines |
| redundant symbols | Find if there are spaces, dashes or brackets | Use search and replace to remove, then check the number of digits |
The identification results may not be completely accurate. For numbers used for important purposes, it is recommended to check them one by one before using them.
❓ Frequently Asked Questions (FAQ)
1. What should I do if the 0 at the beginning of the mobile phone number is missing after exporting?
Set the column to text format and replace the missing 0s. Newly entered or pasted numbers will also remain in text format to avoid losing them again.
2. After converting the scanned form into Word, the form is messed up. Should I use Excel instead?
If the table is mainly used for statistics, filtering and finding mobile phone numbers, it is recommended to export it to Excel. If you want to keep the original layout for printing or sending, then choose Export to Word. Both formats can be recognized first and then selected according to usage.
3. How to quickly find content that is not a mobile phone number after identification?
Use Excel's filter function to filter out rows with digits other than 11 and check them individually. It is recommended that non-number content such as names and notes be placed in separate columns and not mixed with numbers.
4. Can you use a formula to automatically determine whether a mobile phone number is valid?
Functions such as LEN can check the number of digits and leading digits to help you eliminate obvious errors. However, it can only determine the format and cannot confirm whether the number is authentic and valid. Manual verification is still required when confirmation is needed.
📝 Summary
After identifying the mobile phone number in the scanning form, first check it against the original, then export it to Excel, and finally check the correspondence between the digits, starting digits, and rows and columns. The probability of errors will be significantly reduced. Setting the mobile phone number column to text format can also avoid losing the leading 0. According to this process, the result of identifying the mobile phone number in the form can be used for subsequent work with confidence.
