Importing data from a picture into Excel | Scribe

Importing data from a picture into Excel

  • iTG Technologies |
  • 8 steps |
  • 27 seconds

    Launch Excel

    1
    Click "Microsoft Excel".

    Select your image

    2
    Click the "Data" tab.
    3
    Click "From Picture".
    4
    Then click "Picture From File..."
    5
    Select your image containing your data. This should be in table format for best results, but will import as text or number values from a picture.

    Check the data you are importing is correct

    6
    The "Data from Picture" window will come up showing you the image and asking you to review, i.e. correct anything it has not understood or insert the data.
    alert ordinal icon
    This system used OCR (optical character recognition) and is not perfect, so its important to review and correct any errors and some formatting may be required after import.
    7
    If you are happy, inset the data.
    8
    Example of the output