PDF to Google Sheets for procurement teams
Suppliers answer a request for quote with a PDF each, in a layout of their own. PDF to Sheets converts quotes, price lists and purchase orders inside Google Sheets so you can line vendors up in one comparison.
4.5 out of 5 on the Google Workspace Marketplace
| Part no. | Description | Qty | Unit price | Lead time |
|---|---|---|---|---|
| VL-2210 | Ball valve 1 in | 50 | 18.40 | 2 weeks |
| VL-2215 | Ball valve 2 in | 20 | 41.75 | 2 weeks |
| GS-0090 | Gasket set | 100 | 2.10 | In stock |
| PM-4400 | Pump, 5 hp | 2 | 1,960.00 | 6 weeks |
The short answer
Procurement teams convert supplier PDFs to Google Sheets by opening the PDF to Sheets add-on from the Extensions menu, uploading the quote or price list and converting it to a tab. Each line item becomes a row with part number, description, quantity and price in columns. Put each supplier in its own tab, then match on part number to compare prices side by side.
Purchasing documents that convert
| Document | When it comes up | What you get in the sheet |
|---|---|---|
| Supplier quotes | Comparing responses to a request for quote | Line items with quantity, unit price and lead time |
| Price lists and catalogues | Annual price updates | Hundreds of part rows, ready to match against last year |
| Purchase orders | Checking what was ordered against what was invoiced | Ordered lines with quantity and price |
| Supplier invoices | Three-way match and spend tracking | Billed lines with amounts |
| Packing lists and manifests | Receiving | Shipped items and quantities |
| Inventory lists | Stock counts and reorders | One row per item with quantity on hand |
What slows purchasing down
Every supplier formats quotes differently
Three quotes for the same parts arrive with three column orders. Converting each one gives you rows you can rearrange into a common shape.
Price lists are long
A forty-page catalogue with a few thousand part numbers is not something anyone should retype. A multi-page conversion turns it into one list.
Comparisons need matching columns
You cannot run a lookup against a PDF. Once prices are in cells, matching on part number takes one formula.
Paper still turns up
Signed purchase orders and delivery notes come back as scans. OCR reads them so they can be checked against the order.
How to convert a supplier quote to Google Sheets
Add PDF to Sheets to Google Sheets
Install it from the Google Workspace Marketplace. It takes one click and adds nothing to your computer.
Open it from the Extensions menu
In any spreadsheet, go to Extensions, choose PDF to Sheets and open the converter in the sidebar.
Upload your PDF and pick an output
Choose the file, then choose where the data should go: the current Google Sheet, an Excel file, CSV or XLS.
Convert and check the totals
The tables land as rows and columns. Compare one total against the PDF before you build on the data.
Comparing quotes side by side
A quote comparison is a small build that you reuse on every request for quote.
One tab per supplier
Convert each quote into its own tab and name the tab after the supplier. Make sure part number is in column A and unit price is in the same column on every tab, moving columns where a supplier ordered them differently.
The comparison tab
List your part numbers down column A. For each supplier, add a column that looks up the unit price:
=IFERROR(XLOOKUP($A2, Harlow!$A:$A, Harlow!$D:$D), "")
Add a column with =MIN(B2:D2) for the best price, and use conditional formatting to highlight the cell that matches it.
Do not compare unit prices alone
Quotes differ in more than price. Add rows or columns for minimum order quantity, lead time, freight terms and quote expiry so the lowest unit price is not mistaken for the best offer.
Price list updates
When a supplier sends a new annual price list, convert it into a tab beside last year’s and use the same lookup to calculate the change per part. Sorting by percentage change shows where to push back.
- Marketplace rating
- 4.5
- Installs
- 60K+
- Free to try
- 5 pages
Reviews
4.5 out of 5
Procurement: common questions
How do I compare supplier quotes that arrive as PDFs?
Convert each quote into its own tab with PDF to Sheets, then build a comparison tab that looks up each supplier's unit price by part number. Differences in price and lead time show up in adjacent columns.
Can I convert a long supplier price list?
Yes. Multi-page PDFs are converted in one go and come out as a single list. Paid plans cover the higher page counts that catalogues need.
Can I convert a purchase order PDF to Excel?
Yes. Choose Excel (.xlsx) as the output when you convert, or CSV if the data is going into an ERP or inventory system.
Does it work with scanned delivery notes?
Yes. Scanned pages are read with OCR. Handwritten quantities or notes on a delivery note are unreliable, so check those against the paper.
What if suppliers use different part numbers?
Add a cross-reference tab that maps each supplier's part number to your own, and look up through it. It takes some setup once and then works for every quote from that supplier.
Related converters
- InvoicesPull line items, quantities, unit prices and totals out of PDF invoices into Google Sheets, Excel or CSV. No retyping, and scanned invoices work too.
- Scanned PDFs (OCR)Convert scanned PDFs and photographed pages to Google Sheets, Excel or CSV. OCR reads the page, then tables are rebuilt as rows and columns you can edit.
- Accountants and bookkeepersConvert client bank statements, invoices and financial reports from PDF to Google Sheets, Excel or CSV. Less retyping at month end and tax time.
- Real estateConvert rent rolls, T12 operating statements and closing statements from PDF to Google Sheets, Excel or CSV so you can underwrite instead of retyping.
Stop retyping PDFs into spreadsheets
Add PDF to Sheets to Google Sheets and convert your first 5 pages free.