How to Convert a Supplier Price List to Excel Automatically
Stop retyping supplier price lists into your spreadsheets. Learn how to extract product names, SKUs, and prices from PDFs and images into Excel in seconds using AI.
Without ScanToExcel
- - Manual typing for 2-5 minutes per document
- - Typos and transposed numbers
- - Columns get jumbled from copy-paste
- - Numbers stored as text (formulas break)
- - Hours of tedious work per month
With ScanToExcel
- + 3-5 seconds per page, fully automated
- + AI reads text perfectly, no typos
- + Columns preserved exactly as in the document
- + Numbers stored as numbers, formulas work
- + Minutes instead of hours
Why Price Lists Are a Data Entry Headache
Suppliers send price lists in every format imaginable — dense PDFs, photographed paper sheets, emailed Word documents, even faxes. Whatever the format, someone on your team eventually has to get those prices into a spreadsheet so they can be compared, marked up, or imported into your inventory system.
A typical supplier price list might have 50-500 line items. At 1-2 minutes per item entered manually, that's 1-16 hours of work — for a document that changes every quarter.
What Gets Extracted from a Price List
ScanToExcel identifies and extracts all the structured data in a price list:
- Product name and description
- SKU / item code
- Unit of measure (each, box, pallet)
- Unit price and bulk pricing tiers
- Currency and effective date
- Category or product group headers
Each line item becomes a row in your Excel file, with columns matching the original document structure.
Time per page
Step-by-Step: Price List PDF to Excel
Step 1: Get the Price List File
Most supplier price lists arrive as PDFs or image attachments. If you received a physical price sheet, photograph it with your phone — clear, flat, and well-lit.
Step 2: Upload to ScanToExcel
Drag the file into scantoexcel.ai. Multi-page catalogs (up to 5 pages) are handled automatically.
Step 3: Review the Extraction
The preview table shows all extracted line items. Verify that SKUs and prices look correct — pay special attention to decimal points and currency symbols.
Step 4: Download and Use
Export as .xlsx. Your price list is now a proper Excel table you can:
- Sort by price, category, or SKU
- Filter to find specific products
- VLOOKUP against your inventory list
- Import directly into procurement or POS systems
Comparing Multiple Supplier Price Lists
One of the most powerful uses of this workflow is competitive price comparison. Convert each supplier's price list to Excel, then:
- Add a "Supplier" column to each file
- Combine all files into one master sheet
- Use a pivot table or VLOOKUP to compare prices per SKU across suppliers
What used to take a full day of manual work takes under an hour.
| SKU | Description | Supplier A | Supplier B | Supplier C | Lowest |
|---|---|---|---|---|---|
| 1042 | Widget A | $4.50 | $4.20 | $4.75 | Supplier B |
| 1043 | Widget B | $12.00 | $13.50 | $11.80 | Supplier C |
| 1044 | Widget C | $2.25 | $2.25 | $2.10 | Supplier C |
Handling Different Price List Formats
| Format | How to Upload | Expected Accuracy |
|---|---|---|
| Native PDF | Upload directly | Excellent |
| Scanned PDF | Upload directly | Very good |
| Photo of printed sheet | Upload JPG/PNG | Very good |
| Multi-column catalog | Upload as-is | Good |
| Handwritten price sheet | Upload photo | Good |
Tips for Best Results
- Use the original PDF — If the supplier emailed a PDF, upload that rather than a screenshot.
- One price list per upload — Don't combine multiple supplier PDFs into a single file.
- Check decimal separators — European price lists may use commas instead of periods for decimals. Verify the numbers after extraction.
- Multi-page catalogs — Upload the full PDF; the AI processes all pages and merges them into one sheet.
Get Started
Stop retyping price lists. Try ScanToExcel free — 2 free pages, no credit card required.
Ready to try it yourself?
Convert any document to Excel in seconds. 2 free pages, no credit card required.
Try ScanToExcel Free