JPG to Excel for printed tables
Prepare a clear JPG photo, read it into editable cells, then check the worksheet before using it.
Take a table photo that is easy to read
A JPG is a useful source when the table is printed, handed over on a phone, or included in a report that you can see but cannot copy. Start by taking one image of one table. Keep the phone square to the sheet. If the left and right sides look very different in width, retake the picture so your columns stay parallel.
Use even light and avoid shadows from the phone. A white page with sharp dark text is easier to recognize than shiny paper under a bright lamp. If the picture already exists, rotate and crop it in your photo app before opening it. Include all headers and table borders you need, with a little white margin outside them.
Open the JPG and read the cells
- Open the image to Excel converter.
- Choose Open table image and select the JPG. PNG and WebP work too.
- Inspect the picture in Source image. Use Zoom to make small characters easier to compare.
- Choose Read table. Your browser loads the English reader on the first run and builds an editable grid from the image.
- Correct any cells that differ from the source, then choose Download XLSX.
For a test first, use Load example. The image shows a supply count with SKU, Item, Units and Bin columns. It is a good example of printed text with both short codes and multiword items. The same reader is used for that sample and for your own image.
Compare IDs and numbers before you export
Photo recognition can mistake zero for the letter O, or lose a decimal point. Read across each important row once and confirm that the right amount is on the same row as its source code. If you have an amount like 12.50, check the decimal point. A worksheet may show 12.5 by default even if its underlying value is the same. Apply your desired display format in your spreadsheet app.
Product codes are different from amounts. Use XLSX to keep a value such as 0041 with the leading zeros intact. If another tool needs CSV, use the import dialog in your spreadsheet app and set that identifier column to text. A normal double-click can cause the app to guess the type.
For a busier page, crop one region at a time and compare results before combining them. Follow the scanned table review guide if descriptions wrap or the reader guesses the wrong number of columns.