1. Mastering Image-to-Excel Conversion: A Step-by-Step Guide for Microsoft Windows

Quick Links

• Load Data From a Picture
• Review and Edit the Picture Data
• Insert the Picture Data

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.

vMix Basic HD - Software based live production. vMix Basic HD includes 4 inputs, 3 cameras, streaming, recording, playlist.
This bundle includes Studio 200 for vMix from Virtualsetworks, HTTP Matrix 1.0 automation scheduler, and 4 introductory training videos from the Udemy vMix Basic to Amazing course.

When you select a field in the table, you’ll also see that section highlighted in your picture.

Choose a field in the table that you want to edit, make your change in the box that appears, and click “Accept” to adjust the data.

Alternatively, you can move through each field one at a time by clicking “Review.” You’ll then see each highlighted field open one-by-one for you to make your changes. Click “Accept” when you finish with each edit to move on to the next.

Jet Profiler for MySQL, Enterprise Version： Jet Profiler for MySQL is real-time query performance and diagnostics tool for the MySQL database server. Its detailed query information, graphical interface and ease of use makes this a great tool for finding performance bottlenecks in your MySQL databases.

PCDJ DEX 3 for Windows & MAC is the total entertainment DJ software solution, offering audio, video, and karaoke mixing ability. Automatic beat-sync, smart looping, 4 decks, DJ MIDI controller support, Karaoke Streaming and much more.
DEX 3 meets the demands of today’s versatile DJ, without compromise!
DEX 3 (Audio, Video and Karaoke Mixing Software for Windows/MAC | 3 Activations and Free Updates)

Insert the Picture Data

When you have reviewed and edited all necessary data from the picture, you can select “Insert Data” in the sidebar to place the data in your spreadsheet. You may then see a prompt letting you know that you’re responsible for the accuracy of the data. Click “Insert Data” to continue.

The data then appears in your spreadsheet and the sidebar closes. From there, you can manipulate or make any additional changes you want to the data in your sheet.

Having the ability to load data from a picture into Excel is a terrific alternative to replicating the data manually.

For more ways to save time in Excel, look at how to use themes for colors and fonts or how to create chart templates you can reuse.