Image default
Tech

How to import Excel data from screenshots

ExcelImage: Microsoft

If you come across data you want to add to an Excel spreadsheet, but copying and pasting it doesn’t work (or seems like too much work), you can also take a screenshot of the table. Then, you can use a little-known Excel import feature to migrate the data from your screenshot to your spreadsheet.

To ensure that the screenshot contains only the data table and not the entire screen, press the Win-Shift-S key combination to bring up the Windows Snipping Tool. Then use the mouse to draw a rectangle around the table area only. This saves the screenshot in your Windows clipboard.

Open Excel, select the “Data” tab, and navigate to From Picture > Picture From Clipboard. Excel then imports the screenshot’s information and displays the data on the right-hand side of your spreadsheet for checking and pasting.

If you want to import information from a saved screenshot, use From Picture > Picture From File instead.

[ Save $20 on Microsoft Office Home & Student in PCWorld’s Software Store ]

This article was translated from German to English and originally appeared on pcwelt.de.

Arne Arnold arbeitet seit über 15 Jahren bei der PC-WELT als Redakteur in den Bereichen Software und Internet. Sein Schwerpunkt liegt auf dem Thema Sicherheit für Endanwender bei PC und Mobil-Geräten.

Recent stories by Arne Arnold:

This scary AI recognizes passwords by the sound of your typingHow to prevent the Brave browser from saving sites you’ve visitedHow to import data from paper into Excel

Related posts

The Full Nerd ep. 176: Tiger Lake H45 revealed, Ryzen 5000U battery concerns debunked

admin

The Upload: Your tech news briefing for Wednesday, April 15

admin

Amazon's new initiative aims to help people discover digital health benefits to manage chronic conditions

admin

Leave a Comment