Do these 3 things before closing this tab:
1Scan for outdated or missing drivers - takes under a minute2Repair Windows errors before they cause bigger problems3Fix the driver behind crashes, sound loss and screen glitchesSome links on this page are affiliate links: if you buy through them we may earn a commission, at no extra cost to you.
To turn a photo of a table into an Excel spreadsheet with your phone, use Excel’s built-in Data from Picture tool: open Excel, tap Insert > Data from Picture, capture and crop the table, correct any flagged cells, and tap Insert. If you use the Microsoft 365 phone app, the equivalent route is Actions > Image to Table, which sends the recognized table to Excel after review.
The conversion is optical character recognition (OCR), not a guarantee of a perfect transcription. A sharp, well-lit, head-on image and a careful check of numbers, dates, punctuation, totals and column alignment are essential before you rely on the spreadsheet. Menu labels can differ by app version and device.
As an Amazon Associate I earn from qualifying purchases.
The Tool Desk
Outbyte PC Repair FREERepair Windows errors before they cause bigger problemsFix Now →Outbyte Driver Updater FREEScan for outdated or missing drivers - takes under a minuteDriver Scan →What do you need before converting a table photo?
You need an iPhone, Android phone or tablet with the Excel mobile app, or the Microsoft 365 mobile app, plus a photo that clearly shows the table. The Microsoft instructions are designed for a camera image, but you can also select an existing image when the app presents that option. Keep the original paper or screen nearby so you can verify the extracted cells.
Use the latest version available for your device. Microsoft changes mobile interfaces, so the exact position or wording of a command may differ. If a command described below is missing, update the app and check Microsoft’s current Insert data from picture support page for your platform.
Popular on Amazon
- 【Strong Adsorption】The inspiration of the silicone phone suction case comes from the adhesive force of the octopus. Each suction cup phone mount is 3.15 inches long and 2.17 inches wide, with 24 independent suction cups providing a stronger and more stable suction force, so you don't have to worry about your phone falling during use.
- 【Back of Phone Suction Grip】Remove the adhesive film on the phone suction cup and stick it on the phone case. You can then fix the phone on any smooth surface, which is very convenient. (The phone suction cup cannot be removed and reused after being attached to the phone case. It is recommended to attach it to a regular phone case, not a valuable one.)
- 【Widely Used】Our non-slip silicone phone sticky grip mount attaches to almost any flat phone case and make it compatible with common mobile phones such as iPhone and Android.You can shoot, watch videos or video calls in the kitchen, gym, dance studio, bathroom and other places.
- 【Capture the Wonderful Picture】Whether you are a TikTok creator or just like to share videos and photos, this phone suction cup can help you hands-free capture wonderful videos and photos for sharing with friends.
- 【Note】You can fix the phone suction cup on a smooth surface such as a mirror or glass. If necessary, wipe the suction cup with a damp cloth to obtain stronger suction. Before releasing your hand, make sure the phone is firmly fixed. (Not applicable to rough walls, wooden surfaces, and other uneven surfaces)
- Good lighting: Illuminate the table evenly and avoid reflections or shadows over characters.
- Head-on angle: Hold the phone parallel to the page or screen. An angled image makes rows and columns harder to infer.
- Sharp focus: Tap the table to focus before capturing it; do not use a blurry or heavily compressed image.
- Tight framing: Include the table and as little surrounding material as practical. Crop away unrelated text, hands and background objects.
- Complete boundaries: Keep the first and last columns and rows inside the frame. Cutting off an edge can shift data into the wrong column.
Microsoft’s guidance specifically recommends limiting the image to the data, cropping when necessary, avoiding angled images and using good lighting. These steps improve recognition but do not remove the need for checking the result.
How do I turn a photo into Excel data in the Excel app?
In the Excel phone or tablet app, the core workflow is Insert > Data from Picture. Follow these steps in order.
- Open Excel. Start the Excel app on your phone or tablet and open the workbook in which you want the table. You can also start a new workbook if the data belongs in a separate file.
- Choose the image-to-table command. On the ribbon or command bar, tap Insert, then tap Data from Picture. Microsoft’s support instruction is: “Open Excel on your phone or tablet and tap Insert > Data from Picture.” The label may be shortened or placed in an overflow menu on a smaller screen.
- Point the camera at the table. Hold the device over the table until Excel outlines the detected table area. Keep the whole table visible and hold the phone steady.
- Capture the image. Tap the shutter button. If Excel offers an existing-photo option, choose a clear image from your gallery instead of taking a new one.
- Adjust the crop. Drag the crop handles so they include every intended row and column while excluding unrelated text. Confirm the crop when it matches the table.
- Wait for processing. Excel analyzes the image and proposes cell contents and a table layout. Processing time depends on the image and device; do not leave the review screen before the preview appears.
- Review every flagged issue. Excel marks entries it considers questionable. Tap a flagged cell to inspect the proposed value, then edit it or choose the available option to ignore the warning. Compare difficult characters with the source image rather than accepting the first proposal.
- Insert the result. When the preview is correct enough to place in the workbook, tap Insert. The recognized values are written into the sheet as cells.
- Check the inserted sheet and save it. Scan the completed range again, correct anything that changed during insertion, and save the workbook. Keep the original image until the spreadsheet has passed your checks.
The review stage is part of the intended workflow, not an optional cosmetic step. Microsoft’s support flow explicitly provides for correcting detected issues before insertion.
How do I use Image to Table in the Microsoft 365 app?
The Microsoft 365 phone app has a separate route called Actions > Image to Table. It performs the same general capture, crop and review process, then opens the extracted data in Excel.
- Open the Microsoft 365 mobile app.
- Tap Actions and select Image to Table.
- Capture the table with the camera, or select an image if the app offers that choice.
- Adjust the crop so only the intended table is included, then confirm it.
- Inspect the preview. Resolve flagged cells by editing them or dismissing a warning when the source confirms the proposed value.
- Tap Open to send the recognized table to Excel.
- In Excel, make a final cell-by-cell check and save the workbook.
If you cannot find Image to Table, use the Excel app’s Insert > Data from Picture route instead. Microsoft can move commands between versions and operating systems, and not every phone displays an identical screen.
How should you photograph the table for the best result?
OCR has to recognize both characters and the table’s structure. A photo that looks readable to a person can still cause a digit to change, a decimal point to disappear or a row to move into the wrong column.
Also popular on Amazon
- SUPERIOR COMFORT — Unlike traditional circular ear buds, the design of EarPods is defined by the geometry of the ear. Which makes them more comfortable for more people than any other ear bud–style headphones.
- HIGH-QUALITY AUDIO — The speakers inside EarPods have been engineered to maximize sound output and minimize sound loss, which means you get high-quality audio.
- BUILT-IN REMOTE — EarPods with USB-C plug also include a built-in remote that lets you adjust the volume, control the playback of music and video, and answer or end calls with a pinch of the cord.
- COMPATIBILITY — Works with all devices that have a USB-C port.
- INTEGRATED MICROPHONE — A built-in microphone precisely captures your voice while you’re on the phone, taking a FaceTime call, or summoning Siri — so you’re always heard loud and clear.
Position the phone square to the table
Hold the lens parallel to the page, monitor or printout. A perspective view makes one side of the table smaller than the other and can blur grid boundaries. Move the phone rather than tilting it to fit the table in the frame.
Control light and glare
Use broad, even light. Glossy paper and screens can reflect a lamp or window directly into the camera; move the light or your position until the characters are visible without a bright hotspot. Avoid a shadow from the phone or your hand crossing the table.
Crop tightly, but do not cut off data
Include the complete header row and every data row you need. Remove neighboring paragraphs, page numbers and unrelated tables. If the table is larger than the screen, capture sections separately with a shared header or a clearly repeated key so you can reconcile them later.
Prefer printed, high-contrast text
The documented feature is intended to recognize table data in an image. The official material does not establish a handwriting accuracy level, so do not assume that cursive notes, faint pencil marks or decorative type will convert reliably. Treat any unusual character as a verification item.
Recommended Free Tools
What should you check after Excel recognizes the table?
Read the extracted sheet against the source before sorting, calculating or sharing it. OCR can produce a plausible-looking value that is wrong by only one character, and those errors are easy to miss in a large table.
- Numbers: Check leading zeros, negative signs, decimal separators, thousands separators and digits such as 0, 6, 8 and 9.
- Dates: Confirm day/month order, four-digit years and whether a date was interpreted as text or as a date value.
- Punctuation: Inspect decimal points, commas, percent signs, currency symbols, quotation marks and hyphens.
- Headers: Make sure each heading remains above the intended column and that multi-line headings were not split into extra cells.
- Blank cells: Verify that an intentionally blank cell was not filled with a character from a nearby line.
- Totals and subtotals: Recalculate important totals independently. A transcription error in one row can make a total appear reasonable while still being wrong.
- Row and column count: Compare the number of recognized rows and columns with the original, including any final row that may have been close to the crop edge.
- Cell types: Check whether identifiers with leading zeros, telephone numbers or account codes were preserved as intended rather than converted to numbers.
Use Excel’s flagged-issue indicators as a starting point, not as a complete error detector. A cell without a warning can still be misread, especially when the source is low contrast or uses an unfamiliar layout.
Also popular on Amazon
- Secure Hold: Our PopSockets adhesive phone grip gives your cell phone a secure, comfortable hold in hand to help prevent drops while texting, taking photos, or scrolling on the go. Designed to stick firmly to most phone cases and devices.
- Hands-Free Made Easy: Easily turn your PopSocket into a phone stand to prop up your phone anywhere, perfect for watching videos, video calls, or following recipes. A must-have phone holder that keeps your device secure and ready for anything.
- Compatibility: Works with all phones, tablets, and Kindles. Sticks best to smooth, hard plastic cases and may not adhere to silicone or textured cases. Easily swap your PopTop to change up your style.
- Black PopSockets: Simple, refined, and endlessly versatile. A timeless essential for any phone.
- Travel Must-Have for People On the Go: A must-have travel accessory for flights, flying, airports, air travel, airplanes, planes, international trips, cruises, and long travel days. Key gadget for your airport haul, travel accessories and must-haves.
How accurate is photo-to-Excel conversion?
Microsoft describes the feature as using optical character recognition and machine-learning models to infer table layout and identify possible errors for review. Microsoft has not supplied a measured conversion-accuracy percentage in the sources for this guide, so no responsible workflow can promise perfect conversion.
Accuracy varies with focus, lighting, angle, print quality, font, language, table complexity and the presence of symbols. A clean, high-contrast table with simple columns is generally easier for an OCR system to interpret than a skewed photograph with merged headings, handwritten annotations or dense punctuation, but the official sources do not provide a benchmark for any of those cases.
Windows Errors? Fix Them Before They Spread
Repair common Windows errors and clear accumulated junk for a smoother, more stable PC - no reinstall needed.Free scan · no reinstallCrashes, 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 minuteThe original feature announcement on the Microsoft Excel Blog explains the OCR and layout approach and the use of error review. It was published on May 29, 2019; its historical comments should not be read as a current promise about licensing, supported devices or accuracy.
Which languages and character sets does Excel support?
Microsoft’s current support page lists these 21 supported character sets:
- English
- Bosnian
- Croatian
- Czech
- Danish
- Dutch
- Finnish
- French
- German
- Hungarian
- Italian
- Norwegian
- Polish
- Portuguese
- Romanian
- Serbian
- Slovak
- Slovenian
- Spanish
- Swedish
- Turkish
If the table uses another language or writing system, the cited documentation does not establish support. The app may still display an option, but you should check Microsoft’s current documentation for your version and validate the output particularly carefully. Mixed-language tables, uncommon symbols and specialist abbreviations also deserve a full visual comparison with the source.
Why can’t I find Data from Picture or Image to Table?
The most likely causes are a changed interface, an outdated app, a different mobile operating system or a feature that is not exposed in your current build. The documented names are Insert > Data from Picture in Excel and Actions > Image to Table in Microsoft 365, but placement can vary.
Also popular on Amazon
- [360 ° Flexible Rotation Design] Comes with a rotatable lanyard ring that supports 360 ° free rotation, effectively solving the problem of twisted and tangled lanyards
- [Wide compatibility] The ultra-thin 0.02-inch design does not block the charging port at all, and both wired and wireless charging can be used directly without removing the pad. Compatible with most smartphones such as iPhone, compatible with various wristbands, lanyards, crossbody straps, and keychains
- [Durable and Portable Material] Premium rust-resistant stainless steel material with good flexibility, which not only avoids scratching the phone case, but also has excellent anti rust and anti fading performance
- [Multi scenario Practical] Paired with a lanyard or wristband, hands-free use can be achieved. The phone is within reach and not easily dropped, ideal for daily commuting and outdoor activities. Suitable for full coverage phone cases, does not support half coverage phone cases
- [Quality Service] If you find any damage or other issues with the product upon receipt, please contact us immediately. We will handle it quickly
- Update Excel or Microsoft 365 through your device’s app store.
- Open a workbook and inspect the Insert menu, including any three-dot or overflow menu.
- In Microsoft 365, open Actions and look for Image to Table.
- Confirm that you are using the mobile app, not a mobile browser view of the service.
- Restart the app after updating and try a small, well-lit sample table.
- Consult Microsoft’s current support page for the operating system and app version if the command remains absent.
Do not assume that a missing command means the image is unusable. It may simply be located under a different menu or unavailable in that particular app build.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.What if Excel misreads a cell or the table layout?
Correct the error before inserting when possible; otherwise edit the inserted cell immediately and compare it with the source. If many cells are wrong, recapture the image instead of repairing every value manually.
- One or two wrong characters: Tap the flagged cell, compare it with the image and edit the proposed text.
- Several shifted columns: Retake the photo straight on and crop closer to the table’s grid.
- Missing first or last row: Reopen the capture and move the crop handles outward while keeping unrelated material out.
- Blurred or faint text: Improve lighting, clean the camera lens and retake the image at a closer distance.
- Wrong language assumptions: Check whether the character set is among Microsoft’s supported list and verify every nonstandard word or symbol.
- Large table: Capture manageable sections and reconcile their shared headers and keys in Excel rather than relying on one distant, low-resolution shot.
When the error rate is high, starting with a better source image is usually safer than making extensive manual corrections. Keep the original photo so another person can audit the spreadsheet later.
Does the conversion preserve formulas and formatting?
The documented feature extracts data from a picture and places the recognized result into spreadsheet cells. The cited instructions do not promise that formulas, colors, merged cells, conditional formatting, column widths or the original visual styling will be recreated exactly.
Quick wins for a faster PC:
Clear out junk files and repair common Windows errorsFree Scan →Scan for outdated or missing drivers - takes under a minuteDriver Scan →Repair Windows errors before they cause bigger problemsFix Now →After insertion, inspect the workbook as data rather than as a visual copy of the page. Reapply number formats, headings, borders and formulas that your work requires, and verify that identifiers and dates have the intended cell type. Do not treat a visually similar result as proof that the underlying values or calculations are correct.
Is a subscription required?
The 2019 Excel announcement said an Office 365 subscription was not needed at that time. That statement is historical and does not establish current licensing, account or feature availability. Microsoft’s current support instructions explain how to use the feature but do not provide a universal present-day pricing rule in the supplied material.
Also popular on Amazon
- 【PKYAA Double Sided Silicone Suction Phone Case Mount】PKYAA With Double Sided 40 Strong and Reliable individual suction cups, PKYAA provides a thicken and upgraded universal silicon suction mount for your phone.
- 【Friendly to Content Creators】If you are a content creator or an online influencer, you can create videos anywhere with this suction mount completely hands free with this silicone cell phone mount for cases.
- 【HANDS-FREE & Adhere to Mirrors】This Double Sided silicone suction phone case mount allows you to stick your phone to the mirror easily. No longer holding your phone in one hand to watch video tutorials while making up.
- 【Strong Grip on the Smooth Surface】You can easily hang your phone anywhere with a smooth surface. All you do is you clean off your phone and smooth surface. It is STURDY and it not only sticks to mirrors, it also sticks to windows, it sticks to refrigerators, tiles and other clean, flat surfaces.
- 【Press Down Firmly Every 30 Minutes】Use your palm or fingers to press the phone down firmly and check it's secure before letting go. Apply even pressure for a few seconds to allow the suction cup to adhere properly. To maintain the grip and prevent accidental falls, it's a good practice to periodically reapply pressure to the suction cup.
Use the app’s current sign-in and licensing prompts, and check Microsoft’s current product terms for your region and account type. Avoid assuming that a feature available in one mobile build has identical access conditions in another.
A reliable verification checklist
Use this short checklist before you send, import or analyze the converted workbook:
- The image is sharp, evenly lit and photographed head-on.
- The crop contains the complete intended table and excludes unrelated text.
- The recognized row and column counts match the source.
- Every flagged issue has been resolved or deliberately dismissed after comparison.
- Important numbers, dates, symbols, totals and leading zeros have been checked against the image.
- Headers align with the correct columns.
- Any required formulas, formats or styling have been recreated and checked in Excel.
- The workbook has been saved, and the original image is retained for reference.
Following the checklist turns the phone feature into a practical data-entry shortcut while keeping responsibility for the final spreadsheet with the person who verifies it.
Frequently Asked Questions
Can Excel convert a handwritten table from a phone photo?
Microsoft’s supplied instructions do not establish a handwriting-specific accuracy level. Treat handwriting, faint pencil marks and unusual lettering as unsupported or high-risk, and verify every cell against the image before using the data.
Can I convert a table photo without an internet connection?
The cited support material does not specify offline behavior or guarantee that processing works without network access. If connectivity matters, check the requirements for your exact app version and test with non-sensitive data before relying on the workflow.
What should I do with a table that is too large for one photo?
Capture several overlapping sections with clear, repeated headers or a shared identifier, then combine and reconcile them in Excel. Check that no row is duplicated or omitted at the boundaries between images.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
Can the tool read a table that contains several languages?
Microsoft lists 21 supported character sets, but the documentation does not promise identical results for mixed-language tables. Verify words, symbols and punctuation from each language separately, especially when a character resembles a digit.

