In this article:

Free Quote Template for Google Sheets (2024 Update)

May 8, 2024

Free Quote Template in Google Sheets

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

google sheets quote template

How to Use the Quote Template in Google Sheets

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

1. Company Details and Quotation Info

Fill in your company's name, address, contact information, the date of the quotation, quotation number, customer ID, and the validity period of the quote at the top of the template.

quote template google sheets

2. Customer Information

Enter the customer's name, address, and contact details under the "Bill To" section. If the items will be shipped to a different address, fill that in under "Ship To."

quote google sheets template

3. Items and Pricing

List each item being quoted in its own row under the "Item Number" and "Description" columns. Enter the quantity (Qty), the unit price, and the total price for each item. The "Total" for each line will be the Qty multiplied by the Unit Price.

free google sheets quote template

4. Totals

The subtotal will be automatically calculated. Apply any tax rates to the subtotal to find the tax amount. Add any shipping costs. The final "Total" is the sum of the subtotal, tax, and shipping costs.

free quote template in google sheets

5. Notes

Include any additional information such as payment terms, delivery schedule, or other relevant notes that the customer should be aware of.

quote google sheets free template

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

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 ->