You have a table you can see but cannot select. Maybe it is a mark sheet someone sent on WhatsApp, a price list photographed on a shop counter, or a screenshot from a system that blocks copying. Dragging the mouse across it does nothing, and retyping 80 rows is nobody's idea of a good afternoon.
There are a few ways to get that table into Excel. One is built into some versions of Excel, one is a free OCR converter, one is your phone, and one is plain typing. Which is quickest depends on how big the table is and how clean the picture is. This guide goes through each, then spends most of its time on the part other guides skip: what the spreadsheet looks like after OCR, and how to fix it before a wrong number ends up in something that matters.
First, check what kind of image you have
Not every table in an image needs OCR. Try selecting the text first. If it highlights, it is not really a picture, and you can copy it straight into Excel.
If the table sits inside a PDF that you can open, skip image tools altogether. Use PDF to Excel, and read how to extract tables from a PDF into Excel for the PDF side of this problem.
If it really is a photo, screenshot or scan, you need OCR, which is software that reads the letters and numbers in a picture. Printed tables work well. Handwritten tables are hit or miss, and I would plan on fixing a lot of cells by hand.
Four ways to get a table from a picture into Excel
1. Excel's own Data from Picture
Some Microsoft 365 versions have a Data from Picture option, either on the Data tab or in the mobile app. You point it at a photo or a screenshot on your clipboard, it shows you what it found, and you confirm before it drops the data into cells.
The catch is availability. It depends on your version, your operating system and sometimes your account type, so you may open the menu and find nothing there. If it is there, try it first. It costs nothing.
2. A free OCR converter
Image to Excel takes a JPG, PNG, WebP or TIFF and gives you back an .xlsx file. The steps are short:
- Upload the image. Pick one where the whole table is visible.
- Start the conversion. OCR runs in the background, so the job may queue for a moment.
- Download the .xlsx and open it in Excel, Google Sheets or LibreOffice.
It reads printed Urdu and English, which matters if your mark sheet or price list mixes both. It does not keep fonts, colours or merged-cell styling, so expect to redo the formatting. What you are paying for, in effect, is not retyping the data.
3. Your phone's copy-text feature
Many phones can lift text out of a photo. That gets you lines of text, not a grid. Paste it into Excel, then use Text to Columns on the Data tab to split each line into cells. It works for a handful of rows. By row 30 you will wish you had used a converter.
4. Retype it
If the table has under 20 cells, typing is honestly faster than uploading, converting, downloading and checking. I mention this because people skip it out of habit and spend five minutes saving two.
Get a better picture before you convert anything
OCR can only be as good as the picture, and most bad conversions start with a bad photo. A few things make a bigger difference than any setting.
Shoot straight on, with the page flat. A tilted photo bends the rows, and columns start to drift. If you already have a crooked picture, straighten it with Rotate Image and trim it with Crop Image so only the table is left. Logos, stamps and margins give OCR extra things to misread.
Do not shrink a tall table to fit it on one screen. If the text gets small, split the table in two photos instead. Small print is where 5 turns into S and 8 turns into B.
Avoid pictures that have been through WhatsApp several times. Each forward compresses the image again. Ask the sender to share the original as a document if they can. If you only have a messy phone shot, the scan mode in JPG to PDF flattens shadows and straightens edges, and our guide on scanning documents to PDF without a scanner shows how.
What a freshly converted sheet usually looks like
Even a good conversion leaves small problems behind. They are the same few every time, so once you know them, cleanup takes minutes. Here are the seven I see most.
Numbers that are really text
The most common one. Numbers sit on the left side of the cell instead of the right, a green triangle shows up in the corner, and SUM returns zero. Select the cells, click the warning icon and choose Convert to Number. If there is no icon, type 1 in an empty cell, copy it, select your numbers, and use Paste Special with Multiply. Excel then treats everything as a real number.
Letters pretending to be digits
OCR confuses O and 0, l and 1, S and 5, B and 8. In a column of numbers, add a helper column with =ISNUMBER(B2) and filter for FALSE. Every cell that fails is a candidate for a misread. Fix them one by one. Do not run Find and Replace across a whole sheet, because you will change letters in names that were correct.
Leading zeros that vanished
Phone numbers, roll numbers and product codes often start with 0, and Excel drops it from anything it thinks is a number. Format the column as Text before you retype the values, or start each one with an apostrophe. Then look at the image to see how many zeros the original really had.
Dates that flipped
Is 04/05/2026 the fourth of May or the fifth of April? Excel decides using your computer's regional setting, and OCR cannot help. Check one date you know against the picture. If it is flipped, set the whole column to the order printed on the page.
Two columns glued into one, or one split in two
When the gap between columns is narrow, OCR can merge them into a single cell. Select the column and use Text to Columns on the Data tab, splitting by space. The opposite problem, one value broken across two cells, is easier. Join them with the & operator, then paste the result as values.
Blank cells where a merged cell used to be
A heading or a group name that spanned several rows in print often lands in the first row only. Select the column, press F5, choose Special, pick Blanks and press OK. Type an equals sign, press the Up arrow, then press Ctrl and Enter together. Every blank fills from the cell above.
Stray spaces
Extra spaces make two identical names look different to Excel and break lookups. Use =TRIM(A2) to clean them. If TRIM does nothing, the space is probably a non-breaking one, which you can remove with =SUBSTITUTE(A2,CHAR(160)," ").
Check the totals before you trust the sheet
This is the step that saves you. A table that looks right can still carry one wrong digit, and one wrong digit in a total is how people end up sending a bad invoice or a wrong result.
If the table has a Total row, add a check cell next to it. Something like =SUM(B2:B20)-B21, where B21 holds the printed total. It should come out as zero. If it does not, either OCR misread a digit or the printed total was wrong. Printed sheets have mistakes more often than you would think, so look at the image before you blame the software. The PdfPeaks tool adds a check note to the sheet when the last row says Total and the numbers disagree. Take that as a nudge to look, not as a verdict.
A few more checks that take a minute:
- Count the rows in the sheet and compare with the picture. A missing or doubled row is easy to miss by eye.
- Check the first row, the last row and five in the middle against the image.
- Sort the biggest and smallest numbers to the top and check those first. A misplaced digit does the most damage there.
Urdu and mixed-language tables
If your table has Urdu text, check that the columns come out in the order you see them in the picture. If the sheet looks mirrored, Sheet Right-to-Left on the Page Layout tab flips the view without touching the data. If Urdu shows as empty boxes, the font has no Urdu letters. Switch to one that does.
Names are another trap. The same name can be spelled several ways in English, which is a problem when you join two lists. Our guide on Urdu to English name spelling explains why that happens and what to standardise on.
Where this usually goes wrong
Some tables are just hard. Handwriting, curved book pages, heavily shaded cells, tiny print and tables with no gridlines at all will all produce messy output. When that happens, retake the picture, crop tighter, or retype the table. Sometimes typing it out is faster than cleaning up a bad conversion.
If the picture is mostly paragraphs rather than rows and columns, you want text, not a spreadsheet. Use Image to Word, and our guide on converting a JPG or photo to an editable Word document covers that case.
If you are the one creating the paperwork, there is a way to avoid all of this. Receipts and invoices you make yourself in the Receipt Maker never need OCR, because the numbers are already real numbers.
A routine you can reuse
- Crop and straighten the image so only the table is left.
- Convert it with Image to Excel, or with Data from Picture if your Excel has it.
- Compare the row count with the picture.
- Fix numbers stored as text, then dates, then leading zeros.
- Add a check cell for every total and make sure it reads zero.
- Save the result as a new file and keep the original image next to it.
Conversion takes under a minute. The checking takes about ten. Do both, and the spreadsheet is yours to use. Skip the second part and you have a table that looks fine until it is not.
No comments yet. Start the discussion.