Excel - Data from Picture - Microsoft 365 New Feature

Posted on:  07/15/2022
Excel - Data from Picture - Microsoft 365 New Feature

Have you ever had a printed page of data, and needed to put the data in Excel? Typing the data is a real pain. Excel now allows you to put the data in Excel using Data from Picture.

Data from Picture

Data from Picture

Data from Picture is a great feature and is extremely accurate. Data from Picture can be used with webpages, pictures on your clipboard from a screenshot, or take a picture of printed data.

You have two options when using Data from Picture

  • Picture from File
  • Picture from Clipboard
Disney Event with Chris Menard in September 2022
Recent Word articles

YouTube video - Extract Data from Picture

Chapters:

  • 0:00 Intro
  • 0:32 Live in-person events with Chris
  • 0:57 Why use Data from Picture?
  • 1:37 Insert Picture
  • 2:05 Data from Picture
  • 3:44 Data from Picture accuracy
  • 4:30 Conditional Formatting
  • 5:45 Closing comments
Recent Teams articles

Examples of when to use Data from Picture

Screen capture data from a website.

Copying and pasting from a website doesn't give you the best results. Usually there are a lot of errors. With Data from Picture, you can do a screenshot using Snagit or another screen capture program. The Windows keyboard shortcut to do a screenshot is  Windows key + Shift + S. You can also use the Windows Snipping tool to do a screenshot.

  1. Take a screenshot
  2. Click Data, then select From Picture, and click Picture from Clipboard.
  3. Follow the onscreen instructions.
Windows Snipping Tool

Windows Snipping Tool

Take a picture of printed data

Do you have printed data you need to get into Excel? No problem.

  1. Grab your camera and take a picutre of printed data.
  2. Save the image to your computer. 
  3. Click Data, then select From Picture, and click Picture from File.
  4. Follow the onscreen instructions.
Data tab - From Picture in Excel

Data tab - From Picture in Excel

Recent Excel articles

Excel Status Bar - Tips Every User Should Know

Excel Status Bar - Tips Every User Should Know

How to SORT Data in Excel | 7 Tips

How to SORT Data in Excel | 7 Tips

Excel - Data from Picture - Microsoft 365 New Feature

Excel - Data from Picture - Microsoft 365 New Feature

Excel - using the Scenario Manager to track house payments with skyrocketing mortgage rates

Excel - using the Scenario Manager to track house payments with skyrocketing mortgage rates

Recent Teams articles

Teams - Change your status in Teams | Duration and Status Message

Teams - Change your status in Teams | Duration and Status Message

Teams Online Couse - New material added

Teams Online Couse - New material added

Recent Outlook articles

Outlook Calendar - Meetings vs. Appointments

Outlook Calendar - Meetings vs. Appointments

Outlook Contact Group - Distribution List - Schedule a Meeting Trick - Huge Timesaver

Outlook Contact Group - Distribution List - Schedule a Meeting Trick - Huge Timesaver

Teams online training couse - 2.5 hours of videos

50% off coupon

 

Microsoft Teams online training

Microsoft Teams online training

Chris Menard

Chris Menard is a Microsoft Certified Trainer (MCT) and is employed full-time as a Trainer for BakerHostetler, one of the nation’s largest law firms. Menard has a YouTube channel with over 800 technology videos covering Excel, Word, Zoom, Teams, Outlook, Gmail, Google Calendar, and other resources that over 12 million viewers have appreciated. Menard also does public speaking at conferences for CPAs and Administrative Professionals. Connect with Chris on LinkedIn at chrismenardtraining.com/linked or on YouTube at chrismenardtraining.com/youtube

Categories