Excel can convert an image to text in cells with its built-in Data From Picture tool. You give it a picture file, a screenshot or a phone camera shot of a table. Excel reads the text, shows a review step, and inserts the result as cells. It suits one small table better than a long statement.
Where is Data From Picture in Excel?
Data From Picture sits on the Data tab in Excel for Windows, Mac and the web, and under Insert on the Excel phone app. It is a feature of Excel for Microsoft 365, so older stand-alone versions may not show it. The details below follow Microsoft's help page.
Everything here comes from Microsoft's Insert data from picture help page, which lists the page as applying to Excel for Microsoft 365. Menu names change between releases, so if a label differs on your screen, look for the same words on the Data tab.
Requirements
- Windows: Windows 11, or Windows 10 version 1903 or later, with the Microsoft Edge WebView2 Runtime installed.
- Mac and web: the page gives no minimum version for either.
- Phone and tablet: the Excel app, and the Microsoft 365 app, both work.
- Languages: the page lists supported character sets, including English, German, French, Spanish, Italian, Dutch and a number of other European languages. Text in other scripts is outside the list.
Steps on a desktop
Windows, with a picture file:
- Open the workbook and select Data > From Picture > Picture From File.
- Choose the image and wait while the Data from Picture dialog shows progress.
- Review the results and fix anything that is wrong.
- Click Insert Data.
Windows, with a screenshot: press the Windows logo key, Shift and S, drag across the table, then choose Data > From Picture > Picture From Clipboard. On a Mac the screenshot shortcut is Shift, Ctrl, Cmd and 4, followed by Data > Data from Picture > Picture From Clipboard. On the web, use Data > Data From Picture, choose the file and open it.
Data From Picture with a phone camera
The Excel phone app takes the picture itself. Tap Insert, then Data from Picture, point the camera at the table until a red border surrounds it, and tap the capture button. Excel processes the image into a table that you review before inserting.
Steps in the Excel app
- Tap Insert > Data from Picture.
- Frame the table until the red border fits around it, then tap the capture button.
- Crop with the handles if the frame took in extra material.
- Wait while Excel converts the image into a table.
- Fix any issues it raises (see the next section).
- Tap Insert.
Steps in the Microsoft 365 app
The Microsoft 365 app has its own route. Tap Actions > Image to Table, point the camera at the table and capture it. The app crops to the table, you adjust the crop and tap Confirm, and a preview appears. Tap Open to continue. If it found issues, you can choose Open Anyway to fix them in Excel, or Review to fix them in the app. Save the table after editing. The app route is handy when you are away from your desk, but the small screen makes careful review harder, so plan to recheck the figures on a larger display later.
An iPhone route on a Mac
On a Mac, Microsoft documents a third way. Right-click a cell and choose Scan Documents, and an iPhone set up for Continuity Camera takes the picture. The page links to Apple's help for that setup.
Taking a picture Excel can read
Microsoft's tips are plain: include only the data you want, shoot head-on rather than at an angle, light the page evenly and keep it in focus. A checklist for shooting a table photo goes further, covering glare, shadow and flat surfaces.
Reviewing flagged cells in the picture import pane
Flagged cells are the issues Excel raises for you to settle before you insert. On a phone, the app shows them one at a time, and you tap Ignore to leave a value or Edit to change it. Microsoft does not say what desktop highlighting means, so treat any highlight as a cell to compare with the picture.
What Microsoft says about review, and what it does not
The help page describes review on the phone: flagged issues come up in turn, with Ignore or Edit. For the desktop dialog it says to "review the results" and make corrections, but it does not say what the highlighting means. So treat any highlighted cell as "check this against the picture" and do not read more into it.
A review routine that does not depend on highlights
Highlights show only what the engine doubted. A misread it felt sure about gets no flag, so add your own checks. These take a minute or two on a small table:
- Compare the row count in the pane with the picture.
- Read the amount column down once against the picture, with your finger on the screen if needed.
- Look for letters in number columns, such as "O" for 0 or "l" for 1.
- Look for dropped or shifted decimal points.
- After inserting, select the amounts and confirm that Excel shows a Sum, not only a Count. A Count alone means some values are text.
Cleaning up after the insert
Insertion is not the end of the job. The cells arrive as text and numbers that Excel has guessed at, and the guess can be wrong. Dates may land as text, or flip day and month if your regional settings differ from the print. Amounts with a thousands separator may come in as text. Work through the columns one at a time: set each column's format, convert text numbers, and compare the first and last rows with the picture again. Keep the original image beside the workbook until the sheet reconciles, and save the workbook under a new name before you start editing.
Picture size limits for Excel's image import
The help page names no maximum picture size, no page count and no list of file types. So the safe answer to why a full-page photo fails is that Microsoft has not said, and a likely cause is that too much non-table material is in the frame.
What to try when a big photo fails
Microsoft's tips point the way, even though they do not state a limit:
- Crop to the table. The page tells you to include only the data you want.
- Split a tall table. Capture the top half and bottom half separately, with a little overlap, and import each in turn.
- Straighten the shot. Shoot head-on, not at an angle.
- Check the light and focus. A blurred full-page photo has small type that the tool cannot resolve.
- Retry with a screenshot if the table exists on screen anywhere.
Splitting adds work. You must join the pieces and delete the overlap rows, which is where a duplicated or lost transaction can slip in. Scanning paper to a flat page avoids most framing trouble, since a scanner covers the page evenly.
Is Data From Picture enough for a six-page statement?
Not usually. Microsoft's documented steps import one picture per run, so a six-page statement means six separate imports, six reviews and a join. It is a good tool for a small table and a poor fit for a long document that must reconcile.
One screenshot versus six pages
This table compares the two cases. It describes the shape of the work, not measured speed or accuracy.
| Question | One screenshot of a small table | Six-page paper statement |
|---|---|---|
| Pictures to import | 1 | 6, one per page |
| Reviews | 1 | 6 |
| Joining pages | None | Copy each page below the last, remove repeated headers |
| Running balance across pages | Not an issue | You check it yourself at every page break |
| Fits Data From Picture | Yes | Possible, but slow and error-prone |
| What a dedicated converter adds | Little | Takes the whole file, keeps pages in order, one sheet out |
A fair test before you commit
Run your real file once. Import the first page with Data From Picture, then check it with the routine above and time how long the review takes. Multiply that by the number of pages you handle each month. If the result is more time than you want to spend, that answers the question for your workload, whatever a feature list says. Also note how many cells you had to fix on that first page. Pages printed the same way tend to fail the same way, so a page with ten corrections is a warning about the other five.
When to switch
Move to a dedicated converter when any of these is true: more than two or three pages, figures that must tie to a balance, a monthly routine, or a need for CSV rather than cells. For paper statements, scanning a bank statement to Excel sets out the routine, including the page-by-page checks.
If you work on a Mac and your source is a PDF rather than a picture, the Mac guide to PDF to Excel compares the alternatives.
FastBankConvert is aimed at the digital statement PDF case, with a balance check before download. It is getting ready to open, so the get started page takes your email for the launch.