A friend of mine does bookkeeping for small businesses. Last week a client texted her a photo of an invoice table and asked for it in Excel. She ran it through a converter — twice, with two different tools. The first one scrambled the rows. The second produced a spreadsheet where every tracking number showed up as 1.23457E+17. She gave up and typed the whole thing by hand, then asked me: "Are all of these image-to-Excel tools just bad?"
I asked her to send me the original photo. It was taken at an angle, with a big shadow across one corner and half a desk in the background. No tool on earth was going to read that cleanly.
So before you blame the converter, here's how to get a picture of a table into Excel properly — from taking the shot to fixing the numbers Excel itself mangles.
What's actually happening when you convert an image to Excel
A lot of people assume that if they can see a table in the image, any failure to extract it means the tool is broken. There are real limits to the technology, sure — but most bad results come from feeding the tool a bad starting point. You can see the grid with your eyes. The machine often can't.
Here's what the tool is actually doing during a conversion. First, text detection scans the image and draws a box around every piece of text it finds. Then recognition reads each box and turns it into actual characters. Next, based on where those text boxes sit relative to each other and to any grid lines, the tool assigns every piece of text to a row and column, rebuilding the table structure. Finally, when the spreadsheet is generated, it decides whether each cell should hold a number, a date, or plain text.
Every one of those steps depends on the quality of the image you give it. Which is why the photo matters more than the tool.
The photo decides everything
Ever noticed that screenshots convert almost perfectly? A screen capture is dead straight, evenly lit, no shadows, no distortion — the easiest possible input. Scanners come in second, with results nearly as clean.
The disasters are angled phone photos with heavy shadows and a lot of clutter around the table. Those three things break the detection and structure steps more than any tool limitation ever will.
Five rules for shooting a table, in order of importance:
- Shoot it straight on — not at an angle
- Even lighting, no shadow across the page
- Crop out the background — desk, hands, other documents
- One table per image
- Hold the phone parallel to the page so the grid stays rectangular
Already have photos that break these rules? Don't retake them yet. Run them through the document scan tool first — it corrects perspective, evens out the background, and cleans up shadows. A fixed-up scan converts dramatically better than the raw photo. And if the table has handwritten notes or calculations scribbled on it, erase them first with the handwriting removal tool — printed text and handwriting mixed together is one of the hardest things for OCR to separate.
Garbled numbers after conversion? It's usually Excel, not the tool
This is the part almost nobody explains. You open the converted spreadsheet and see: a tracking number displayed as 1.23457E+17, the leading zeros gone from phone numbers, "1.2" suddenly showing as January 2. Eight out of ten people conclude the converter is garbage.
A lot of the time, Excel did it. Excel has a habit: anything that looks like a number gets treated as one. The consequences cascade:
- Numbers with 11+ digits get displayed in scientific notation — that's where E+17 comes from
- Numbers with more than 15 digits lose everything after the 15th digit, replaced with permanent zeros. This one is the worst: it's precision loss, and changing the format will not bring the digits back
- Entries like "1.2" or "3-5" get auto-translated into dates
- Leading zeros in things like "007" get quietly stripped away
Once you know the cause, the fixes are straightforward:
- 15 digits or fewer: the data is intact, it just displays badly. Use Data → Text to Columns, and choose Text on the final step — the number comes back
- More than 15 digits: the digits are already gone. Re-convert, and set that column's format to Text immediately after downloading
- Going forward: whenever you paste long numbers into Excel by hand, format the column as Text first, then paste. One habit, zero future headaches
The full workflow, in three steps
Step 1 — Get the image right. A screenshot is ideal. For photos: straight-on, even light, no shadows, background cropped, one table per shot. Then run it through the document scan tool to fix perspective and shadows. If there are handwritten marks on the table, clear them with handwriting removal before converting.
Step 2 — Convert. Upload the image to the image-to-Excel converter and download the .xlsx. Everything runs in your browser — no software to install, and your images aren't kept.
Step 3 — Verify. Three minutes, non-negotiable. Compare the row and column counts against the original — if only a couple are off, fix them by hand; if the layout is badly scrambled, retake the photo instead of re-running a bad image five times. Then check the formats, especially long numbers and dates, the two most commonly mangled types. Change any that came out wrong to Text.
(If your source is a PDF rather than a photo, the problems are a bit different — see our guide on why tables break when converting PDF to Excel.)
Frequently asked questions
My converted spreadsheet has rows and columns out of place. What do I do?
Go back to the image first. Angled shots, heavy shadows, and multiple tables in one image are the three most common culprits. Retake the photo or scan it first — that beats re-running a bad image through five different tools. If only two or three rows are off, just fix them manually.
Can merged cells be restored?
Simple merges usually survive; complex ones often don't. Compare against the original and re-merge the few that need it — about a minute of work.
Can it read handwritten numbers?
Some, but the error rate is far higher than for printed text. Check handwritten amounts and quantities against the original, one by one. Don't skip this.
My long numbers turned into 1.23E+17. Can they be recovered?
Depends. If it's only the display (scientific notation), change the cell format and the number comes back. If the number exceeded 15 digits, the extra digits were permanently zeroed — re-convert and set the column to Text immediately.
Do I need to install software or create an account?
No. The image-to-Excel tool runs in your browser: upload, convert, download. Your images aren't stored.
One sentence to remember: with image-to-Excel, the outcome is almost entirely decided by the original image. Lock in the order — clean up first, convert second, verify last — and your spreadsheets will come out ready to use, almost every time.
Try it now — free, no sign-up:Image to Excel · Document Scan · Remove Handwriting · Image to Word · Why PDF-to-Excel Tables Break (Guide)