Google Sheets Purchase Order Template

Use Free Google Sheets Purchase Order Templates

Choose the layout closest to your order and make your own copy. Rename it before editing so the file is easy to identify in Drive.

• 

  Basic Google Sheets Purchase Order

  Use Template
• 

  Free Google Sheets Purchase Order Template

  Use Template
• 

  Printable Purchase Order Form in Google Sheets

  Use Template

Create the Purchase Order Without Protecting Formula Cells

Google Sheets works well for shared spreadsheet editing. Docelf is faster when you want automatic totals and reusable vendor details without protecting formulas or checking version history.

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 shared spreadsheet? Use one of the three free Google Sheets templates above.

How to Create a Purchase Order in Google Sheets

Make your own copy first, then work from the top of the sheet to the bottom and check the formulas before you export the purchase order.

1 2 3 4 5 6 7

1. Make and Rename Your Copy: Open the template, choose Make a copy, and name the sheet with the PO number, vendor, or project.
2. Set Access Before Editing: Share only with the people who need to review or update the order.
3. Add Buyer, Vendor, and Delivery Details: Enter the business details, vendor, PO number, dates, ship-to address, and instructions.
4. Enter the Line Items: Use one row for each product, service, material, rental, or other purchase.
5. Check Every Formula: Confirm each row calculates correctly and the subtotal range includes every item.
6. Protect Important Cells: Protect formula cells or ranges when several people edit the sheet.
7. Export the Final PO: Set the print area, download a PDF, and review it before sending to the vendor.

Keep Shared Editing From Changing the Total

Google Sheets or an Online Purchase Order?

Google Sheets is useful for shared spreadsheet editing. Docelf removes more setup: it calculates totals, stores vendor and item details, assigns consistent documents, emails the PO, and shows when the vendor opens it.

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
• Excel Purchase Order Template
• All Purchase Order Formats

Google Sheets Purchase Order Template FAQs

• How do I make a copy of the Google Sheets purchase order template?

  Open a template link and choose Make a copy. Rename the copy and save it in the Drive folder you use for purchasing.

• Does the Google Sheets purchase order calculate totals?

  The templates can use formulas for line totals, subtotal, tax, shipping, and the final total. Test the formulas and confirm all item rows are included before sending.

• How do I protect formulas in Google Sheets?

  Select the formula cells or ranges, use Protect sheets and ranges, and limit who can edit them. Other users can still enter order details in the unlocked cells.

• Can several people edit the purchase order at once?

  Yes. Google Sheets supports shared editing, comments, and version history. Give edit access only to people who need it.

• How do I print a Google Sheets purchase order?

  Set the print range, choose portrait or landscape orientation, adjust scaling, and review the page breaks. Downloading a PDF first makes it easier to check the final layout.

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

  Use Google Sheets for browser access and shared editing. Use Excel when you prefer desktop files, offline work, or more advanced spreadsheet features.

• Should I share the editable sheet with my vendor?

  Usually, send a PDF of the final purchase order. Share the editable sheet only when collaboration is required and the permissions are limited correctly.