How to turn a handwritten table into an Excel spreadsheet

A handwritten inventory, score sheet or reading log needs more than readable text. Each value must stay attached to its row and column. Photograph the whole table, transcribe a small sample, check the cell positions, then import or enter the checked values into Excel. For a short table, typing directly into a prepared grid may be the quickest route.

Keep the headers and the original row order

Take a sharp, straight-on photo that includes the column headers, units and any notes explaining the table. Keep this original even if you make a cropped copy for recognition. Number the source rows in your working copy so you can find a value again without sorting the spreadsheet.

Try three representative rows, including one with a blank cell or a correction. If you need help choosing a transcription method, see the guide to digitizing handwritten notes. Stop the trial if the result joins columns or loses rows; rebuilding the grid manually may take less work.

Can Excel read the photo directly?

Microsoft’s Data from Picture documentation describes image-to-table import and a review step. Check availability for your version and device. That documentation does not establish how accurately it will read your particular handwriting; test the same sample before processing every page.

You can also use handwriting OCR and rebuild the cells yourself. Keep the image beside the transcription. A list of recognized numbers alone does not tell you which column each one belongs to.

Separate blank, zero and unreadable

Use a separate review column rather than putting guessed values in numeric cells. In this fictional inventory, a source row contains code 0017, item “Blue folder”, a blank quantity and the note “count again”. Enter 0017 as text, keep quantity empty and copy the note. Neither 0 nor the previous row’s quantity is justified.

• A visible zero becomes 0. An empty cell stays empty.
• An unreadable value stays unresolved; record that in the review column and retain the source row reference.
• A ditto mark needs an explicit rule. Preserve the mark in the source transcription; if you expand it in the working sheet, record which value you repeated.
• Keep crossed-out entries and the chosen replacement traceable. Do not silently add both to a total.

Read each row across, then check down each column. The OCR proofreading checklist covers names, numbers and unresolved readings.

Control separators and column types at import

If the text is ready but the cells are not, prepare one record per line with a consistent field separator. Tabs can separate fields without competing with a decimal comma. Keep empty fields in place: removing one shifts the remaining cells to the left.

Microsoft’s text import guide explains delimiter selection and preview. Inspect the preview before loading. Its leading-zero guidance explains importing code columns as text. Set those types before conversion so 0017 stays 0017. Keep ambiguous dates as source text until their meaning is resolved.

Check the saved spreadsheet against the page

1. Count the source rows and imported records, excluding headers and totals consistently.
2. Compare the first and last record, every blank cell, and every corrected or uncertain value.
3. Check codes, signs, decimal separators and units. Keep the source total separate from any calculated total.
4. Save the workbook as .xlsx, reopen it and confirm that codes and row order survived.

A matching total is a useful warning check, but two errors can cancel each other out. It does not replace checking individual cells.

Use Encria for the transcription step

Encria can transcribe handwriting on iPhone and iPad and help you review uncertain words. Prepare and verify the spreadsheet separately; this workflow does not rely on an Encria export to Excel or automatic recovery of table structure. Start with one page and keep the photo until the cells are checked.

Microsoft documentation checked on November 2, 2026. Menu names and feature availability vary by version.