Small Business Product Catalog in Excel – Free Template

Posted on
Small Business Product Catalog Screenshot 2

Have you wondered if it would be handy to have a product catalog for your small business? Did you know that we can create the entire online product catalog or online store experience within Excel? 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 Excel.

Product Catalogue - Screenshot in Excel
Product Catalogue – Screenshot in Excel

 

If this sounds interesting, please read further on the functionality and for how to use this (hint: it’s so easy. Just enter your data and you are done). You can download this Excel template for free using the link below.


FREE DOWNLOAD

Small Business Product Catalog Excel Template


 

PRODUCT CATALOG – FEATURES

  • 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 Catalog
  • Add links to website as needed on product detail sheets
  • Catalog links to individual product detail sheets
  • Format the catalog as needed with usual Excel formatting options
  • Customize product detail pages as needed
Small Business Product Catalog in Excel - Features (Sort, Filter, Search, Scroll)
Small Business Product Catalog in Excel – Features (Sort, Filter, Search, Scroll)

VIDEO TOUR

 


HOW TO CUSTOMIZE FOR YOUR BUSINESS

Overview of Steps

  1. Unhide hidden Input_Data sheet. Enter product categories and product data for your business.
  2. In Product_Catalog sheet, change logo and tagline text to suit your business.
  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

 

Detailed Steps

Entering product data

Unhide Input_Data sheet.

Unhide Sheet
Unhide Sheet

 

Select Input_Data Sheet.

Select Input Data Sheet
Select Input Data Sheet

 

Now, the sheet should be open and visible.

Enter Product Categories you need. It is set up for up to 6. If you need only 5, just select the 6th category (cell A8) and hit the Delete key to clear value.

Enter Product Categories for your small business
Enter Product Categories for your small business

 

Enter Product Data in the Products table.

Enter Product Data for your Small Business
Enter Product Data for your Small Business

 

Click on a product thumbnail image and choose Change Picture. Select picture from your computer.

Change Product Thumbnail Image
Change Product Thumbnail Image

 

Enter product name, price and category.

This ends our product data entry process for one product. Repeat for all products. After you enter all your products, you can hide this sheet. Now, we are ready to customize the catalog/store appearance.

 

Customize Catalog Appearance

First, in the Product_Catalog sheet, change logo by changing picture as explained above. Change the tagline text to suit your business.

Change Logo and Tagline in the header of Product Catalog
Change Logo and Tagline in the header of Product Catalog

 

If you want to change the colors, fonts or any formatting, please select cells and change formatting as usual in Excel.

Change formatting in Catalog
Change formatting in Catalog

 

Customizing Product Detail Sheets

You will notice that in the catalog, there are links to product detail sheets. Each product has its own sheet where we have its image and description.

Product Detail Sheet in Catalog - Customize
Product Detail Sheet in Catalog – Customize

 

  1. Rename the sheet to match your product name. If your product name is Cool Product, please rename the sheet to Cool Product.
  2. Replace image and description with your products’ info.
  3. I have added two links, one to the product page on the website and the other to go back to Catalog. Replace the web link with your product web page link. You can remove the web link if you don’t need or have.
  4. (Optional) You can change formatting (colors, fonts) as needed. There are no formulas in the product detail sheet.

Repeat this step for each of your products.

Tip: to insert a bullet as I did in the product highlights, use Alt+0149.

 

Once you have completed all your product detail sheets, you are done. You can go back to the Product_Catalog sheet and your catalog is ready. Start. Sort, Search, Filter, Scroll. 🙂

 

Print/Export

You can export to PDF or print as all sheets are set up as print friendly.

 

Limits

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

For more small business templates, please visit Small Business Management Excel Templates

 

As always, I look forward to your feedback to understand how this can be extended to suit more small business needs. If you have any feedback or suggestions, please leave them in the comments. Thanks.

124 thoughts on “Small Business Product Catalog in Excel – Free Template

  1. Hey Indzara.com, I am actually using your Small Business Product Catalog in Excel and I would like to add more than 30 products. For that I extend the Thumbnail Image to 40, the products appears on the catalog nevertheless the picture is not blank. Do you know how to fix it ?

    Thank you !

    1. Thanks for using our template.

      Please unhide the tabs using password “indzara”. Then you can add more products. However, please note, as the number of products increase, the file would get heavy and take time to respond.

      Best wishes

  2. Hi there,

    the product catalog spreadsheet will not open after downloading, please also note I get a warning saying that your website is unsafe to download from!
    please advise

    thanks

    Glynn

    1. Hello

      We have shared the file through email. Please be assured that our website is 100 percent safe.

      Best wishes

  3. Hi,
    I want to add more than 1 picture of each of my products. Can you please tell me how?
    Thanks!

    1. You can add more to each of the Product Detail Sheets. However, adding them to appear on the Catalog sheet will require a lot of formula work.
      Best wishes.

  4. How do I add an extra tab for highlights when ‘view’ is clicked? I’ve added a picture on the extra row you provided but I don’t know how to get the highlights page to link to the main page.

    1. Hello

      You need to link that image to the tab. Please refer to the other images, copy the formula to link and it should work. If it still does not work, please email your file with the list of issues to contact@indzara.com.

      Best wishes

Leave a Reply

Your email address will not be published. Required fields are marked *