Purchase order templatespurchase order spreadsheet template

Purchase Order Spreadsheet Template

Use this purchase order spreadsheet template when supplier details, shipping details, payment terms, item rows, calculated totals, and approval need separate summary and line-item sheets.

Download XLSXUse this template with my files
Format
XLSX
Category
Excel
Use
Download or fill
Purchase order template Excel
Built-in template
Real sample

A public PO sample becomes a two-sheet Excel workbook.

This proof uses the public Montana Purchase Order Sample PDF to show the Excel-specific workflow: one PO Summary sheet for header fields, payment terms, freight terms, totals, and source notes, plus one PO Line Items sheet for the four ordered item rows. The workbook keeps ITEM as item_number and UPC as its own field instead of inventing supplier SKU columns.

Workbook sheets
2
Summary rows
1
Line rows
4
Total cases
96
Montana public purchase order sample used for Excel workbook
View source textDownload CSVRead walkthrough

What this source proves

The sample shows the visible fields, row order, totals, and review boundaries used by the filled result. Hidden business facts stay out of the output.

Purchase Order Spreadsheet Template proof

Source-backed field behavior

Download workbook

Visible fields are mapped, formulas and review notes stay inspectable, and hidden business facts are not invented just to fill empty cells.

sheetrowsexcel behavior
PO Summary1Header fields, payment terms, freight terms, totals, and source notes.
PO Line Items4One row per ordered item with item_number, pack, size, UPC, weight, price, and review_note.
Currency handling4USD is called out in review notes because the source page does not print a currency code.
Unsupported fields0No supplier SKUs, taxes, discounts, receiving quantities, approval status, or GL coding are invented.
Fill this template

Turn supplier files into this PO workbook.

Upload files or paste buying notes. Template mode is already attached to Purchase order template Excel.

Working from a full PO packet instead of one template? Use purchase order automation to map the packet before filling rows.

Purchase Order Spreadsheet Template

Upload supplier quotes, purchase request emails, PDFs, screenshots, price lists, CSV exports, or pasted buying notes. The selected purchase order template is already attached.

  1. 1Source
  2. 2Instructions
  3. 3Create
Source
Template

Choose one, or upload CSV/XLSX.

Creates an Excel workbook from the Purchase Order Spreadsheet Template.

XLSX structure

Purchase order rows, formulas, and approval fields.

The workbook includes a printable Purchase Order sheet, structured line items, and instructions for filling it from messy purchasing documents.

Company details
Order information
Purchased from
Ship to
Shipping information
Payment information
Item number and description
Quantity and unit price
Subtotal, tax, S&H, other, and total
Order approval
More templates

Other purchase order templates

View all templates
Basic purchase order template preview

Basic purchase order template

Built-in

A source-based basic purchase order workbook with bill-to, ship-to, PO number, customer number, item rows, tax, S&H, totals, shipping terms, and approval.

PreviewUse
Vendor purchase order template preview

Vendor purchase order template

Built-in

A source-based vendor purchase order workbook with order information, vendor details, ship-to details, item/service rows, cost breakdown, notes, and supervisor approval.

PreviewUse
Construction purchase order template preview

Construction purchase order template

Built-in

A source-based construction purchase order workbook with labor hours/rates, materials quantities/prices, taxes, other costs, shipping terms, delivery date, accepted-by, and approved-by fields.

PreviewUse
Restaurant purchase order template preview

Restaurant purchase order template

Built-in

A restaurant order guide workbook for vendor details, PO number, par levels, on-hand quantity, order quantity, delivery day, and item totals.

PreviewUse
FAQ

Questions

What is a purchase order template?

A purchase order template is a spreadsheet layout for PO number, buyer, vendor, ship-to address, SKU or item, description, quantity, unit price, tax, freight, terms, approval, and status.

Can I download the purchase order template as Excel?

Yes. Each built-in purchase order template is available as an editable XLSX file with a printable Purchase Order sheet and a structured Line Items sheet.

Can Messy2Sheet fill a PO template from supplier quotes?

Yes. Upload supplier quotes, PDFs, emails, screenshots, price lists, or pasted buying notes and Messy2Sheet can fill the selected Excel PO template for review.

Which purchase order template should I start with?

Start with the basic purchase order template for general buying. Use vendor, construction, restaurant, or inventory templates when the source belongs to one of those workflows.