Even importing data can be a complicated process. But Microsoft Excel’s mobile app allows you to take a picture of a table and paste the information directly into your spreadsheet. And no, that doesn’t mean sticking an image in there—it means the app can read, digitize, and paste the actual data into the corresponding cells.
You can find the same feature in the Microsoft Word app, so you’ll never have to type the contents of a physical document ever again.
Importing data to an Excel spreadsheet using your phone camera is simple. First, download the Excel app (free for iOS and Android), sign up or log in, and open a new document by tapping the plus sign in the upper right corner of your screen. There, you can choose whether you want a blank spreadsheet or one of the platform’s free templates.
Tap the cell where you want to input data and then tap the Menu button at the top of your screen—it looks like an A with a pen over it. From the emerging menu, tap Home, and choose Insert from the dropdown menu. There, tap Data from a Picture and grant Excel permission to use your device’s camera.
Now point your camera at the table you want to scan—it can be your bank statement, a guest list, or almost any piece of paper with any information distributed in rows and columns. To be clear, it’s not necessary for the data to be in a visible grid. As long as there are rows and columns, you’ll be good to go, but we did find the feature works best when you use it to scan something that has been typed and printed. You can also try pointing the camera at a spreadsheet on a screen, but it’s likely the moiré effect (those weird lines that appear when you snap a picture of your computer’s monitor) will distort the content and make it impossible for the app to recognize it. Don’t even try handwritten text—no matter how clear your words are, Excel just won’t be able to read it.
Place the document on a flat surface and point your camera directly at it (your phone should be as close to parallel with the surface as you can get it)—pro tip: if you have a somewhat new smartphone, get some help from your camera’s built-in level to help you position the camera just right. When you’re ready, tap the shutter button and use the cropping frame that appears on your screen to outline the information you want to add to your spreadsheet. When you’re done, tap Continue.
Excel will extract the data from the table you snapped, but before it pastes it into your document, it’ll ask you to check a preview to make sure everything’s just right. The platform will flag everything it might have gotten wrong by painting the cell red; to review it, tap the potentially problematic entry and choose Edit. To finish, tap on Open at the bottom of your screen.
You can do this as many times as you want in a single Excel file, and once the data is in the spreadsheet, you can use the program’s massive analysis power to do, well, whatever you want with it.
Source : https://www.popsci.com/diy/import-data-into-excel-camera-phone/