Messy2Sheet workflow

Scanned PDF to Excel.

Convert scanned PDFs to Excel-ready CSV by running OCR first, then organizing visible fields, line rows, totals,...

Visible line rows
1
CSV columns
16
Source PDF pages
3
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 scanned PDF to CSV row

A public Philips scanned purchase order PDF becomes a CSV with source file, PO fields, one visible line item, blank currency, and review notes.

3-page scanned PDF rendered and processed with OCR.
1 visible line-item row with 16 CSV columns.
PO number 4501234567 and line number 10 kept in separate fields.
Currency left blank and truncated payment terms marked in review_note.
Download
Proof from a public scanned PDF

A public scanned PDF becomes one reviewable CSV row.

This sample uses a public Philips 3-page scanned purchase order PDF. The generated CSV keeps the visible PO line item, buyer, supplier, PO number, date, price fields, blank currency cell, truncated payment terms, and review note separate.

1
Visible line rows
16
CSV columns
3
Source PDF pages
None
Embedded text layer

CSV preview from the scanned Philips PO

This CSV row comes from a 3-page scanned purchase order PDF. Currency is blank because it is not visible, and the truncated payment terms are kept in review_note for checking.

source_filedocument_typebuyerpo_numberline_numberpart_numberquantityunit_priceline_totalcurrencyreview_note
philips-scanned-purchase-order.pdfPURCHASE ORDERPhilips Ultrasound, LLC45012345671045356182853620010020,000.00Currency not visible. Payment terms appear truncated as visible.

Source trace

The source file and document type stay attached to the extracted row so the CSV can be checked against the scanned PDF.

philips-scanned-purchase-order.pdfPURCHASE ORDERsource_file

Line item row

The visible PO line item becomes one spreadsheet row instead of a paragraph of OCR text.

line_number 10part_number 453561828536quantity 200

Price fields

Prices and totals stay in separate numeric fields for review before import.

unit_price 100line_total 20,000.00quantity 200

No invented values

Values not visible or truncated in the scan stay reviewable instead of being guessed.

blank currencytruncated payment_termsreview_note
OCR text dump vs reviewable CSV row

Plain scanned PDF OCR

A plain OCR pass can return readable text, but the buyer block, supplier block, PO fields, item row, prices, and terms still need to be rebuilt by hand.

  • Fields appear as text fragments
  • Line item is not import-ready
  • Missing currency can be guessed incorrectly

Reviewable scanned PDF CSV

Messy2Sheet uses the target fields to turn the scan into one reviewable CSV row with missing or truncated fields called out.

  • One row per visible line item
  • PO and price fields stay separate
  • review_note explains uncertainty
Extraction details

What scanned PDF to Excel conversion needs.

Scanned PDF conversion needs OCR plus spreadsheet cleanup: rows, fields, source file, blank values, and notes for uncertain or truncated values.

Target fields

Set the CSV fields before extraction

Set fields such as source file, document type, buyer, supplier, PO number, PO date, line number, part number, item description, quantity, unit price, line total, currency, ship to, payment terms, review note. Messy2Sheet uses those fields to shape the CSV output before extraction starts.

OCR cleanup

Run OCR before shaping Excel rows

Scanned PDFs need OCR first, then spreadsheet cleanup. Keep source file, page context, detected fields, line rows, blank values, and review notes visible instead of turning the scan into one text block.

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 scanned PDF, image-based PDF, screenshot, or pasted OCR text needs structured CSV rows.

Scanned PDF to Excel 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 Scanned PDF to Excel inputs

  • Readable scanned PDF, image-based PDF, screenshot, or pasted OCR text where a person can identify the important values.
  • Cases where you already know the output fields: source file, document type, buyer, supplier, PO number, PO date, line number, part number, item description, quantity, unit price, line total, currency, ship to, payment terms, 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 scanned pdf to excel 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, document type, buyer, supplier, PO number, PO date, line number, part number, item description, quantity, unit price, line total, currency, ship to, payment terms, review note
Check fields: source page, unclear value, cleanup note
Optional fields: category, normalized label, confidence, source text
Saved workflow
Reuse

Saved Scanned PDF to Excel 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 scanned PDF layout for repeated OCR jobs.

Start from the real file

Upload a scanned PDF, image-based PDF, screenshot, or pasted OCR text or paste source text if you already have it.

Set the fields

Use fields like source file, document type, buyer, supplier, PO number, PO date, line number, part number, item description, quantity, unit price, line total, currency, ship to, payment terms, 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 Convert Scanned PDF to Excel do?+

It converts scanned or image-based PDF pages to Excel or CSV by reading visible text with OCR, then organizing fields, table rows, totals, source file, and review notes.

Does it work when the PDF has no text layer?+

Yes, if the rendered page image is readable. The workflow uses OCR on the page images, then maps visible values into the columns you requested.

Can it leave missing values blank?+

Yes. Ask it to leave unclear fields such as currency, missing totals, or truncated terms blank and explain them in review_note instead of guessing.

Can it extract line-item rows from scans?+

Yes, when the line-item text is readable after OCR. Use one row per visible line item and keep source_file, line_number, quantity, unit_price, line_total, and review_note fields.

Can I save scanned PDF rules?+

Yes. Save the layout for repeated OCR jobs with similar scanned PDFs, supplier forms, order packets, invoices, or 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