قالب وردپرس درنا توس
Home / Tips and Tricks / Turn a photo of data into a Microsoft Excel spreadsheet for iPhones in an instant

Turn a photo of data into a Microsoft Excel spreadsheet for iPhones in an instant



  42b1379

Excel inserts data from picture in action.


Angela Lang / CNET

Put the paper away and take your phone. A Microsoft Tool for Android Phones and Now iPhones ($ 1

,000 on Amazon) Converts words and numbers on a sheet of paper into a Microsoft Excel spreadsheet in seconds. The Insert Data from Image Excel tool lets you take a photo of data in rows and columns on a sheet of paper. The Excel app for iOS and Android automatically converts the image into editable spreadsheet data.

The spreadsheet conversion tool sends the image to Excel's online image recognition engine to process the words and numbers and convert them to a spreadsheet. During the import, Excel allows you to fix any issues before they are converted.

Excel for Android and iPhone is part of the Microsoft Office Mobile Apps collection, which includes Word and PowerPoint. The free versions of mobile productivity apps provide basic editing tools. With a Microsoft Office subscription, you can unlock additional features, such as the ability to work with colleagues.

  screenshot-20190521-151622 "data-original =" https://cnet3.cbsistatic.com/img/pklffeR19kLyulJTonqjE4chgfU=/ 2019/05/22/6849580e-e8f7-4d21-8b1d-415df92e2e63 / screenshot-20190521-151622 .png

An Excel spreadsheet, converted from a printed page.


Screenshot by Clif Colby / CNET

How to convert cell phone photos to Excel spreadsheet data:

1. Tap the New button in the Excel app at the top of the app to create a new file. You can create a blank workbook or use one of the templates provided with the app.

2. At the bottom of the app, tap the Data from image button (it's the 3×3 grid with a camera). If you are using the tool for the first time, tap Allow to grant Microsoft permission to convert the image to data using the Microsoft Online Service.

  screenshot-20190521-151142 "height =" 0 "width =" 270 "data-original =" https://cnet1.cbsistatic.com/img/5hgBeF0K3Uzdx5gN27t7lU37aPw=/270x0/2019/05/22/f74e654d-7b49 -49fd-95c8-570d295dce9f / screenshot-20190521-151142.p5 = 1965 "height =" 0 "width =" 270

Correct a printed fantasy football cheatsheet before creating an Excel spreadsheet.


Screenshot of Clifford Colby / CNET

. 3 Position the red rectangle around the data you want to capture, and then tap the round Capture button. The app is a bit fussy in terms of function and nonidentification as data, so you may have to try to capture what you want a few times.

4. If you are satisfied with the captured image, tap the red check mark to convert the data. If not, tap the X and start again.

5. In a preview of the collected data, tap a cell highlighted in red, and then tap Edit to enter missing information. Touch Done after each change. You can also tap unmarked cells to make corrections or changes.

6. When you are satisfied with the data, tap Insert at the top to paste the data into your workbook.

The collected and converted data can be numbers and words, and contain lists and recipe ingredients. And while the app was amazingly accurate at converting data from a piece of paper, we were also able to capture data from a laptop screen. However, there were problems with our handwritten data.

The Insert Data from Image tool for Android and iOS can be run in 21 languages, including French, German, and Spanish. Microsoft said.

Sending spreadsheet data to Microsoft for processing may raise privacy concerns. "The protection and security of Microsoft's customer data is paramount to the business," said a Microsoft spokesperson. "Intelligence features in Office apps strictly respect a user's access privileges and do not share information with people who have not been granted access."

$ 999

  http://www.cnet.com/ "height =" 30 "width =" 100

CNET may receive a commission from retailers.


Source link