Skip to content

How to Copy a Table from a Picture into Excel (and Fix What Goes Wrong)

Four ways to get a table from a photo or screenshot into Excel, then the fixes that matter: numbers stored as text, lost zeros, flipped dates and totals that do not add up.

Use the free tool now — skip the reading if you already know what you need.
Open the free tool
How to Copy a Table from a Picture into Excel (and Fix What Goes Wrong)

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:

  1. Upload the image. Pick one where the whole table is visible.
  2. Start the conversion. OCR runs in the background, so the job may queue for a moment.
  3. 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:

  1. Count the rows in the sheet and compare with the picture. A missing or doubled row is easy to miss by eye.
  2. Check the first row, the last row and five in the middle against the image.
  3. 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

  1. Crop and straighten the image so only the table is left.
  2. Convert it with Image to Excel, or with Data from Picture if your Excel has it.
  3. Compare the row count with the picture.
  4. Fix numbers stored as text, then dates, then leading zeros.
  5. Add a check cell for every total and make sure it reads zero.
  6. 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.

Frequently asked questions

OCR reads numbers as characters, and Excel sometimes keeps them that way. Left-aligned numbers and a small green triangle in the cell corner are the giveaway. Select the cells and use Convert to Number, or type 1 in a blank cell, copy it, then Paste Special with Multiply on the range.

Excel treats a column of digits as numbers, and numbers do not keep leading zeros. Format the column as Text before you retype the values, or start each entry with an apostrophe. Then check the original image to see how many zeros each code really had.

A date like 04/05/2026 can mean 4 May or 5 April, and Excel follows your computer's regional setting. Check one date you know against the image. If it is flipped, set the column format to match the order on the page and retype a few values to confirm.

Compare the row count with the image, then check the first row, the last row and a few in the middle. Add a check cell that subtracts the printed total from SUM of the column. It should be zero. Sort the biggest and smallest numbers to the top and check those against the picture too.

Some Microsoft 365 versions have a Data from Picture option on the Data tab or in the mobile app. Availability depends on your version and device, so check your menu. If it is missing, a free OCR tool does the same job in a browser.

Many phones can copy text from a picture, but you usually get lines of text, not rows and columns. Paste it into Excel and use Text to Columns on the Data tab to split it. For anything longer than a handful of rows, an OCR table converter is quicker.

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 takes the value from the cell above it.

Convert each half separately and paste the second half under the first in one sheet. Delete any row that appears in both halves, and check the join, because that is where a row is most likely to be missed or doubled.

PdfPeaks Image to Excel reads printed Urdu and English. Check that the columns match the order in the picture. If the sheet looks mirrored, Sheet Right-to-Left on the Page Layout tab flips the view without changing the data. If Urdu shows as boxes, switch the font to one that includes Urdu letters.

OCR then has to work out columns from the spacing alone, so wide gaps and uneven alignment can push values into the wrong column. Crop tightly to the table and check the first few rows. If the columns drift, retake the photo straight on.

Crop out anything you do not need, such as account numbers, CNIC numbers and addresses, before you upload. Read the PdfPeaks Privacy Policy to see how files are handled, and do not upload anything you would not be comfortable sending to a third party.

Treat them as a prompt to look, not a verdict. If the printed total and the sum of the rows disagree, either a digit was misread or the printed total was wrong. Both happen, so check the image.
Image to Excel Converter – JPG & PNG OCR to XLSX | PdfPeaks PdfPeaks Image to Excel Converter – JPG & PNG OCR to XLSX | PdfPeaks Convert image to Excel online free. Upload a JPG, PNG, screenshot or scanned table and get an editable XLSX file with OCR. No signup needed.

Discussion

0 approved comments

Join thread

No comments yet. Start the discussion.