Tables are everywhere in photos and screenshots: a shop price list, a marks sheet on a notice board, an invoice from a supplier, an attendance register, a screenshot of a report someone sent on WhatsApp. Typing all those numbers into Excel or Google Sheets takes ages and invites mistakes. OCR can read the table for you. This guide shows how to convert an image of a table to Excel for free, how to clean up the columns, and when to use a PDF converter instead.
How image-to-Excel conversion works
When you upload a picture of a table, an OCR engine first finds the text on the image, then reads each word and number. It keeps track of where each piece of text sits, so it can rebuild rows from left to right and top to bottom. The output can then be pasted into a spreadsheet, where each line becomes a row. The cleaner and straighter the table in your image, the better the rows line up.
The Ocr4you JPG to Excel page extracts the table text from your image in rows that are ready to paste into Excel or Google Sheets. It does not create an .xlsx file for images; you paste the result into a sheet and save it there. For PDFs, the PDF to Excel converter works on the PDF directly.
Step by step: image of a table to Excel
- Take a straight, well-lit photo or screenshot of the table. Crop away everything that is not part of the table.
- Open the JPG to Excel page on Ocr4you. JPG, PNG and screenshots all work.
- Upload the image and select the language of the text.
- Click Convert and wait a few seconds.
- Copy the extracted text.
- Open Excel or Google Sheets, click cell A1 and paste.
- If each row lands in a single column, use Data > Text to Columns (Excel) or Data > Split text to columns (Google Sheets), choosing space, tab or comma as the separator.
- Check totals and key numbers against the original image, then save.
Splitting text into proper columns
Pasted OCR text often arrives as one line per row. Splitting it correctly is the key step:
- Tab or multiple spaces: in Excel, Text to Columns with Delimited, then tick Space and "Treat consecutive delimiters as one".
- Item names with spaces: if a product name like "Basmati Rice 5kg" splits into three cells, use Fixed width instead, or merge those cells back with a formula such as =TEXTJOIN(" ",TRUE,A2:C2).
- Google Sheets: select the column, choose Data > Split text to columns, and pick a custom separator if needed.
- Numbers stored as text: select the column and use Convert to Number, or multiply by 1 in a helper column.
Getting clean results from photos of tables
- Shoot straight on: a tilted photo makes rows slope, and the OCR may mix two rows together.
- Fill the frame: the table should take up most of the image so small digits stay readable.
- Avoid glare: laminated price lists and glossy paper reflect light. Turn off the flash and tilt the paper slightly away from the light source.
- Split big tables: a wide register with many columns is easier to read in two halves. Convert each half and paste side by side.
- Prefer screenshots: if the table exists on a screen, a screenshot is sharper than a photo. See Screenshot to Text for more tips.
Handwritten tables and registers
Attendance registers, stock books and handwritten bills can also be converted, but numbers written by hand are easy to misread: a 1 can look like a 7, and a 5 like an S. Use the Handwriting to Text page for neat handwritten tables and always double-check amounts and totals. A quick SUM formula compared with the total written on the page catches most errors.
Tables in Hindi and other Indian languages
Ration lists, school results and government notices often have headings in Hindi or a regional language. Select the right language before converting so that names and headings come out correctly. For Devanagari text, the Hindi image to text page is tuned for that script, and our guide on free OCR for Indian languages covers other scripts. Remember that some documents use Devanagari digits; convert them to standard digits if you need to calculate with them.
When to use PDF to Excel instead
If your table is inside a PDF, such as a bank statement, a GST report or a price list exported from software, use the PDF to Excel converter. It works on the whole document and keeps more of the structure than a photo of the screen. Our article on converting bank statements from PDF to Excel walks through that process. For scanned PDFs, the OCR step is the same; the converter reads the page images for you.
Practical uses
Shops and small businesses
Turn supplier price lists and handwritten bills into a sheet to compare rates and track stock.
Teachers and schools
Convert printed marks sheets and attendance lists into spreadsheets for quick calculations.
Accounts and expenses
Move receipts and invoice tables into a sheet for monthly expense tracking.
Research and data entry
Capture tables from books, reports and screenshots without manual typing.
Accuracy checklist before you use the data
- Compare the row count with the original image.
- Check that totals match using a SUM formula.
- Look for common swaps: 0 and O, 1 and l, 5 and S, 8 and B.
- Confirm decimal points and commas in amounts, especially in Indian number formatting like 1,25,000.
- Keep the original image saved with the spreadsheet for reference.
Why use Ocr4you for tables?
- Free online OCR that works in mobile and desktop browsers.
- Reads JPG, PNG and screenshots, in English and many Indian languages.
- Output in rows that paste cleanly into Excel and Google Sheets.
- PDF to Excel, PDF to Text and Image to Text in one place.
Frequently asked questions
Can I convert an image of a table to Excel for free?
Yes. Upload the image on the Ocr4you JPG to Excel page, copy the extracted rows and paste them into Excel or Google Sheets.
Does it create an .xlsx file directly?
For images, the tool extracts the table text in rows that you paste into a spreadsheet and save. For PDFs, use the PDF to Excel converter.
Why does all my data go into one column?
Pasted text often lands in column A. Use Text to Columns in Excel or Split text to columns in Google Sheets to separate it.
Can it read handwritten tables?
Yes, if the writing is neat. Handwritten numbers are easy to misread, so check amounts and totals carefully.
Can I convert a screenshot of a table to Excel?
Yes. Screenshots are sharp and usually give the cleanest results. Crop to the table before uploading.
Try it now: JPG to Excel is free to start and works on mobile and desktop.
Open JPG to Excel