Price List PDF to Excel: Convert Supplier Price Lists and Product Catalogs to a Spreadsheet
Your supplier sends a 90 page price list as a PDF and gives you thirty days before the new pricing takes effect. pdfxlsx turns it into a working spreadsheet in seconds, with the item number, description, pack size, and every quantity break in its own column, so you can load it into your ERP, repost your webstore, and see which lines moved before the deadline instead of after it.
Built for distributors, dealers, and buyers. Handles quantity break tiers, repeating category headers, and scanned rep copies. Files are encrypted and deleted after conversion.
Drop your PDF here or click to browse
PDF files up to 50MB
Convert a price list right here. No software to install.
The short answer
To convert a price list PDF to Excel, upload the PDF to a converter that reads table structure rather than fixed column positions, then export XLSX or CSV. The detail that decides whether the file is importable is tier alignment: most items are priced at only some of the quantity breaks, so a positional converter slides a case price into the each column and the sheet looks correct while quoting the wrong number. Before you import, check that the item count in the spreadsheet matches the supplier's stated line count and spot check the highest and lowest price.
Last updated September 2026
Tiers Hold
Blanks stay blank
One Row
Per SKU
XLSX + CSV
Import ready
50MB
Max file size
A price list you cannot sort costs you margin, not just time
Price lists arrive as PDFs because the supplier prints them from a system you have no login to. That is fine for the rep and terrible for you, because a PDF answers none of the questions you actually have. Which SKUs went up, and by how much. Whether the increase lands on your fast movers or your dead stock. What your margin looks like at the new cost if you hold your sell price. Which quantity break is now cheaper to buy at than the one you have been ordering.
None of that is answerable by reading. All of it is one formula once the list is in columns. The teams that get burned by price changes are almost never the ones who missed the letter, they are the ones who got the letter as a PDF, meant to key it in, and ran out of week. Converting the file takes about ten seconds here, which is short enough that it actually happens. If the same supplier's invoices arrive as PDFs too, those convert on the same engine, which is how you check that what you were billed matches what you were quoted.
The same converter handles the documents that sit either side of a price list: the purchase orders you raise against it and the wider procurement paperwork that comes back. When the ordering itself is what is eating the week rather than the pricing, a system that turns recurring purchase orders into structured order data is the next thing worth looking at.
| Item | Description | UOM | 1-9 | 10-49 | 50+ |
|---|---|---|---|---|---|
| HX-4410 | Hex bolt, zinc | EA | 1.84 | 1.62 | 1.39 |
| HX-4412 | Hex bolt, stainless | EA | 3.20 | 2.75 | |
| WS-0900 | Washer assortment | CS/12 | 28.50 | ||
| AN-2201 | Lock nut, nylon insert | BX/100 | 41.00 | 37.90 | 34.25 |
| TH-7730 | Threaded rod, 36 in | EA | 9.95 | 8.80 |
HX-4412 has no 10 to 49 price. The 2.75 stays in the 50+ column instead of sliding left into 10 to 49.
Six things that go wrong when a price list hits a generic converter
Price lists are the most structurally awkward document a distributor deals with, and not because they are long. They are awkward because a single page mixes four different kinds of row: real items, category headers, continuation lines from a wrapped description, and footnote text. A converter that treats the page as one flat table will produce something that opens cleanly in Excel and is wrong in ways nobody notices until a customer is quoted from it.
Quantity break columns shift
Most items are not priced at every break. When an item has a single price and a break price with nothing in between, a positional reader packs the numbers left and your 50 plus price ends up quoted as a 10 to 49 price. Each amount here is matched to the header above it, so gaps stay gaps.
Category headers become fake items
Catalogs restart with a family heading every few pages, so a flat extraction produces rows called Fasteners and Abrasives with no price. Those come through labeled as grouping rows, which means you can filter them out before you count SKUs or push the file into an import template.
Wrapped descriptions split one item into three
Long product descriptions wrap onto two or three printed lines. A naive reader treats each line as a new record, so your 4,000 item list arrives as 9,000 rows with prices on only some of them. Continuation lines are folded back into the item they belong to.
Footnote markers poison the price
A dagger or a superscript 2 next to a price is a note about freight or a minimum order, and it turns 14.50 into the text string 14.50 the moment it lands in a cell. Prices arrive as numbers. If one ever slips through as text, Text to Columns fixes the column in one pass.
Pack size gets glued to the price
CS/12, BX/100, and PR are unit of measure fields, not part of the description and not part of the price. They come back in their own column, which is what lets you compute a real per unit cost and compare two suppliers who quote in different pack sizes.
Scanned rep copies
Plenty of price lists still arrive as a scan of a printout with a handwritten date in the corner. Built-in OCR reads those, and decimal points are the thing to spot check afterwards, because a scanner that drops one turns 1.84 into 184.
How to convert a price list to Excel
Three steps, then one check that takes about a minute and is worth doing every time.
Upload the price list
Drag the supplier PDF into the box at the top of this page. A two page dealer sheet or a 400 page full line catalog, up to 50MB per file.
It reads the tier headers
The engine finds the price columns, maps every figure to the break it sits under, folds wrapped descriptions back together, and runs OCR if the file is a scan.
Download XLSX or CSV
One row per item, one column per field, prices as numbers. Take CSV when the destination is an import template.
Count the lines
Compare the row count against the supplier's stated item count, then check the cheapest and the dearest item against the PDF. Those two checks catch almost everything.
Five things worth doing the moment the file opens
The conversion is the boring part. This is the work that decides whether a price increase costs you money or barely registers, and every item on the list is a formula away once the columns are real.
-
1
Diff it against the old list. Convert last quarter's PDF too, match on the item number with XLOOKUP, and subtract. Sort the difference column descending and you can see in ten seconds whether this was a broad three percent or a targeted hit on forty lines.
-
2
Weight the increase by what you actually buy. Pull last year's usage by SKU out of your ERP, multiply units by the price change, and you get the real annual cost of the letter. That figure is what you take into the conversation with the rep, and it is usually nothing like the headline percentage.
-
3
Recheck your margins before the date, not after. New cost against current sell price, in one column. Any line that has fallen under your floor margin needs a repriced sell or a conversation, and the whole point of doing this in a spreadsheet is that you find those lines before a customer orders one.
-
4
Normalize the pack sizes. Divide the price by the quantity in the unit of measure column and you get a true per unit cost. Two suppliers quoting the same part in cases of twelve and boxes of a hundred stop being comparable until you do this, which is exactly how the more expensive one keeps winning.
-
5
Build the import file once. Map the converted columns onto your ERP or webstore template and save the mapping. Next quarter the same supplier sends the same layout, so the second conversion is a paste rather than a project.
When the pricing you need is published on a supplier or competitor website instead of arriving as a document, that is a different job with a different tool: pulling a site into clean structured data rather than reading a table off a page. The converter here is for the documents that land in your inbox.
Price list formats we convert
Nothing depends on a per supplier template. The converter reads the structure of the document in front of it, which matters because every manufacturer lays a price list out differently and none of them will change it for you.
What comes out
One row per item. Separate columns for the item number, description, unit of measure, and each price tier the list carries, plus any list price, discount percentage, or effective date column the supplier included. Category headings come through labeled so you can drop them, and the sheet is ready to map onto an ERP or webstore import template.
Who converts price lists
Almost always somebody working to a supplier's deadline rather than their own.
Wholesale distributors
Loading thousands of SKUs from a dozen manufacturers into one ERP, every quarter, against a live effective date.
Purchasing and category managers
Reading what a price increase actually costs before signing off on it, and comparing two suppliers who quote in different pack sizes. See the procurement workflow.
Ecommerce and merchandising
Turning a catalog PDF into a product feed with item numbers, descriptions, and cost, so the storefront reflects the new pricing on day one.
Estimators and contractors
Pricing a bid off a manufacturer catalog where the material cost has moved since the last job. See the construction workflow.
When a full line catalog runs to several hundred pages, the same engine handles long multi page documents without losing the table across page breaks, and when several suppliers update in the same week you can run them together with batch conversion. If all you need is the pricing grid out of a longer document, the table extractor pulls individual tables, and when the destination is your books rather than your ERP, start with the QuickBooks workflow. Shipping paperwork against these orders converts through the logistics workflow.
Price list to Excel: common questions
Upload the price list PDF to the converter at the top of this page and download the result as XLSX or CSV. Each item stays on one row, and the SKU, description, pack size, and every price tier land in separate columns. Prices come back as real numbers, so you can apply a margin formula the moment the file opens.
Upload the PDF and the converter reads the table structure, then writes each price into the column whose header it sits under. That matters more than it sounds on a price list, because most items are missing at least one tier, and a converter that reads by position will slide a case price into the each column. Spot check three rows against the PDF before you import.
A catalog converts the same way as a plain price list, and the useful part is that the item numbers, descriptions, and prices come out as separate fields rather than one blob of text. Catalogs usually repeat a header block for every product family, so check that those repeated headers are labeled and filtered out before you count SKUs.
Yes, and this is the case that breaks generic converters. Quantity break columns such as 1 to 9, 10 to 49, and 50 plus, or role based columns such as MSRP, dealer, and distributor, each keep their own column. Items priced at only one or two tiers keep their blank cells rather than shifting the numbers left.
Convert the price list to Excel first, then cut the sheet down to the columns QuickBooks expects for products and services, usually name, description, sales price, and income account. Save it as CSV and use the import tool under the gear menu. The full workflow is on our QuickBooks page, and CSV is the format the importer wants.
Convert both PDFs, put them on two sheets in the same workbook, then match on the SKU column with XLOOKUP and subtract the old price from the new one. Sort that difference column descending and the items the supplier quietly raised the most appear at the top. This is the single fastest way to read a price increase letter.
Yes. Price lists faxed or scanned by a rep still convert, because OCR runs before the table structure is rebuilt. Scans are where decimal points and superscript footnote markers cause the most trouble, so check the highest and lowest price in the output against the PDF once the file opens.
Yes. Batch conversion takes multiple PDFs in one pass, which is what you want at the start of a quarter when eight suppliers all send updates in the same week. Each file comes back as its own sheet, so you can stack them into one master list afterwards.
Files up to 50MB convert, which covers most full line catalogs running to several hundred pages. Long documents are handled page by page and stitched back together, so a 400 page parts catalog produces one continuous table rather than 400 fragments. Very large catalogs are worth splitting by product family if you only need part of the list.
Confidential dealer pricing is exactly the sort of file that should not sit on a random website. Files here are encrypted in transit and at rest, processed in an isolated environment, and deleted automatically once the conversion finishes. Nothing is stored long term, resold, or used to train an outside model.
Related converters
Aging Report PDF to Excel: Convert AR Aging and AP Aging Reports to Excel and CSV
Convert an AR or AP aging report PDF to Excel in seconds. Every customer, invoice, and 30, 60, and 90 day bucket lands in its own column, ready to total.
Use casesConvert Trial Balance PDF to Excel and CSV
Convert a trial balance PDF to Excel or CSV in seconds. Extract every account with its debit or credit balance into clean columns for mapping and review.
Use casesConvert Rent Roll PDF to Excel and CSV
Convert a rent roll PDF to Excel or CSV in seconds. Extract unit, tenant, lease dates, square feet, and monthly rent into columns for underwriting.
Use casesConvert Operating Statement PDF to Excel and CSV
Convert an operating statement or T12 PDF to Excel or CSV. Extract every income and expense line by month into clean columns to calculate NOI.
Convert your supplier price list now
Drop the price list or catalog PDF at the top of the page and download an import ready Excel or CSV in seconds. For everyday conversion of any business document, start with the PDF to Excel converter, or see what it costs on the pricing page.