قالب وردپرس درنا توس
Home / Tips and Tricks / Turn a photo into an Excel worksheet with your phone

Turn a photo into an Excel worksheet with your phone



  42b1379

Excel inserts data from picture in action.


Angela Lang / CNET

Get off the keyboard and pick up your phone. A Microsoft Tool for Android Phones and 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. And it can convert almost two dozen languages. During the import, Excel allows you to fix any issues before they are converted.

Excel for Android and iPhone is part of the Microsoft Collection of Office Apps for mobile devices using 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 of Clifford / CNET

How to Convert 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.

3. Position the red rectangle around the data you want to capture, and then tap the round Capture button. The app is a little fussy about what it does and what is not identified as data. Therefore, some experiments may be required to capture what you want.

  http://www.cnet.com/ "height =" 110 "width =" 196


Currently playing:
Watch the following:

Turn a photo of data into a Microsoft Excel -Table



2:37

. 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 captured 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. If you are satisfied with the data, tap Insert at the top to paste the data into your workbook.

  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.png [-201659024"0"width="270

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


Screenshot of Clifford Colby / CNET

The data you capture and convert 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 privacy and security of Microsoft's customer information is paramount to the business," said a Microsoft spokesperson. "The Office Office's intelligence capabilities strictly consider a user's access privileges and do not pass information on to 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