Messy2Sheet workflow

PDF Price List to CSV.

Convert supplier price list PDFs into CSV rows with SKU, product name, size, pack quantity, tax, wholesale price,...

CSV rows
37
CSV columns
16
Product rows
28
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 PDF price list to CSV rows

A public wholesale price list becomes CSV rows with item codes, sections, pack sizes, tax fields, and review status.

37 CSV rows with 16 import-ready columns
28 extracted product rows for bottle, can, and draught items
9 Needs review rows for consignment, keg, post mix, and CO2 charges
Download
Proof from a real price list

A real supplier price list becomes 37 import-ready CSV rows.

This sample uses a public PhoenixBev wholesale price list. The generated CSV keeps SKU codes, pack sizes, wholesale prices, tax fields, retail prices, and review notes separate so supplier imports can be checked before upload.

37
CSV rows
16
CSV columns
28
Product rows
9
Review rows

CSV preview from the PhoenixBev price list

These rows come from the public PhoenixBev sample. Normal product rows stay import-ready, while consignment and cylinder charges stay visible as review rows instead of being silently dropped.

sectionsku_or_codeproduct_namesizepackwholesaleVATretailstatus
RETURNABLE GLASS BOTTLE8301PHOENIX BEER650ML1X12719.66107.9577.00Extracted
RETURNABLE GLASS BOTTLE8331GUINNESS650ML1X12855.50128.3391.00Extracted
NON RETURNABLE GLASS BOTTLE8351PHOENIX BEER330ML1X24775.00116.2541.00Extracted
CONSIGNMENTS650ML PACKAGE - FULL CRATE650ML400.00Needs review
CONSIGNMENTSCO2 CYLINDER2,000.00Needs review

Product identity

Product identity fields stay separate from the price numbers, which keeps supplier catalog imports easier to audit.

sectionsku_or_codeproduct_namesku_sizepack_quantity

Price and tax fields

Dense price-list columns are preserved as their own CSV fields instead of being copied as one visual table block.

wholesale before taxPET or can taxVAT 15%wholesale with taxrecommended retail

Import controls

The CSV keeps import controls visible, including blanks when the PDF does not state a value.

currencyeffective_datestatusnotes

Review rows

Consignment, keg, post mix, and cylinder rows are kept because they are priced rows, but they are marked for review.

Needs reviewnon-product priced rowconsignment packagekegCO2 cylinder
PDF table copy vs import-ready CSV

Plain PDF table copy

Copying from a PDF usually preserves the visual table, not the import rules that a spreadsheet or inventory system needs.

  • Headers and repeated labels can mix with product rows
  • Tax and subtotal columns can shift during copy paste
  • Non-product priced rows are easy to delete by mistake

Import-ready CSV output

Messy2Sheet uses the target CSV fields to keep prices, taxes, product identity, and review status in separate columns.

  • One row per product or priced charge
  • Tax, subtotal, wholesale, and retail prices stay separate
  • Rows that may not belong in a product import are flagged
Extraction details

What a PDF price list to CSV workflow needs.

Price list extraction works when dense supplier tables become import-ready rows without guessing currency, tax, or non-product charges.

Target fields

Set the CSV fields before extraction

Set fields such as section, SKU/code, product name, size, pack quantity, unit, wholesale price, tax/VAT, retail price, currency, effective date, review notes. Messy2Sheet uses those fields to shape the CSV output before extraction starts.

Price rows

Extract SKU, pack, tax, and price fields from PDF lists

Supplier price lists often include sections, SKUs, pack sizes, tax fields, recommended prices, non-product charges, and repeated headers. Keep priced rows and review notes separate.

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 supplier price list PDF, scan, screenshot, catalog, or pasted price list text needs structured CSV rows.

PDF Price List to CSV 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 PDF Price List to CSV inputs

  • Readable supplier price list PDF, scan, screenshot, catalog, or pasted price list text where a person can identify the important values.
  • Cases where you already know the output fields: section, SKU/code, product name, size, pack quantity, unit, wholesale price, tax/VAT, retail price, currency, effective date, review notes.
  • 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 pdf price list to csv 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: section, SKU/code, product name, size, pack quantity, unit, wholesale price, tax/VAT, retail price, currency, effective date, review notes
Check fields: source page, unclear value, cleanup note
Optional fields: category, normalized label, confidence, source text
Saved workflow
Reuse

Saved PDF Price List to CSV 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 supplier price list layout for repeat imports.

Start from the real file

Upload a supplier price list PDF, scan, screenshot, catalog, or pasted price list text or paste source text if you already have it.

Set the fields

Use fields like section, SKU/code, product name, size, pack quantity, unit, wholesale price, tax/VAT, retail price, currency, effective date, review notes 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 PDF Price List to CSV do?+

It extracts supplier price list rows from PDFs into CSV fields such as SKU, product name, size, pack quantity, tax, wholesale price, and notes.

Can it handle dense supplier tables?+

Yes, when the text is readable. Repeated headers, section labels, and non-product price rows should stay visible for review.

Can I choose the price list columns?+

Yes. Set columns such as SKU, product, unit, pack, wholesale price, tax, retail price, currency, and status.

What if the PDF does not state currency?+

Leave currency blank or add a review note instead of guessing.

Can I reuse a supplier price list layout?+

Yes. Save the workflow after one supplier list works.

Try it on one real file.

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

Start