Effortless Data Extraction From Images Into Excel Using Windows Tools
Effortless Data Extraction From Images Into Excel Using Windows Tools
Quick Links
If you have data from a physical source that you want to add to Excel, you have the option to snap a photo of it, save it to your computer, and upload the data into your sheet to save time.
The feature first introduced for Mac and mobile devices is now available in Excel 365 for Windows . It’s ideal for data in tables, receipts, or financials that you want to analyze and manipulate using Excel’s features. Rather than type the data in manually, let’s look at how to load it from a picture.
Load Data From a Picture
You can insert data from an image file saved to your device or available on your clipboard .
Select the sheet you want to use and head to the Data tab. Click the From Picture drop-down menu. To insert a saved image, choose “Picture From File” or to insert one from your clipboard, choose “Picture From Clipboard”.
If you choose a picture from your device, locate your image, select it, and pick “Insert.” If you choose one from your clipboard, it automatically begins loading.
A sidebar should open on the right side of the spreadsheet showing the progress as the data is extracted.
When complete, you’ll see the image at the top of the sidebar with the data beneath it.
Review and Edit the Picture Data
You may need to make slight edits to the data if it didn’t import correctly. This can include certain sets of symbols or even letters and numbers. You’ll see these fields shaded in pink, but you can also edit those in gray as needed.
- Title: Effortless Data Extraction From Images Into Excel Using Windows Tools
- Author: David
- Created at : 2024-08-28 01:34:16
- Updated at : 2024-08-29 01:34:16
- Link: https://win-dash.techidaily.com/effortless-data-extraction-from-images-into-excel-using-windows-tools/
- License: This work is licensed under CC BY-NC-SA 4.0.