Slashdot Mirror


Microsoft Excel Can Now Turn Pictures of Tables Into Actual, Editable Tables (thurrott.com)

Microsoft has rolled out a new feature to Excel's Android app that makes it easy to capture data. From a report: Excel now lets you take pictures of a document/paper in real life, crop the picture, and turn that into an actual, editable data on Excel. After capturing the data, you can edit the data to make sure Excel's image recognition is 100% accurate, and make any changes if some of the scanned data were incorrect. The company says it will roll out this feature to Excel for iOS app soon.

16 of 82 comments (clear)

  1. Obligatory xkcd by CyberSlugGump · · Score: 5, Funny
    1. Re:Obligatory xkcd by snakeplissken · · Score: 2

      And no, xkcd, everybody doesn't do that.

      It's a joke, jokes don't have to be 100% accurate descriptions of reality.
      In fact if all jokes have to be 100% accurate descriptions of reality, after a while they might... stop being funny.

  2. RE: Microsoft Excel Can Now Turn Pictures of Table by BradyB · · Score: 2

    I totally read that as edible tables.

    --

    Good is never enough, when you dream of being great!
  3. Why mobile only? by aaron44126 · · Score: 3, Interesting

    You don't know how many times that I received a screen shot of some text in a Word document. But I've gotten the same thing a number of times in an Excel spreadsheet as well. They should put this in desktop Excel.

  4. Re:Someone has to ask... by Luthair · · Score: 2

    Well on a PC what would you do? try to hold paper up to your shitty webcam blocking the screen so you can't see what it is capturing or focusing on?

  5. PDFs by doconnor · · Score: 4, Interesting

    Can the PC version excel do this with PDF files? That should be a lot easier.

  6. Re: Microsoft Excel Can Now Turn Pictures of Table by pr0fessor · · Score: 2

    Yes, edible table put out by Iodine Bucks the same guy that makes the pepperoni plates.

    Why, because traditional tables are stupid!

  7. Re:Someone has to ask... by ArhcAngel · · Score: 2

    Easy answer...It is HARD. OCR has been around for years but even today it is hit or miss except for the most sophisticated systems.
    I'm curious how well it translates on a mobile device. I've used OCR on PDF and Word documents that were just images and even when the text was perfectly legible it had a hard time getting the letters right and the formatting was always all over the place.

    --
    "A person is smart. People are dumb, panicky dangerous animals and you know it." - K
  8. Big fricking deal by ClickOnThis · · Score: 4, Interesting

    So you can convert an image of numbers into data in a spreadsheet? It's a trivial improvement on something we have been able to do for decades.

    Wake me up when the software can discover the relationship between the columns in the table, and insert the appropriate cell-references and math operations.

    --
    If it weren't for deadlines, nothing would be late.
    1. Re:Big fricking deal by doom · · Score: 2

      Wake me up when the software can discover the relationship between the columns in the table, and insert the appropriate cell-references and math operations.

      Thinking in terms of "discovering the relationship" is old-fashioned thinking, today's advanced software can automatically try every possible relationship and use a crowd-sourced technique to determine the most popular of all possible underlying data models.

      And column summation errors can now be introduced automatically to eliminate any legal responsibility for re-working estimates to hit desired targets.

  9. Re:Someone has to ask... by chispito · · Score: 4, Interesting

    Easy answer...It is HARD. OCR has been around for years but even today it is hit or miss except for the most sophisticated systems. I'm curious how well it translates on a mobile device. I've used OCR on PDF and Word documents that were just images and even when the text was perfectly legible it had a hard time getting the letters right and the formatting was always all over the place.

    Pretty sure the OCR will not be done on your device, but elsewhere.

    --
    The Daddy casts sleep on the Baby. The Baby resists!
  10. Re:WUT? by novakyu · · Score: 2

    Because Excel will give you a 2D representation to work with from the cropped picture; to use 3D modeling program, you need to take photos of the table from multiple perspectives, in order to build a 3D model.

  11. Re:Someone has to ask... by QuietLagoon · · Score: 2

    Because Microsoft has had an Office suite monopoly for soooo looooong that they haven't needed to actually innovate until now.

    Yes, that is my view as well.

  12. Taken from a Big Bang Theory episode? by QuietLagoon · · Score: 2

    ... you know, the one where they develop an app that takes a picture of an equation and then the app solves the equation?

  13. Dumnnnn by Impy+the+Impiuos+Imp · · Score: 2

    How about adding a spreadsheet diff tool that isn't a useless piece of shit designed without usability in mind?

    --
    (-1: Post disagrees with my already-settled worldview) is not a valid mod option.
  14. Re:Someone has to ask... by mobby_6kl · · Score: 2

    It's not that hard. I used Fine Reader to OCR stuff more than a decade ago and it worked well enough on printed text to be very useful. Complex layout with tables, multiple columns of text and so on could be a challenge, but knowing it's supposed to be an Excel table, combined with a decade of neural net development, it should've been relatively trivial.