Do these 3 things before closing this tab:
1Clear out junk files and repair common Windows errors2Scan for outdated or missing drivers - takes under a minute3Repair Windows errors before they cause bigger problemsUse Excel’s built-in Data from Picture feature. Copy a screenshot containing a table, choose Data > From Picture > Picture From Clipboard, review Excel’s detected cells, correct mistakes, and select Insert Data. For a saved image, choose Data > From Picture > Picture From File. The feature extracts tabular data; it does not recreate an arbitrary page, chart, or complete workbook layout.
Microsoft documents this workflow for Excel for Microsoft 365. The same feature can use a clipboard screen capture or an image file, then shows a review panel before inserting editable cells. See Microsoft’s current instructions at Insert data from picture.
What you need before converting the screenshot
- A screenshot or image that contains a recognizable table.
- Excel for Microsoft 365, Excel on the web, Excel for macOS, or the Excel mobile app, with controls appropriate to that platform.
- On Windows, Windows 10 version 1903 or later or Windows 11, plus the Microsoft Edge WebView2 Runtime.
- If your table uses non-Latin or unusual characters, check Microsoft’s supported character list before relying on the result.
Microsoft lists these supported character sets: English, Bosnian, Croatian, Czech, Danish, Dutch, Finnish, French, German, Hungarian, Italian, Norwegian, Polish, Portuguese, Romanian, Serbian, Slovak, Slovenian, Spanish, Swedish and Turkish. A language outside this list may still produce partial results, but it is not documented as supported.
Prepare a screenshot Excel can read
Crop to the table
Remove browser chrome, menus, unrelated text and blank margins. Keep the column headings and every row you want to import. Cropping reduces the chance that Excel interprets labels or interface controls as extra columns.
#1 Best Overall
- Over 215 Microsoft Windows Excel Shortcuts
- Two-Sided Durable Laminiated Sheet
- Designed for Excel on a Windows Computer
Use a straight, focused image
Microsoft recommends an image that is focused and viewed head-on rather than at a perspective angle. Avoid blur, glare, compression artifacts and cut-off cell borders. If the source is a photograph, retake it square to the page when possible.
Preserve context that affects values
Keep headers, minus signs, decimal separators, date labels and units in the crop. Do not crop away a heading merely to make the image smaller; you may need it to interpret the imported values correctly.
Convert a screenshot copied to the clipboard (Windows desktop)
- Capture the table. In Windows, use your preferred screen-capture shortcut or utility and copy the result to the clipboard. Capture only the table area if possible.
- Open Excel and select the worksheet cell where the upper-left imported value should go.
- Open the Data tab, choose From Picture, and select Picture From Clipboard.
- Wait while Excel analyzes the image. A preview appears with detected rows and columns.
- Inspect every flagged item and compare important values with the original screenshot. Correct transcription, column, decimal and date errors in the preview.
- Select Insert Data. Excel places the reviewed result into the worksheet as editable cells.
The review is a required part of a reliable workflow, not an indication that anything went wrong. OCR can confuse characters such as 0/O, 1/I, decimal points, commas and minus signs, especially in a small or blurry screenshot.
Convert a saved screenshot file
- Save or export the screenshot as an image file and crop it to the table.
- In Excel, select the destination cell.
- Choose Data > From Picture > Picture From File.
- Browse to the image and open it.
- Review Excel’s detected data, fix errors, and choose Insert Data.
Use the file workflow when the image is already stored as a PNG, JPEG or another format accepted by your Excel installation. If the command is unavailable, confirm that you are using an edition and platform that supports Data from Picture and that your Microsoft 365 installation is current.
Use a phone or tablet
Excel for iOS or Android
- Open Excel and start or open a workbook.
- Tap Insert > Data from Picture.
- Frame the table with the camera, or choose an existing image when your app offers that option.
- Crop the image so the table is straight and fills the frame.
- Review detected issues, correct them, and insert the data into the worksheet.
Microsoft notes that the exact controls vary by mobile platform and app version. Keep the phone steady and capture the whole table, including headings.
Rank #2
- Instant Copilot. Unlock new possibilities with the dedicated Copilot key, which gives you instant access to experiences that can enhance your productivity¹.
- Enhance your experience With the new microphone mute key and snipping key
- Full keyboard experience. Features a full mechanical keyset, backlit keys, and a large trackpad for precise navigation and control. Optimal key spacing allows fast, fluid typing.
- Slim and compact Performs like a traditional, full-size keyboard.
- Clicks in place instantly Use in combination with the Surface Pro (11th Edition), Pro 9 and Pro 8* kickstand for a perfect laptop experience anywhere.
Microsoft 365 app
In the Microsoft 365 app, use Actions > Image to Table. Preview and review the detected result, then open it in Excel. This is a separate app flow, so its menus do not have to match the Excel mobile app exactly.
Which input method should you choose?
| Situation | Path | What to expect |
|---|---|---|
| Table is currently on your screen | Data > From Picture > Picture From Clipboard | No intermediate image file is required. |
| PNG or JPEG is already saved | Data > From Picture > Picture From File | Select the image from your computer. |
| iPhone or Android capture | Insert > Data from Picture | Frame, crop, review and insert on the device. |
| Microsoft 365 app workflow | Actions > Image to Table | Review the preview, then open the result in Excel. |
Verify and clean the imported worksheet
Check high-risk cells first
- Numbers with decimal points or thousands separators.
- Negative values and values enclosed in parentheses.
- Dates, times and percentages.
- Identifiers containing leading zeroes.
- Symbols, currency marks and text that resembles numbers.
- Rows that wrap or contain blank cells.
Compare totals and row counts
Count the source rows and compare them with the inserted range. Recalculate any known subtotal or total and investigate a mismatch before using the workbook for reporting. Check that each heading lines up with the intended column.
Fix formatting after the data is correct
Apply number, date and currency formats only after verifying the underlying values. Formatting a misread value can make an OCR error look plausible.
What Data from Picture can and cannot do
It is designed for table extraction
The documented purpose is to extract rows and columns from a screenshot or image and insert them as editable worksheet data. It is useful for a table displayed in a browser, a scanned table, or a photographed sheet when the image is legible.
It is not a full page or chart converter
Do not expect it to rebuild a web page’s layout, reproduce a chart as an Excel chart, preserve merged-cell design exactly, or turn arbitrary interface screenshots into a finished workbook. For those cases, you may need to recreate the layout or enter and format the data manually.
Rank #3
- EXCEL SHORTCUTS. ZERO SEARCHING. – Our bestselling reference mat puts an extensive collection of commonly used commands, formulas and helpful tricks directly beneath your fingertips so you can find answers fast, work smarter and stay in the flow.
- YOUR DESK. SMARTER. – Clearly organized sections for navigation, selection, formatting, data and functions make it easy to find the right Excel command exactly when you need it.
- LEARN, WORK & RESET – Built-in desk-exercise diagrams give you 10 quick ways to stretch, recharge and return to work feeling sharper.
- ROOM TO WORK & CREATE – The extended 31.5 x 11.8-inch Pixiecube desk mat fits a laptop or keyboard and mouse, while the soft 2 mm surface adds comfort and protects your desktop.
- BUILT FOR REAL-WORLD WORKDAYS – A rugged stitched edge helps prevent fraying, and the water-resistant, stain-resistant surface protects against scratches, spills and everyday wear—because smarter desks should work harder.
Review is always necessary
Image quality, perspective, cropping and character support affect recognition. Excel presents a correction step because the extracted result is not guaranteed to be exact.
Or skip the browser setup
If the table is on a web page, first obtain a clean image and then send that image through Excel’s Data from Picture workflow. ScreenshotNeo is a website screenshot API and MCP server; it does not convert the screenshot into spreadsheet cells, but it can provide the source image without requiring you to configure a browser.
Recommended Free Tools
One GET request returns a PNG, JPEG or WebP screenshot. The service accepts cookie or consent banners before capture and removes more than 60 known consent platforms, newsletter popups and chat widgets; each cleanup step can be disabled. Bot checks or CAPTCHAs, blank pages, timeouts, failed loads and cache hits are not billed, and the response identifies the result with X-Page-Verdict and X-Billed headers. Documentation and all request options are at screenshotneo.com/docs/.
cURL
curl -G "https://api.screenshotneo.com/v1/shot" -d access_key=YOUR_API_KEY --data-urlencode url=https://stripe.com -o shot.webpPython
import requests
r = requests.get("https://api.screenshotneo.com/v1/shot", params={"access_key": "YOUR_API_KEY", "url": "https://stripe.com"}, timeout=90)
open("shot.webp", "wb").write(r.content)Node.js
const q = new URLSearchParams({ access_key: 'YOUR_API_KEY', url: 'https://stripe.com' });
const res = await fetch(`https://api.screenshotneo.com/v1/shot?${q}`);Open the resulting image, crop it to the table if necessary, and use Data > From Picture > Picture From File in Excel. ScreenshotNeo also provides an MCP server with take_screenshot, get_page_info and capture_pdf tools for Claude, Cursor and other MCP clients. Plans include 1,000 screenshots per month free with no card; paid plans start at $5 for 3,000 shots. Create a free ScreenshotNeo account to get started.
Troubleshooting
“From Picture” is missing
Confirm that you are using an Excel edition that supports Data from Picture, then update Microsoft 365. On Windows, verify Windows 10 version 1903 or later or Windows 11 and install the Microsoft Edge WebView2 Runtime. Platform menus differ, so check the Microsoft support page for your edition.
Excel imports the browser interface as data
Recapture or crop the image so only the table remains. Include the header row but remove tabs, buttons, sidebars and surrounding page text.
Rank #4
- Efficient Media Controls: The Wired Keyboard 600, designed by Microsoft, features a Media Center with four hot keys for easy control of play/pause, volume up, volume down, and mute functions.
- Quiet and Responsive Keys: Enjoy a comfortable typing experience with quiet, thin-profile keys that are both responsive and efficient.
- Convenient Shortcuts: Quickly access common tasks with dedicated shortcut keys, including a calculator hot key and a Windows start screen key.
- Spill-Resistant Design: Work confidently with a spill-resistant design that protects your keyboard from accidental messes.
- Plug-and-Play Simplicity: No software needed—just connect the keyboard to your PC and start using it right away, with a full number pad for efficient data entry.
Columns are shifted
Use a higher-resolution, head-on capture with visible column boundaries. In the review panel, correct the affected cells before insertion rather than trying to repair an entire column afterward.
Letters and numbers are confused
Enlarge the source, remove blur and inspect characters such as O/0, I/1, S/5, commas, decimal points and minus signs. Verify identifiers with leading zeroes manually.
Dates or decimals are wrong after insertion
Compare the inserted text with the screenshot and check the source’s regional notation. Correct the value first, then apply the intended Excel number format.
Mobile capture will not frame the table
Move farther away, hold the device parallel to the page or screen, improve lighting and crop after the entire table is visible. If the image is already saved, use the file route on a desktop installation instead.
Crashes, No Sound, or Screen Glitches?
Random freezes, missing sound and display glitches usually trace back to one bad driver. Find and replace yours safely.Free scan · under a minutePC Slower Than It Used to Be?
A free scan shows the junk files, broken settings and background clutter dragging Windows down - then fixes them in one click.Free scan · Windows 10 & 11The table is too large or complex
Process it in logical sections with repeated headings, then verify row order and totals when combining the sections. This is safer than importing a tiny, unreadable full-page image.
Best Value
- 💻 ✔️ EVERY ESSENTIAL SHORTCUT - With the SYNERLOGIC Reference Keyboard Shortcut Sticker, you have the most important shortcuts conveniently placed right in front of you. Easily learn new shortcuts and always be able to quickly lookup commands without the need to “Google” it.
- 💻✔️ Work FASTER and SMARTER - Quick tips at your fingertips! This tool makes it easy to learn how to use your computer much faster and makes your workflow increase exponentially. It’s perfect for any age or skill level, students or seniors, at home, or in the office.
- 💻 ✔️ New adhesive – stronger hold. It may leave a light residue when removed, but this wipes off easily with a soft cloth and warm, soapy water. Fewer air bubbles – for the smoothest finish, don’t peel off the entire backing at once. Instead, fold back a small section, line it up, and press gradually as you peel more. The “peel-and-stick-all-at-once” method only works for thin decals, not for stickers like ours.
- 💻 ✔️ Compatible and fits any brand laptop or desktop running Windows 10 or 11 Operating System.
- 💻 ✔️ Original Design and Production by Synerlogic Electronics, San Diego, CA, Boca Raton, FL and Bay City, MI, United States 2020. All rights reserved, any commercial reproduction without permission is punishable by all applicable laws.
Practical reliability checklist
- Keep the original screenshot beside Excel during review.
- Confirm the number of columns and rows before inserting.
- Check totals, dates, signs, decimal separators and leading zeroes.
- Save the original image with the workbook so the source can be audited.
- For sensitive or consequential data, have a second person check the imported range.
Frequently asked questions
Can I convert a screenshot directly into an .xlsx file?
Excel’s documented process inserts recognized table data into a worksheet. You then save the workbook in the usual Excel format; it does not promise to reproduce the screenshot’s complete visual layout.
Does the feature work with every language?
No. Microsoft documents a specific supported-character list, including English and several European languages. Characters outside that list may require manual entry and verification.
Is a PDF required?
No. The documented inputs are a clipboard screen capture or an image file. A PDF is not required for the Data from Picture workflow.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
Can ScreenshotNeo replace Excel’s conversion step?
No. ScreenshotNeo captures a clean web page image; Excel’s Data from Picture feature performs the table-to-cells extraction. Use them together when you need an automated webpage capture before importing the table.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
