PDFtoGrid.online

Price lists

Convert a supplier price list PDF to Excel

Extract product codes, descriptions, pack sizes and prices into a spreadsheet that can be filtered, compared and prepared for import.

Updated . Written for PDFtoGrid; corrections welcome via About.

The short answer

To convert a supplier price list PDF to Excel, note its effective date, currency and price tier, load only the product-table pages, tune column spacing so SKU, description, pack size, unit and price separate, keep SKUs as text so leading zeros survive, then export XLSX or CSV.

  1. Confirm effective date, currency, tax basis and customer tier from the PDF before using the prices.
  2. Give carton price, unit price and minimum order quantity their own columns.
  3. Compare two price lists by matching on SKU, not description.
  4. Test a small batch before any bulk import into an online store.

Example: A SKU such as 004512 must stay text; treated as a number it becomes 4512 and no longer matches the catalogue.

Supplier price lists are good extraction candidates when they were exported digitally and use repeated columns. They can also hide critical context—currency, tax treatment, effective date and price tier—outside the table. Capture that context before working with the numbers.

Open the free PDF converter

Before you begin: Do not publish or import extracted prices until the effective date, currency, tax basis and customer tier have been confirmed from the original PDF.

Step-by-step workflow

  1. Confirm the PDF has selectable text and note its effective date, currency and price tier.
  2. Load only the product-table pages and combine them when the column structure repeats.
  3. Tune spacing so SKU, description, pack size, unit and price remain separate.
  4. Preserve leading zeros in SKU fields and edit wrapped product descriptions.
  5. Export XLSX for comparison work or CSV for a controlled catalogue import.

Protect product codes

SKUs and barcodes are identifiers, not quantities. Set their spreadsheet columns to text before editing so leading zeros and long digit strings are preserved.

Separate unit and pack prices

A list may show carton price, unit price and minimum order quantity close together. Give each its own clearly named column and calculate a test unit cost to confirm the extraction has not shifted values.

Compare two price lists

Add supplier and effective-date columns to each extract, then append both tables. Match on a stable SKU rather than description text, because punctuation and product wording often change between editions.

Questions

Can I import the CSV directly into an online store?

Only after mapping fields, checking product codes and testing a small batch. Keep a backup of the catalogue before any bulk import.

What if the price list has product images?

The converter extracts text tables, not product images. Keep image work as a separate process.

How do I handle discontinued products?

Preserve status or note rows during extraction, then translate them into a dedicated status column before comparison.

Related PDF table guides