Skip to content
ContractorsSpreadsheet

Supplier quote comparison sheet

A free spreadsheet for electrical contractors to lay supplier quotes side by side — line by line — with pricing units converted, substitutions flagged and lead times in view.

What's inside

  • A request tab listing every line item once: description, catalog number, quantity and unit
  • Side-by-side columns for up to three suppliers: item quoted, substitute flag, unit price, pricing unit, extended price, lead time and availability
  • Automatic conversion of prices quoted per each (E), per hundred (C) or per thousand (M), so every line compares on the same basis
  • Totals by supplier, with freight and other charges added in
  • Best price by line, so you can see whether splitting the order is worth it
  • A notes column to record your decision and why

Works in Microsoft Excel and Google Sheets.

Get the template

Free. We'll email it to you.

    Preview

    LineItemQtySupplier A — unit priceSupplier B — unit priceSupplier C — unit priceBest
    1200A panelboard, NEMA 3R4[PRICE][PRICE]Substitute[SUPPLIER]
    2#12 THHN, black2,000 ft[PRICE] per M[PRICE] per M[PRICE] per M[SUPPLIER]
    …………………

    How to use it

    How to compare electrical supplier quotes line by line

    Read the guide →

    Want this done for you?

    Quote Agent turns your material list into one clean request for your distributors and lines up their quotes side by side automatically.