Excel Purchase Order Template

Download Free Excel Purchase Order Templates

Choose the layout closest to your order. Download the XLSX file, save a new working copy, and check the formulas before you use it for a live purchase.

• 

  Free Excel Purchase Order Template

  Download Template
• 

  Simple Excel Purchase Order Template

  Download Template
• 

  Printable Excel Purchase Order Template

  Download Template

Create the Purchase Order Without Fixing Spreadsheet Formulas

Excel works well when you want an offline workbook and control over every row. Docelf is faster when you want to create and send the order without maintaining formulas, copied cells, or print areas.

Add the vendor and line items, and Docelf calculates quantities, prices, discounts, sales tax, shipping, and totals while you work. You can email the finished purchase order, see when the vendor opens it, or download a PDF.

• Reuse saved vendor, product, and service details on the next order
• Let Docelf calculate the totals while you work
• Email the purchase order and see when the vendor opens it
• Download a PDF or print the finished order
• Keep purchase orders with the rest of your business documents

Prefer the workbook? Use one of the three free Excel templates above.

How to Create a Purchase Order in Excel

Work from the top of the workbook to the bottom, then check the formulas and print area before the purchase order leaves your business.

1 2 3 4 5 6 7

1. Download and Save a Working Copy: Open the XLSX template and save a separate file for this purchase order.
2. Add Buyer and Vendor Details: Enter your business details, the vendor, PO number, order date, and delivery information.
3. List the Items or Services: Use one row for each product, material, service, rental, or other purchase.
4. Enter Quantities and Prices: Add the quantity and unit price. Confirm that each line-total formula includes the correct cells.
5. Check Discounts, Tax, and Shipping: Enter only the charges that apply and confirm the subtotal and final-total formulas.
6. Set the Print Area: Use Print Preview to check page orientation, margins, repeated headings, and whether totals appear on the final page.
7. Save or Export the PO: Save the workbook for your records and export a PDF for the vendor.

Protect the Formulas Before the Order Goes Out

Excel or an Online Purchase Order?

Excel gives you flexible rows and formulas. Docelf is easier when you want totals handled automatically, saved vendor and line-item details, consistent PO numbers, and one place to find sent orders.

Create a purchase order online with Docelf when you want less file maintenance and fewer manual checks.

What Every Purchase Order Still Needs

The tool changes, but the vendor still needs the same core details.

• Your business and vendor details
• A unique PO number and order date
• Clear product or service descriptions
• Quantities, unit prices, and line totals
• Subtotal, discounts, sales tax, shipping, and total when they apply
• Shipping address, service location, requested date, and delivery instructions
• Payment terms, approval details, project references, and notes

Other Purchase Order File Formats

Choose the tool that best fits the way you edit, calculate, share, and send the order.

• Word Purchase Order Template
• Google Docs Purchase Order Template
• Google Sheets Purchase Order Template
• All Purchase Order Formats

Excel Purchase Order Template FAQs

• Is there a free Excel purchase order template?

  Yes. You can download the Excel purchase order templates on this page and use the XLSX files for your business.

• Does the Excel purchase order calculate totals automatically?

  The templates can include formulas for line totals, subtotal, tax, shipping, and the final total. Check the formulas after adding or deleting rows and before sending the order.

• How do I add more items to an Excel purchase order?

  Insert a new row within the item table, copy the formatting and formulas from a nearby row, then confirm the subtotal range includes the new line.

• Can I print an Excel purchase order on one page?

  Often, yes. Set the print area, choose portrait or landscape orientation, adjust margins, and use scaling carefully. Review the PDF or Print Preview so the text remains readable.

• Should I use Excel or Google Sheets for a purchase order?

  Use Excel when you prefer desktop files or need to work offline. Use Google Sheets when several people need browser access, comments, or shared editing.

• Can I save an Excel purchase order as a PDF?

  Yes. Use Export or Save As and choose PDF. Check that all columns, totals, and notes appear before sending it to the vendor.

• Is Docelf accounting software?

  No. Docelf is document software that helps you create, send, and organize purchase orders and other business documents.