Workbook Tools
Open editor

Free XLSX template

Free Purchase Order Excel template

Prepare supplier details and requested item quantities. Download an original XLSX workbook or make it your own in the online editor.

Download original XLSX

Make your workbook

display formatting only; no currency conversion

Generate applies these settings to a new workbook. It replaces any workbook already opened from this template.

Your download and editor use the same workbook. After editing, return here to download the updated file, or save directly from the editor.

Purchase Order
1
2buyer NameExample Buyer
3supplier NameExample Supplier
4po IdPO-001
5delivery Date2026-10-20
6
7
8ItemDescriptionQuantityUnit PriceLine Total
9P-001Example pens10USD 2.00=ROUND(C9*D9,2)
10=ROUND(C10*D10,2)
11=ROUND(C11*D11,2)
12=ROUND(C12*D12,2)

First 12 rows and 5 columns of Purchase Order. Formula cells show their expressions; generate the workbook to see calculated results.

What is in this workbook?

How to use the purchase order template

  1. Choose blank content or keep the fictional example, then set the dates and size you need.
  2. Generate the workbook and download it, or open it in the editor to enter your own details.
  3. Keep formula cells when replacing examples. Supported formulas update when you edit their inputs. Check any calculation diagnostics, then save your XLSX file.

Things to know

Order-request document; no binding legal/compliance promises, sending or procurement integration.

Dates are stored in Excel’s 1900 date system. Currency options change display formatting only. Each workbook includes an Instructions sheet.

Browse all twelve templates