Computer Tutorials
Troubleshooting
Stop typing and import data into Excel and Word with only your phone camera
Stop typing and import data into Excel and Word with only your phone camera
Feb 25, 2025 pm 03:24 PM
Say goodbye to the cumbersome entry! Just use your phone camera to easily import data into Excel and Word!
For non-professionals, spreadsheets can be daunting. Countless options, complex formulas and formatting are all very troublesome.
Even data import can be a complicated process. But Microsoft Excel's mobile app allows you to take photos of tables and paste information directly into your spreadsheet. This is not a simple picture paste, the application can read, digitize and paste the actual data into the corresponding cells.
The same function is also available in Microsoft Word applications, say goodbye to manually enter paper documents from now on!
Use mobile phone camera to import data into Excel table
It is very easy to import data into an Excel spreadsheet using a mobile phone camera. First, download the Excel app (both available for free on both iOS and Android), register or log in, and then click the plus sign in the upper right corner of the screen to create a new document. There you can choose one of the free templates for the blank spreadsheet or platform.
Tap the cell where you want to enter data, and then click themenu button at the top of the screen (looks like an A with a pen). In the menu that pops up, click Homepage, and then select from the drop-down menu to insert . There, click to import data from pictures and allow Excel to use your device's camera.
Now point your camera to the form you want to scan—can be your bank statement, guest list, or almost any paper with information arranged by row and column. The data does not have to be in a visible grid. As long as there are rows and columns, it works fine, but we found that scanning and printing text works best. You can also try to point your camera at a spreadsheet on the screen, but there may be a moiré effect (the weird lines that appear when taking photos of your computer screen), distorting the content and making it unrecognizable to the app. Don't try to scan handwritten text – no matter how clear your handwriting is, Excel cannot read it.Put the document on a flat surface and aim the camera directly at it (your phone should be as parallel to the surface as possible) – Pro tip: If you have a newer smartphone, you can take advantage of the built-in camera Leveling to help you place your camera correctly. When you are ready, click the shutter button and use the crop box that appears on the screen to outline the information you want to add to the spreadsheet. When finished, click
to continue .
Excel will extract data from the table you took, but before pasting it into the document, it will ask you to check the preview to make sure everything is correct. The platform will mark the content that may be wrong in red; to view it, click on the entry that may be in question and selectEdit . Finally, click at the bottom of the screen to open .
You can do this multiple times in a single Excel file, and once the data enters the spreadsheet, you can use the program's powerful analysis capabilities to process it.
Use your phone camera to import text into a Word document
You wouldn't think Microsoft would develop a great tool and just make it work for one of its Office programs, right? Excel is not the only program with photo-based text input—similar tools are available in the mobile Word app.
To use it, download the app (free download for both iOS and Android). If you have registered or logged into the Excel application, Word will recognize you and you can later skip this step using other Office mobile applications. Use the plus sign in the upper right corner of the screen to open a new document and click the menu button. Click Homepage, select from the drop-down menu to insert , and finally click Scan the document.
Word will open a tool similar to Excel, where you can select one or more images from your photo gallery, or take a new one. No matter what you do, you can use the cropping tool on the next screen to select the specific block of text to import. When finished, click to confirm .
Word apps are slightly more sensitive than Excel when it comes to importing text from real-world documents and also consider formatting. This can be a little annoying if you are only interested in plain text; if you are scanning for large content (such as news headlines), it can break the proportion of the page.
Nevertheless, if you need an editable copy of important documents, both tools can save you a lot of typing time. The Office 365 app also runs in the cloud, so if you don't like typing on your phone or working on spreadsheets, you can access your document later on your laptop, using a click instead of a tap.
The above is the detailed content of Stop typing and import data into Excel and Word with only your phone camera. For more information, please follow other related articles on the PHP Chinese website!
Hot AI Tools
Undress AI Tool
Undress images for free
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Windows Security is blank or not showing options
Jul 07, 2025 am 02:40 AM
When the Windows Security Center is blank or the function is missing, you can follow the following steps to check: 1. Confirm whether the system version supports full functions, some functions of the Home Edition are limited, and the Professional Edition and above are more complete; 2. Restart the SecurityHealthService service to ensure that its startup type is set to automatic; 3. Check and uninstall third-party security software that may conflict; 4. Run the sfc/scannow and DISM commands to repair system files; 5. Try to reset or reinstall the Windows Security Center application, and contact Microsoft support if necessary.
Proven Ways for Microsoft Teams Error 657rx in Windows 11/10
Jul 07, 2025 pm 12:25 PM
Encountering something went wrong 657rx can be frustrating when you log in to Microsoft Teams or Outlook. In this article on MiniTool, we will explore how to fix the Outlook/Microsoft Teams error 657rx so you can get your workflow back on track.Quick
How to fix 'SYSTEM_SERVICE_EXCEPTION' stop code in Windows
Jul 09, 2025 am 02:56 AM
When encountering the "SYSTEM_SERVICE_EXCEPTION" blue screen error, you do not need to reinstall the system or replace the hardware immediately. You can follow the following steps to check: 1. Update or roll back hardware drivers such as graphics cards, especially recently updated drivers; 2. Uninstall third-party antivirus software or system tools, and use WindowsDefender or well-known brand products to replace them; 3. Run sfc/scannow and DISM commands as administrator to repair system files; 4. Check memory problems, restore the default frequency and re-plug and unplug the memory stick, and use Windows memory diagnostic tools to detect. In most cases, the driver and software problems can be solved first.
the default gateway is not available Windows
Jul 08, 2025 am 02:21 AM
When you encounter the "DefaultGatewayisNotAvailable" prompt, it means that the computer cannot connect to the router or does not obtain the network address correctly. 1. First, restart the router and computer, wait for the router to fully start before trying to connect; 2. Check whether the IP address is set to automatically obtain, enter the network attribute to ensure that "Automatically obtain IP address" and "Automatically obtain DNS server address" are selected; 3. Run ipconfig/release and ipconfig/renew through the command prompt to release and re-acquire the IP address, and execute the netsh command to reset the network components if necessary; 4. Check the wireless network card driver, update or reinstall the driver to ensure that it works normally.
Windows 11 KB5062660 24H2 out with features, direct download links for offline installer (.msu)
Jul 23, 2025 am 09:43 AM
Windows 11 KB5062660 is now rolling out as an optional update for Windows 11 24H2 with a few new features, including Recall AI in Europe. This patch is available via Windows Update, but Microsoft has also posted direct download l
Windows could not start because the following file is missing or corrupt
Jul 07, 2025 am 02:39 AM
When the boot prompt is "Windows could not start because of the following fileismissing" 1. You can run bootrec/fixmb, bootrec/fixboot, bootrec/rebuildbcd through the Windows installation media; 2. Check the hard disk connection or use CrystalDiskInfo to detect the health status of the hard disk; 3. If there is a dual system, you can use the bootrec command to rebuild the boot or manually add the boot items; 4. Use PE environment to kill viruses and combine DISM and SFC tools to repair the system files, and the system can be restored in most cases.
My second monitor is not detected on Windows
Jul 08, 2025 am 02:47 AM
If the second monitor is not recognized by Windows, first check whether the cable and interface are normal, try to replace the HDMI, DP or VGA cable, confirm the plug-in video output port, and test different interfaces to eliminate compatibility issues; then verify the monitor power and input source settings, and connect the monitor separately to test whether it can be recognized; then enter the Windows display settings and click the "Detection" button, or use Win P to switch the display mode, and update the graphics card driver at the same time; finally check the graphics card specifications to confirm whether it supports multi-screen output to avoid exceeding its maximum output capability.
How to fix Windows key not working issue in Windows 10/11?
Jul 09, 2025 am 02:32 AM
Most Windows keys do not work are setup or system issues. 1. Check whether the "Use Windows Key Hotkey" function is enabled and turn off the relevant software or services. 2. Run Windows built-in keyboard troubleshooting detection questions. 3. Check whether there is a ScancodeMap key in the registry, and delete it to restore the Win key if so. 4. Update or reinstall the keyboard driver, try uninstalling the device and restarting it automatically. 5. Test hardware problems, change the external keyboard or use the test website to determine whether it is damaged. Most cases can be solved through the above steps.
