How to Copy Data from Image to Excel
Ever found yourself staring at a data table in a screenshot, PDF, or picture, dreading the thought of manually typing everything into a spreadsheet? It’s a tedious task that drains your time and is prone to typos. The good news is that you can stop manually transcribing data. Modern versions of Excel can “read” the data directly from an image and import it into a spreadsheet for you.
This article provides a complete step-by-step guide to copying data from any image directly into Excel. We’ll cover Excel’s powerful built-in tool for desktop and mobile, as well as a great alternative for more complex images.
Free PDF · the crash course
AI Agents for Marketing Crash Course
Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.
Using Excel’s Built-In 'Data from Picture' Feature
The easiest way to get data from an image into a spreadsheet is by using Excel’s native feature called Data from Picture. It uses Optical Character Recognition (OCR) technology to scan the image, identify the tabular data, and convert it into editable cells. This feature is available in Microsoft 365 versions of Excel on both desktop and mobile.
On Excel Desktop (Windows & Mac)
The desktop version gives you two options: importing from a saved image file or from an image you’ve copied to your clipboard (like a screenshot).
- Navigate to the Data Tab: Open a new or existing workbook in Excel. Click on the Data tab in the main ribbon.
- Select 'From Picture': In the "Get & Transform Data" section, you’ll find an option labeled From Picture. Click it.
- Choose Your Image Source: You'll see two choices:
- Review the Imported Data: Once you select your image, Excel will analyze it, and a "Data from Picture" pane will open on the right side of your screen. This pane shows you a snapshot of your original image at the top and the recognized data in a grid below.
- Correct Any Errors: Click on any red-highlighted cell in the data grid. Excel will zoom in on that specific part of the original image so you can compare it. Type the correct value into the text box and click Accept. You can cycle through all the items needing review using the "Review" button. It’s always a good idea to quickly scan the non-highlighted cells, too, as OCR isn't always perfect.
- Insert the Data: Once you’re happy with the preview, click the Insert Data button at the top of the pane. A warning may pop up reminding you to double-check the accuracy of the imported data. Click Insert Data again, and the information will instantly appear in your worksheet, formatted in rows and columns.
From there, you can format the data as needed, such as changing text to numbers or applying date formats.
On the Excel Mobile App (iOS & Android)
The mobile app makes it incredibly simple to capture data from a physical document, like a printout, a receipt, or notes on a whiteboard.
- Open Excel and Start a New Workbook: Tap the Excel app on your phone and open a blank sheet.
- Tap the 'Insert Data from Picture' Icon: Select any empty cell. A menu will appear at the bottom. Find and tap the icon that looks like a small camera over a table grid - this is the Insert Data from Picture button.
- Capture the Image: Your phone’s camera will open. Position the camera so the data you want to capture is clearly visible within the red border. Ensure the lighting is good and your hand is steady. Tap the white circle button to take the picture.
- Crop and Confirm: After taking the photo, you can adjust the cropping rectangle to include only the relevant data table. Once you’ve framed it correctly, tap Confirm or Done.
- Review and Insert: Excel will process the image. Just like on desktop, you'll get a preview of the recognized table. Tap on any highlighted cell to make corrections. When satisfied, tap Insert, and the data will populate your spreadsheet.
Alternative Method: Using Online OCR Tools and 'Text to Columns'
What if you're using an older version of Excel, or the "Data from Picture" feature is struggling with a particularly complex or low-quality image? In a pinch, a web-based OCR tool can be a great backup.
These tools work by analyzing your uploaded image and giving you back plain text. You can then copy this text and use Excel's Text to Columns feature to structure it properly. Here's the general process:
- Find an Online OCR Tool: There are many free options available with a quick web search for "online OCR from image."
- Upload and Convert: Upload your image file to the website. The tool will process it and generate a block of text. Often, it will try to preserve spacing to mimic columns.
- Copy and Paste into Excel: Select all the converted text and copy it. Go to an empty Excel sheet and paste it into a single cell (e.g., A1).
- Use 'Text to Columns' to Organize: This is the key step. Since all your data is likely stuck in Column A, you need to split it.
Tips for Best Results
To improve the accuracy of any OCR process and minimize manual corrections, follow these simple tips:
- Start with a High-Quality Image: This is the most important factor. The data should be in focus, well-lit, and not blurry. Avoid images with shadows cast over the numbers or text.
- Ensure Good Contrast: Plain dark text on a light background works best (e.g., black text on a white sheet of paper). Avoid colorful or patterned backgrounds if possible.
- Get the Angle Right: When taking a photo, position your camera directly above the document, not at an angle. A slanted perspective can distort the characters and confuse the OCR software.
- Simpler is Better: The feature works best with simple, grid-like tables. Complex tables with merged cells, nested headers, or multiple sub-tables might need manual clean-up afterwards.
- Always Double-Check the Numbers: Meticulously review all imported numbers, dates, and special characters. It's easy for the OCR to misread a '5' as an 'S', an '8' as a 'B', or miss a decimal point.
- Format After Importing: Remember that Excel will likely import all data as "General" or "Text" format. You may need to select columns and manually change the format to Number, Currency, or Date to perform calculations.
Free PDF · the crash course
AI Agents for Marketing Crash Course
Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.
Final Thoughts
Getting data from an image into Excel is no longer a painstaking manual process. By using the built-in "Data from Picture" feature or a backup OCR method, you can transform static data into an interactive spreadsheet in just a few clicks, saving valuable time and reducing the risk of errors.
Manually transferring data - whether from an image or a different application - is often the biggest roadblock to clear analysis. Once you've mastered getting data out of images, you'll see how valuable it is to automate data collection from all your sources. We designed Graphed to do exactly that for your marketing and sales platforms. By securely connecting tools like Google Analytics, Shopify, and Salesforce, we make creating real-time dashboards as easy as asking a question in plain English, eliminating tedious reporting tasks for good.
Related Articles
Facebook Ads for HVAC Companies: The Complete 2026 Strategy Guide
Learn how HVAC companies can generate leads with Facebook ads in 2026. Comprehensive guide covering targeting, ad creative, budgets, and proven tactics.
Facebook Ads for Physical Therapists: The Complete 2026 Strategy Guide
Learn how to use Facebook ads for physical therapists to attract new patients in 2026. Complete strategy guide with targeting, ad creative, instant forms, budget guidelines, and follow-up best practices for cash-pay PT practices.
Facebook Ads for Clinics: The Complete 2026 Strategy Guide
Learn how to use Facebook Ads for Clinics to grow your patient base in 2026. Complete guide covers targeting, campaign types, and compliance requirements.