You have a printed table in front of you, or a screenshot, or a photo someone texted you, and you need it in Excel so you can sort it, total it, or paste it into a report. Retyping is slow and error-prone, and copy and paste does nothing useful with a picture. The good news is there is a clean, repeatable way to do this. The catch is that a photo is an image, not data, so one extra step does the heavy lifting: optical character recognition, or OCR.
This guide walks through the reliable method, what each tool can and cannot do, and how to keep your numbers accurate when you turn a picture into a spreadsheet.
Why you cannot just paste a photo of a table into Excel
A photo, screenshot, or scan is a grid of colored dots, not text. Excel sees one image, so when you paste it you get a picture floating over the cells, with nothing to sort, sum, or edit. The numbers are visible to you but invisible to the software. To make them workable you need OCR, which looks at the image, recognizes each character, and rebuilds it as real text that can land in separate cells. Without that recognition step, there is no data for Excel to hold.
How to convert a photo of a table to Excel
The most reliable path is to turn the image into a PDF first, then run an OCR converter that reads the page and writes a real spreadsheet. PDF is the format dedicated converters handle best, and your phone can make one in a single tap. Here is the workflow:
- Capture the table cleanly. Photograph or scan it straight on, in even light, filling the frame with the table and as little background as possible.
- Save it as a PDF. On iPhone, open the Notes or Files app, tap the scan icon, and it saves a flattened PDF. On Android, the Google Drive or Files app has a Scan option that does the same. A screenshot can be printed to PDF from any browser or viewer.
- Run OCR to Excel. Upload that PDF to an OCR PDF to Excel converter. It recognizes the text, finds the table, and writes each value into its own cell with the numbers kept numeric.
- Check the preview, then download. Confirm the columns and figures match the original before you save the .xlsx or CSV.
That last step matters more than people expect, which is why a converter that shows you the extracted table before download is worth using. You verify once and trust the file after.
How do I convert a picture to Excel on my phone?
Use your phone's built-in scanner to turn the picture into a PDF, then convert that PDF to Excel in your browser. On iPhone, open Notes, tap the camera icon, choose Scan Documents, capture the table, and share it as a PDF. On Android, open Google Drive, tap the plus button, choose Scan, then save. Once you have the PDF, upload it to an OCR converter from the same phone and download the spreadsheet. Nothing needs to install, and the scan step usually produces a far cleaner image than a plain photo because it crops, flattens, and sharpens the page for you.
Can Excel convert a picture to a table?
Yes, in a limited way. Excel for Microsoft 365 on the web and the Excel mobile apps include an Insert Data From Picture feature that OCRs a photo of a small table and drops it into the grid. It is handy for a quick, simple table you can eyeball. It struggles, though, with full pages, dense financial layouts, multiple tables, and anything you need to batch, and it asks you to confirm each value it is unsure about. For a printed statement, a stack of pages, or a document where the figures have to be right, a dedicated OCR PDF to Excel converter handles the whole page at once and keeps the columns aligned.
Can I convert a JPG or PNG to Excel?
Not directly into a clean spreadsheet, because a JPG or PNG is just an image with no text layer. The dependable route is to save the image as a PDF first, which takes one tap on a phone or a print-to-PDF on a computer, and then run OCR on that PDF to get real rows and columns. Excel's Data From Picture can read a JPG of a small table, but for full pages, financial data, or several files, converting the image to a PDF and running it through an OCR converter gives a cleaner, more reliable result you can check before you commit.
How accurate is converting an image to Excel?
On a clean, sharp image, OCR typically reads 98 to 99 percent of characters correctly, and a well-lit scan does better than a quick phone snap. It is accurate but not flawless, so treat the output as a draft you verify rather than a finished file. The errors are predictable look-alikes, such as the digit 1 read as a lowercase l, or 0 read as the letter O, which makes them easy to spot. The fastest check on financial data is to foot the total: sum the amount column in Excel and confirm it matches the printed total on the page.
Why are the numbers wrong after converting my photo?
Almost always it is image quality, not the converter. A blurry, dim, angled, or low-resolution picture gives OCR less to work with, so it guesses, and a guessed 8 becomes a 3 or a dropped minus sign turns a credit into a charge. Reshoot the table straight on, in good light, at 300 dpi or higher if you are scanning, and crop out everything but the table. If a few values still come across as text instead of numbers, see how to fix numbers that import as text, and for keeping figures exact overall, the accurate PDF to Excel converter covers the details.
How do I get the cleanest result from a photo?
Light it evenly, shoot it square, and fill the frame. Lay the page flat so it does not curl, avoid shadows falling across the figures, and hold the camera parallel to the page rather than at an angle. If your phone has a document scan mode, use it instead of the plain camera, because it crops to the page edges, removes the background, and boosts contrast automatically. A two-second better photo saves more cleanup than any setting in the converter, and it is the single biggest thing you control.
When you are doing this a lot
A one-off table is quick. A backlog is a different job. If you are regularly turning photographed or scanned documents into spreadsheets, it is worth getting the format-specific tools. Photographed receipts go cleanly into expense rows with a receipt OCR tool that extracts to Excel and CSV, scanned supplier bills convert with a dedicated invoice OCR converter, and teams running document extraction at volume across many formats often move to enterprise AI document OCR software. For your financial PDFs and scans, you can convert the first one free with the OCR PDF to Excel converter, or get fully editable cells from a scanned PDF when you need to work in the data afterward.