Small Business Product Catalog in Excel – Google Sheets Template

Description
Did you know that we can create the entire online product catalog or online store experience within Google Sheets? Without payment processing, of course


You could use this to share your product info with your prospects and customers in an interactive tool.
This is how the product catalog/store appears in Google Sheets. 


Benefits of Product Catalog in Google Sheets:

• Filter products by Categories
• Search products by keywords (on Product Name)
• Sort products by Price (Ascending or Descending)
• Scroll to see products in sets of 8
• Add thumbnail images to appear on the Catalog
• Add links to the website as needed on product detail sheets
• Catalog links to individual product detail sheets
• Format the catalog as needed with the usual Google Sheets formatting options
• Customize product detail pages as needed

How to create a Product catalog for your business?Overview of Steps

1. In the Input sheet, enter product categories and product data for your business.
2. In the Catalog sheet, change logo and tagline text to suit your business – this is where you’ll have the catalog populated.
3. In each product’s individual product detail sheet, rename the sheet to match the product name

• Update product image and highlights for each product
• Change formatting – colors, fonts, etc. as needed

Print/Export
You can export to PDF or print as all sheets are set up as print friendly in this Google Sheets product database template.
Limits

• Designed by default for 30 products. Can be extended if needed.
• Names of Products should match the Product Detail Sheet Names. This allows hyperlinks to function properly.

Note:
The template works ONLY when images are taken from Google Drive and with “Anyone with the link can view” access.