← Image to Excel converter

Review scanned tables before export

Check the shape of your worksheet first, then compare the values that matter against the source image.

Check the worksheet shape

Look at the number and order of the columns before correcting individual cells. A clean ruled table often keeps its structure. If a table uses only whitespace, a long line of text can occupy more than one expected column. An extra line of text above the table may also look like a row.

Use the image preview to check the first header and the last header. Then count the rows in the original or compare the first and last identifiers. Add a missing row or column in the editor. Select a cell to remove its row or column. If a large part of the table shifted, crop a clearer section of the image and read it again. Download your current edits first if you want to keep them.

Inspect the values that are easy to misread

  • Identifiers can contain zeros, the letter O, hyphens and spaces. Compare the full value, including its first character.
  • Numbers can lose a leading minus sign, a decimal point or a thousands separator. Check known values from both ends of the table.
  • Dates are copied as recognized text unless you format them after export. Check the day and month before using them for sorting or calculations.
  • Descriptions may contain a wrapped second line. Put the parts in the intended cell and remove any extra row that was created.

Yellow cells are worth reviewing first. Select a recognized cell to outline its text in the source image. On a phone the source image is above the table, so scroll up to see the outline. The highlight does not certify the cells around them. When the table has a visible total, compare it against your corrected worksheet. For a short batch, compare every cell. For a long image, check all IDs and other consequential values, then sample several complete rows.

Choose the output for the next step

Choose Download XLSX for a workbook that opens in Excel or a compatible spreadsheet app. Plain integers and decimals are stored as numbers when appropriate. Codes that begin with zeros and content such as dates remain as text. Format columns in your spreadsheet app after checking the values.

Choose CSV if a stock tool or database asks for a text file. Match its column names and import settings before bringing in the whole file. When opening a CSV in a spreadsheet program, set product codes and account identifiers to text if you need to preserve leading zeros.

Return to the image to Excel converter to test on the synthetic supply count first. The JPG preparation guide also explains when to retake or crop a photo.