How do I convert a photo of a table into Excel?

The quickest route is optical character recognition (OCR), which reads the text in a photo and places it into editable cells. Take a flat, well-lit, square-on photo, run it through a table-aware OCR tool or your spreadsheet program's picture import, then check every figure against the original before you rely on it.

What is the quickest way to turn a photo of a table into a spreadsheet?

The quickest way is OCR, short for optical character recognition. It looks at the image, recognises the characters and, with table-aware tools, works out which text belongs in which row and column.

In practice the steps are:

1. Take or find a clear photo of the table.
2. Open a tool that offers table or picture import. Many spreadsheet programs have a "data from picture" option, and several phone apps and online converters do something similar.
3. Upload the image and let the tool detect the table.
4. Review the preview and correct any obvious misreads before importing.
5. Insert the result into a worksheet and save it as a spreadsheet file.

For one small table this can take a couple of minutes. For longer documents, the time you save depends on how clean the original is.

Whatever tool you use, treat the output as a first draft. OCR is good at layout and reasonably good at text, but it can confuse similar-looking characters, such as 5 and S, 1 and 7, or 0 and O. Those slips matter in financial figures, so build a checking step into the process every time, however tidy the result looks on screen.

How should I take the photo so the conversion is accurate?

Most poor conversions are caused by a poor photo, so a minute spent on the image saves a lot of correction later.

Get the angle right. Hold the camera directly above the page, parallel to the table, rather than shooting from the side. Slanted photos distort columns and make rows drift.

Use even light. Avoid shadows from your hand or phone, and avoid glare on glossy paper. Daylight from a window usually works well.

Fill the frame. Get close enough that the text is sharp, but keep all four edges of the table in view so the tool can see the grid.

Flatten the paper. Creases, curled corners and folds bend lines of text and cause misreads. Weigh the corners down if you need to.

Keep it in focus. Tap the screen to focus, and hold still or rest your elbows on the desk.

Crop and straighten. Trim away the background and rotate the image so the text is level.

If you can, use your phone's document-scan mode instead of the standard camera. It usually corrects perspective and boosts contrast automatically, which gives the OCR a much better starting point.

What can I do if the columns or rows come out wrong?

Misaligned columns are the most common complaint. Text from two columns merges into one cell, or a single row splits across two lines.

Try these fixes in order:

• Re-take the photo. A straighter, sharper image often solves the problem outright.
• Crop to one table at a time. If the page has headings, notes and several tables, tools can get confused. Isolate the part you need.
• Increase the contrast. A black-and-white or high-contrast version can make faint gridlines clearer.
• Try a different import option. Some tools offer a plain text mode as well as a table mode. Plain text can be easier to split afterwards.

If the data lands in the sheet but in the wrong shape, spreadsheet features can tidy it up. "Text to columns" splits one cell into several using a space, comma or tab. Find and replace removes stray symbols, and trimming functions strip extra spaces that stop numbers being recognised.

Watch for numbers stored as text. If they are left-aligned or won't add up, convert them to proper numbers before doing any calculations. Dates can also be misread, particularly when day and month are swapped, so check a few against the original.

How do I check the converted numbers are correct?

Never assume the conversion is right just because it looks right. A short, repeatable check catches most errors.

Compare totals. If the original table has a total, add up the converted column and see whether it matches. A difference tells you at least one figure is wrong.

Count the rows. Make sure the number of rows in your sheet matches the number in the original. Missing or duplicated lines are easy to overlook.

Scan for odd values. Sort each numeric column from smallest to largest. A stray letter, an extra zero or a negative sign that has gone missing often stands out at the top or bottom.

Check the usual suspects. Look closely at figures containing 0, 1, 5, 7 and 8, plus decimal points and commas, which are the characters most often misread.

Spot-check against the source. Read a sample of rows aloud against the original, then check any that looked unusual in the earlier steps.

Use formulas for reconciliation. For invoices, test that quantity multiplied by unit price equals the line total, and that line totals plus VAT equal the invoice total. For statements, check that the running balance agrees from row to row.

Keep the original image alongside the finished file so anyone can trace a figure back to its source.

Does the same method work for invoices and bank statements?

Yes, the same principles apply, but these documents bring extra challenges.

Invoices often mix a table of line items with free-standing details such as supplier name, invoice number, date and VAT. Convert the line items as a table, then enter or copy the header details separately. Check that the VAT and totals reconcile.

Bank statements usually run over several pages, with repeated headers and running balances. Convert each page in turn, delete the repeated header rows, and check that the closing balance on one page matches the opening balance on the next. A break in the sequence points to a missed or misread line.

Scanned or faxed copies are harder than clear photos because the text is often faint or speckled. Expect more correction.

A few practical cautions:

• Check what happens to your images. Financial documents contain sensitive details, so read the privacy terms of any free online converter before uploading.
• Remove or protect anything you don't need to share.
• Consider whether the time spent correcting a poor-quality batch is greater than the time it would take to retype it.

For occasional, clean documents, doing it yourself works well. For large or messy batches, the checking is where most of the effort goes.

Frequently asked questions

Can I convert a photo to a spreadsheet for free?

Often yes, for occasional use. Some spreadsheet programs and phone apps include picture import, and free online converters exist. Check their limits and privacy terms, especially for financial documents.

Why are some of my numbers showing as text?

OCR can include stray spaces, symbols or the wrong decimal character, so the spreadsheet doesn't recognise the value as a number. Clean the cells with find and replace or trim, then convert them to numbers.

Is a scanned PDF easier to convert than a photo?

Usually, if the scan is flat and sharp, because it avoids shadows and perspective distortion. A poor, skewed or faint scan can be just as difficult as a poor photo.

Do I still need to check the result after using OCR?

Yes. OCR can misread characters without any warning, so compare totals, row counts and a sample of figures against the original every time.

Related on B.A.I.S.

• Everything we can build for you
• How do I convert a PDF bank statement to Excel in the UK?

B.A.I.S. turns scanned PDFs and photos of tables, invoices or statements into a clean, checked Excel file, so you don't have to retype or correct them yourself. Send us your scans or photos and we'll return a spreadsheet that is ready to use.

---

Need this done for you? Scanned PDF or photo to a clean Excel file