OmniDocTake a photo with your mobile phone to identify the form and convert it into an electronic form
How to turn a table photo taken with a mobile phone into an editable spreadsheet? This article explains the preparation before taking pictures, the processing steps in the mobile browser, the computer connection when an Excel file is needed, and how to check the results item by item.
Key points of this article
- When taking a photo, make sure the form is facing the camera, the light is even, and there are no obstructions around it. This is the prerequisite for accurate recognition and is more trouble-free than repairing it afterwards.
- On your mobile phone, you can first crop and save the photo as a PDF or image, and then upload it to the browser page of omnidoc.top for processing.
- Both scanned copies and photos can be uploaded, and bilingual comparison can be used to easily check box by box with the original form.
- When you need a real Excel file, it is more reliable to transfer the PDF to your computer, use a desktop client to do OCR and then export it to Excel.
- The recognition results must be checked with numbers, decimal points and merged cells. Machine recognition is bound to make mistakes. Do not use it to report or submit directly.
Many people have encountered this situation: paper reports, data tables on meeting whiteboards, or screenshots of forms sent by others can only be viewed but cannot be modified. If you want to copy the numbers into the spreadsheet, you have to type them one by one. Using your mobile phone to take photos and identify forms can save most of the time of manual entry. However, the recognition process on mobile phones is somewhat different from that on computers. The method of taking pictures, file format and subsequent export will all affect the results.
This article is for people who need to process table photos on their iPhone or Android phone. After reading, you will know what to pay attention to before taking pictures, how to complete uploading and downloading in the mobile browser, when it is necessary to transfer to the computer to export Excel, and how to check the results one by one after they come out.
How to turn a table taken with a mobile phone into a spreadsheet? One sentence conclusion
First, take a clear picture of the table on your mobile phone, cut it, and save it as a file, and then upload it to the browser page of omnidoc.top for processing; if what you ultimately want is an Excel file that can be used for calculations, transfer the processed PDF to your computer, use a desktop client to complete OCR and export it. Which path to choose depends on your needs:
| your situation | Recommended practices | reason |
|---|---|---|
| I just want to get the text in the table and check the content. | Use your mobile browser to upload photos or PDFs and download bilingual comparison results. | There is no need to install software, the original table and the identification content are side by side, making it easy to check box by box. |
| The form should only have one or two pages, and the format should be reserved for others to see. | Cut and save as PDF on mobile phone, process on web page and download | PDF can retain the page structure and is easy to share and print. |
| Real Excel files are needed to do calculations or sorting | Take a photo with your mobile phone and save it as a PDF, transfer it to your computer, use a desktop client to OCR and then export it to Excel. | Exporting to Excel is a function of the desktop client PDF editor. This step is not available on the mobile version. |
| The form is large, has many pages, and needs to be modified in batches | Processed on the computer, the mobile phone is only responsible for taking pictures and transferring files | The screen of mobile phone is small, and it is easy to miss when checking page by page. |
| Just wanted to have a quick look at what's in the table | Use the phone’s photo album or the text extraction function that comes with your camera | The operation is fast, but the row and column structure of the table is often lost, making it not suitable for formal use. |
Before you start: Confirm these points first
Photo quality determines recognition quality. The basis for recognition is that the image is clear. When shooting, keep your phone as parallel to the paper as possible to avoid perspective distortion caused by oblique shooting. Reflections and shadows are prone to occur under desktop lighting. It is recommended to move to a place with even lighting or turn off direct lights. Do not block the edge of the table with your fingers or other objects, otherwise the columns at the edge will be cut off.
First distinguish whether it is a photo or a scanned copy. Photos taken from paper originals are different from native electronic files. Photos often have tilts, shadows and wrinkles. This type of file is a scan or image, and the recognition accuracy is usually lower than that of native PDF, so it needs to be checked more carefully. To determine whether a PDF is a scan, you can try to select a section of text on it with your finger: if you cannot select it, you can only select the entire page image, which is basically a scan.
Confirm what output you want. If you only want the content in the table, bilingual comparison or only translated web page results are enough; if you want to do formula calculation, filtering or perspective later, you must get the Excel file, and this step must be completed on a computer. Think clearly about your goals first, so you don’t find out later that you have to rework after shooting.
Pay attention to privacy content. If there are ID numbers, bank account numbers, medical records or internal financial data in the form, use the crop function in the photo album to remove sensitive areas before uploading, or take photos of only the required parts. Processed files must also be saved and deleted according to the regulations of your unit.
Mobile network and storage must be sufficient. When uploading large files, the network may be unstable and may be interrupted. It is recommended to operate under Wi-Fi and confirm that your phone has enough storage space to save the downloaded results.
Steps to process form photos into identifiable files on mobile phones
- Facing the form when taking photos. Keep the phone parallel to the paper and let the entire form fall into the frame. Take a photo first to see if the edges are complete and the handwriting is clear.
- Crop to keep only the table area. Use the cropping function that comes with the photo album or camera to remove the desktop, fingers and background. Just leave a little blank space at the cropping edge. Do not cut off the outer row or column of the table.
- Save as image or PDF. A single form can be saved directly as a picture; for multi-page forms, it is recommended to use the system's "Share" or "Print" function to save the photo as a PDF so that the order of the page numbers is not easily messed up.
- Open omnidoc.top with your mobile browser. Access the web version in the mobile phone's built-in browser or other commonly used mobile browsers, log in and enter the document processing page. The web version can be used in the mobile browser and does not require additional installation.
- Upload the file and select the output method. Select the PDF or image you just saved to upload, and select bilingual comparison as the output method. The original table and recognition results will be displayed side by side for easy verification.
- Wait for the processing to complete before downloading the results. After the page processing is completed, download the results to your mobile phone, or save them to a network disk or email and transfer them to your computer.
- Go to your computer when you need the Excel file. Transfer the original PDF to your computer and open the OmniDoc desktop client (available for download at download.omnidoc.top, supports Windows, macOS and Linux). The scanned document first uses the OCR function in the PDF editor to recognize the text, and then uses the export function to output it as an Excel file.
Check each item after completion
Machine recognition makes errors, especially with numbers, decimal points, negative signs, and merged cells. The following are the recommended items to check item by item after getting the results:
| Check items | How to see | What to do if there is a problem |
|---|---|---|
| Number of rows and columns | Count the rows and columns against the original table to make sure there are no missing rows or extra empty columns. | Go back to the photo session and re-shoot the blocked part, or leave the edges wider when cropping |
| Numbers and decimal points | Compare the original table one by one, focusing on 0 and 8, 1 and 7, and the position of the decimal point. | Make corrections manually in the spreadsheet, and then use totals or formulas to check again after corrections are made. |
| Merge cells | Check whether the title row and grouping labels are misplaced, and whether the text across columns in the original table is split. | Manually adjust cell merging, or add comments next to the table to explain the original structure |
| Chinese and symbols | Check whether commas, brackets, percent signs, and currency symbols are correct | Use search and replace to make unified corrections, and write down frequently mistaken words so that you can focus on checking them next time. |
| Header and unit | Confirm whether what is written in the table header is consistent with the original table, and whether the unit (10,000 yuan, yuan, %) is missing | Complete the table header according to the original table. The unit must be written clearly. |
| Totals and logical relationships | Use the total row or addition relationship of the original table to check the calculation again | If it doesn’t match, go back to the original image first and don’t modify it based on your feelings. |
When the identification results involve important data, it is recommended to ask a second person to read it again against the original table.
📊 Core comparison
The difference between the mobile version and the computer version mainly lies in three aspects: whether you can get Excel, whether it is convenient to have more pages, and whether the results are easy to check.
| Comparative item | Mobile browser | PC desktop client |
|---|---|---|
| Take pictures and upload | Process directly after shooting, suitable for on-site counting | You need to transfer the photo or PDF to your computer first |
| Output form | Bilingual or translated-only document results | Can be exported to Excel for easy calculation and filtering |
| Scanned document processing | Scans can be uploaded for processing | Can be exported after OCR recognition |
| Tables with many pages | The screen is small and checking page by page is time-consuming. | Compare page by page on a large screen, making it easier to find errors and omissions |
| Suitable scene | Quick viewing, on-site retention, and temporary verification | Formal reports, data that need to be calculated further |
❓ Frequently Asked Questions (FAQ)
1. Do I need to install a separate app for the mobile phone photo identification form?
The web version can be used directly by opening omnidoc.top in the mobile browser, and there is no need to install the app. If you want to export an Excel file, you need to use a desktop client on your computer.
2. Are there any differences in the operation of iPhone and Android phones?
The specific button positions for taking pictures, cropping and saving as PDF vary depending on the system version, but the upload and download processes are the same: first process the form into a clear image or PDF, and then access the web version in the mobile browser to upload.
3. Can the text extraction that comes with the mobile photo album be directly converted into Excel?
Generally, only text content can be extracted, and the row-column relationship is often lost. After pasting into the table, a lot of manual finishing is required. If you want to retain the table structure, it is recommended to use a dedicated table to identify the process and check it item by item in the results.
4. If the photo taken is blurry or tilted, can it still be recognized?
You can reshoot first. If the original cannot be retaken, you can crop and correct it in the photo album first, but the error rate of the recognition results will increase and the workload of verification will also increase. It is recommended to re-obtain the original for important data.
5. What should I do if the number in the recognition result is wrong?
Use the original table as the standard, manually modify it in the spreadsheet or document, and then use totals or formulas to check again. If you find the wrong character type (for example, 0 and 8 are often confused), you can pay special attention to whether the handwriting is clear next time you take a photo.
📝 Summary
The key to taking a cell phone photo identification form is to take a clear picture, crop it cleanly, and check it item by item after outputting it. Uploading and bilingual comparison are completed in the mobile browser, which is suitable for quick verification; when an Excel file is needed, switch to the computer and use the desktop client to process it.
