Procurement and technical review guide
How to compare supplier spec sheets when every file uses a different format
Compare supplier spec sheets by first agreeing on the fields, then keeping each value tied to its product, condition, unit, and source location. A useful comparison makes disagreements visible and leaves a reviewer enough context to check the original PDF page, spreadsheet cell, table, or paragraph.
A five-step review that survives a handoff
- Collect the packet. Keep the supplier PDF, DOCX, XLSX, CSV, or offline HTML files together and record which product or variant each file describes.
- Choose a shared field list. Use stable names such as rated input power, supply voltage, net mass, dimensions, warranty, or material. Keep fields that matter to the decision even when a supplier leaves them blank.
- Normalize carefully. Convert only allowed equivalent units, such as kW to W or lb to kg. Keep the original wording beside the normalized value.
- Check evidence. A value should point to a filename and a page, sheet, cell range, table, paragraph, or record. The quote must come from the same source block as the candidate.
- Review the exceptions. Resolve product identity and field mapping before treating a value as supported. Leave Missing, Conflict, and Unsupported visible in the final report.
What the four statuses mean
| Status | What it tells you | Next review action |
|---|---|---|
| Supported | A candidate value and its source quote passed the comparison checks. | Open the quote when the field affects the decision. |
| Missing | No candidate was found in readable, correctly associated sources. | Ask the supplier or keep the field unknown. |
| Conflict | Incompatible candidates remain for the same product, field, and condition. | Inspect both quotes and record the selected candidate without erasing the disagreement. |
| Unsupported | A candidate exists, but its value, quote, or product ownership cannot be verified. | Keep it out of the confirmed comparison until the source is clarified. |
Why the source location matters
“1,500 W” is not enough on its own. A reviewer needs to know whether it came from a product page, a footnote, a different variant, or a spreadsheet column that was accidentally shifted. Keeping the quote and locator together turns a summary into a checkable handoff.
What not to hide
Do not silently choose the lowest value, fill a blank from a similar model, or turn an unreadable scan into a confirmed number. A comparison is more useful when it shows exactly where the source packet is incomplete or inconsistent.
How SpecSheet AI fits this workflow
SpecSheet AI reads PDF, DOCX, XLSX, CSV, and offline HTML files, maps different labels to a canonical field set, normalizes a limited unit list, and keeps a source quote with each candidate. A reviewer can inspect the evidence, resolve a conflict, and freeze a report for CSV, Markdown, JSON, or PDF export.
V0.1 does not run OCR, fetch URLs, execute formulas or macros, guess missing values, or verify manufacturer claims. “Supported” means the source was checked; it does not certify that a technical claim is true.
Try a comparison with your documents Email this guideQuestions people ask
What should a supplier specification comparison include?
Use a shared field list, normalized values and units, product and condition context, and a source location that lets a reviewer check the original wording.
How should conflicting supplier values be handled?
Keep both candidates visible for the same product, field, and condition. Review both quotes, record the chosen candidate, and preserve the conflict history.
What is the difference between Missing and Unsupported?
Missing means no candidate was found in successfully read and associated sources. Unsupported means a candidate exists but its value, quote, or product ownership cannot be verified.
Can a comparison tool verify that a supplier claim is true?
No. It can show where a claim appears and whether the evidence is consistent. Product testing, certification, and independent verification require a separate process.