Excel - Data from Picture - Microsoft 365 New Feature
Posted on: 07/15/2022
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 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
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
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.
-
Take a screenshot
-
Click Data, then select From Picture, and click Picture from Clipboard.
-
Follow the onscreen instructions.

Windows Snipping Tool
Take a picture of printed data
Do you have printed data you need to get into Excel? No problem.
-
Grab your camera and take a picutre of printed data.
-
Save the image to your computer.
-
Click Data, then select From Picture, and click Picture from File.
-
Follow the onscreen instructions.

Data tab - From Picture in Excel
Recent Excel articles
How to SORT Data in Excel | 7 Tips
Excel has a powerful SORTING engine. SORT is the most popular function in Excel, and it can sort by many types of data, many attributes, and even custom sorting configurations.
Recent Teams articles
Recent Outlook articles
Teams online training couse - 2.5 hours of videos
50% off coupon

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