In this article:

Free Order Form Template for Google Sheets (2024 Update)

May 8, 2024

Free Google Sheets Order Form Template

You can make a copy of this order form template in Google Sheets for free. Don't request for permission to edit, simply go to File > Make a copy.

google sheets order form template

How to Use the Order Form Template in Google Sheets

Below we explain how to use our order form template in Google Sheets:

Getting Started

Start by opening the Google Sheets purchase order template.

Filling Out Order Details

Find the cell next to "Purchase Order #" and type in your unique purchase order number. This helps in tracking and referencing.

Locate the cell next to "Date". Enter the current date or the date the order is being made.

order form template google sheets

Vendor and Buyer Information

Find the cells next to "Vendor Name" and "Vendor Address". Fill in the vendor's details accurately to ensure proper order processing and delivery.

Locate the cells next to "Buyer Name" and "Buyer Address". Input their corresponding details. In the cell next to "Delivery Date", you can specify the expected delivery timeline.

google sheets order form template free

Listing Items

Item Number: Sequential number for identification.

Description: Brief but clear description of the item.

Quantity: How many units of the item you need.

Unit Price: Price per unit of the item.

Total: Automatically calculated as Quantity x Unit Price. 

Below is an example:

Finalizing the Order

After listing all items, the Subtotal cell will sum up the total cost. Input the shipping fee and the template should calculate the final Total Amount due.

free google sheets order form template

Review Your Order

Double-check the quantities, descriptions, and prices to ensure everything matches your order requirements.

We hope that this article has helped you and given you a better understanding of how to use our Google Sheets order form template. If you enjoyed this article, you might also want to check out our address label template and college budget template in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->