Messy2Sheet workflow

Table OCR.

Run table OCR on images, scans, screenshots, or PDFs and turn visible table rows into Excel-ready CSV.

CSV rows
10
CSV columns
8
Sections
2
Try one file

Start with the file you already have.

Upload or paste the source, then check the workbook before export.

Create the sheet

Upload or paste the source. The cleanup rule is loaded.

  1. 1Source
  2. 2Instructions
  3. 3Create
Source
Loaded rule

Map fields, clean rows, and keep review notes.

Preview the workbook before export.

Real sample

Sample table OCR to menu CSV

A public Wikimedia price menu photo becomes a CSV with section labels, item rows, visible prices, blank currency fields, row order, and review notes.

10 visible menu item rows with 8 CSV columns.
5 FRUIT rows and 5 CRÈME rows preserved as section values.
Prices copied as visible numbers such as 13.99, 14.99, and 16.99.
Currency and size fields left blank because the photo does not show them.
Download
Proof from a public table photo

A public table photo becomes 10 clean CSV rows.

This sample uses a public Wikimedia Commons price menu photo for Eaton Park. The generated CSV keeps the FRUIT and CRÈME sections, item names, visible prices, blank currency cells, row order, and review-ready fields separate.

10
CSV rows
8
CSV columns
2
Sections
4994 x 1800
Image size

CSV preview from the public price menu photo

These rows come from the public menu photo. The CSV keeps section labels and row order, while currency stays blank because the image does not show a visible currency symbol or code.

sectionitem_namesize_or_optionpricecurrencyrow_orderreview_note
FRUITPumpkin13.991
FRUITApple14.992
FRUITBlackberry16.993
FRUITDutch Apple15.994
CRÈMEBanana Crème13.996

Source trace

The table source stays attached to every row so the CSV can be checked against the original image.

source_filerow_orderreview_note

Section labels

Section labels are preserved as fields instead of being copied into item names.

FRUITCRÈMEsection

Item rows

Each visible menu item becomes one row with the price copied exactly as visible.

item_namepricePumpkin 13.99Apple 14.99

No invented values

Fields not supported by the photo stay blank, so the CSV does not invent currency, sizes, taxes, or fees.

blank currencyblank size_or_optionno guessed fees
Image OCR text vs clean CSV rows

Plain image OCR

Plain OCR often gives text in reading order, but it does not decide which values are rows, sections, notes, or unsupported fields.

  • Section headers can merge with item names
  • Prices can lose row order
  • Missing currency can be guessed incorrectly

Reviewable table CSV

Messy2Sheet uses the target CSV fields to preserve item rows, section labels, row order, and blank unsupported fields.

  • One CSV row per visible menu item
  • FRUIT and CRÈME remain section values
  • Currency stays blank because the photo does not show it
Extraction details

What table OCR should preserve.

Table OCR should preserve visible rows, section labels, values, row order, blank unsupported fields, and uncertain values so the output can be checked.

Target fields

Set the CSV fields before extraction

Set fields such as source file, section, item name, size or option, price, currency, row order, review note. Messy2Sheet uses those fields to shape the CSV output before extraction starts.

Table reading

Read section labels, item rows, and visible prices together

Table OCR needs section labels, item rows, visible values, row order, and source notes, not only recognized characters. Keep blank or unsupported values visible instead of guessing them.

Check

Check the result before downloading CSV

Compare the generated rows with the source, fix unclear values, then export CSV when the table is ready.

Fit check

Use it when table image, PDF, scan, screenshot, or pasted OCR text needs structured CSV rows.

Table OCR works best when the source is readable and the target fields are clear. Keep review notes when the source layout or values need human judgment.

Best Table OCR inputs

  • Readable table image, PDF, scan, screenshot, or pasted OCR text where a person can identify the important values.
  • Cases where you already know the output fields: source file, section, item name, size or option, price, currency, row order, review note.
  • Sources with repeated business layouts that can become a saved workflow.
  • Files that need Excel or CSV output you can check before using.

Check before exporting CSV

  • The source is blurry, cropped, skewed, or low contrast.
  • Important values are handwritten, hidden, or missing.
  • Several unrelated layouts are mixed in one upload.
  • The result requires business decisions that are not visible in the source.
Template and workflow

Start with a table ocr layout you can reuse.

For repeated files, set the output fields once, check one result, then reuse the saved layout for the next similar source.

Template

CSV output layout

Use a target sheet when the final CSV file needs stable fields every time.

Output fields: source file, section, item name, size or option, price, currency, row order, review note
Check fields: source page, unclear value, cleanup note
Optional fields: category, normalized label, confidence, source text
Saved workflow
Reuse

Saved Table OCR workflow

Save the instructions that handle repeated headings, wrapped text, missing fields, and source-specific cleanup rules.

  1. 01Keep rows in a checkable order.
  2. 02Split source text into the requested columns.
  3. 03Flag unclear cells for manual checking.
Workflow

Save this table OCR layout for repeat table scans.

Start from the real file

Upload a table image, PDF, scan, screenshot, or pasted OCR text or paste source text if you already have it.

Set the fields

Use fields like source file, section, item name, size or option, price, currency, row order, review note so the generated CSV file matches the job.

Save the layout

Save the setup when the result looks right, then reuse it for similar files.

FAQ

Questions before you upload?

What does Table OCR do?+

Table OCR reads table images, PDFs, scans, or screenshots and exports headers, section labels, row labels, visible values, row order, source file, and review notes to Excel or CSV.

Can it preserve row order?+

Yes. Add row_order, source_file, section, item_name, price, and review_note fields when the order of rows matters.

What image quality works best?+

Readable table images with visible headers and row labels work best. Blur, skew, and glare need manual checking.

Can it leave unsupported values blank?+

Yes. If the image shows a price but no visible currency symbol or size, keep currency or size fields blank instead of inventing them.

Can it skip non-row notes?+

Yes. Ask for one row per visible item or table row, and keep availability notes, disclaimers, or captions out of the item table unless you need them as review notes.

Can I reuse table OCR fields?+

Yes. Save the layout for repeated table scans or similar reports.

Try it on one real file.

Upload the document, keep or edit the template instructions, and check the workbook before you download it.

Start