skip to Main Content

Product Database Excel Template

4.43 (7 reviews)

Product data spreadsheet. Keep track of your products with dynamic lists, forms and dashboard. No installation needed. All in Excel!

Learn more about License Types


Someka refunds icon

30-Days
Return

Someka one time payment icon

One-Time
Payment

Someka direct download icon

Instant
Download

TEMPLATE DESCRIPTION

Regardless of your business area, keeping track of the overall product portfolio could be messy.  So, having one master file would save you a lot of trouble to record changes in product specs. Then imagine that’s already in Excel with no need for any additional software. That’s when the Product Database Excel Template comes into the picture.

Product-Database-Template-Excel-Someka-S01

Above all, this sheet can be used for internal departmental communication as well as business-to-business operations. In general, from sales to distribution, all parts of the supply chain can refer to one single file to check the product information. Therefore, with the option to accommodate a large amount of information, this Product Database is essential in organizing and retrieving needed information.

Product Database Excel Template Features

In summary, the template includes five main sections. These are 1. Navigation Menu, 2. Metric Info, 3. Settings, 4. Database and 5. Output sections.

Furthermore, the Dynamic List, Product Form and Dashboard are the output sections of the Product Database Template.

1. Navigation Menu

By using the navigation menu you may easily switch between sections of the Excel spreadsheet. So, you can navigate between each sheet by clicking on the buttons. Furthermore, you may also find the instructions notes here which explain the main functions of each section.

2. Metric Info

There are two ready-made columns in this sheet: Metric and description. While the metric column is necessary for the template to function, descriptions are optional.

Product-Database-Template-Excel-Someka-S02

Firstly, in the metric list, you will input data that will be used throughout other templates sheets such as Database, Dynamic List and Product Form sections. Moreover, your dropdown selection options in those sheets will be populated from this metric list. Up to 30 different metrics can be input into the list.

3. Settings

After defining your metrics, feel free to continue with the Settings section. The metrics you input in the previous section will be displayed on the dropdown list in settings headers. Optionally, you may select up to fifteen different metrics and continue with including properties for each metric category.

These options will be displayed in the database. By default, you will have seven metric columns, if you would like to input more metrics press the “+” sign on the top to add additional columns.

Product-Database-Template-Excel-Someka-S03

4. Database

This is the main sheet of the Product Excel Sheet. By default, you can edit the 7 ready-made info columns by using the arrows on each cell. These arrows will bring the dropdown options for you to select.

You will select the headings from desired metrics entered on the ‘Metric Info’ sheet. If you have added the details for these metrics on the settings section, you can also select them from cell drop-downs. If you wish to do so, you can also input your data manually.

Should you need to add further info columns after the readily made seven, just click on the arrow with no heading and select which category to be added. The database accommodates up to 30 columns and 2000 rows.

Product-Database-Template-Excel-Someka-S04

5. Output Sections of Excel Product Database

Product Database Template has three different output sections. These are Dynamic List, Product Form and Dashboard. All these sections gather their data from the Database sheet. The dropdown and filtering options available will be based on your input in the Database section. We will explain these Excel template sections below in detail.

5.1. Dynamic List

Dynamic product list grounds on the product database input. In addition, you will see the filtering options on the left side of the product output list. According to these selections, your list will populate automatically.

You may not only select the filter categories but also decide the displaying data. In addition, you can also use the column dropdown options to decide on which metric categories you will include in the dynamic list. Please note that, in addition to the products information, you may select up to 10 different info columns.

Product-Database-Template-Excel-Someka-S05

5.2. Product Form

Basically, you can self-create unique product forms here by selecting a product and product specs for the form. Start by selecting the desired product, and continue with adding each product property by using the dropdown options. As this list is fully customizable you can easily design the blanks and order according to your needs.

Product-Database-Template-Excel-Someka-S06

5.3. Dashboard

Last but not least, you are able to create interactive visualization charts in the dashboard section. Just choose the metric category from the top of each chart and this will update the charts automatically.

There are four different charts you can utilize and customize based on your needs. After selecting the analysis metric from the dropdown options arrow, you can also change the design and colors of the charts.

Product-Database-Template-Excel-Someka-S07u

Note: If you want this template in Google Sheets, you can download the Product Database Google Sheets Template.

Product Database Excel Template Features Summary:

  • Product data analysis in Excel
  • Customizable input data table
  • Dynamics summary charts
  • Informational notes included
  • No installation needed, ready-to-use
  • Works both on Mac and Windows
  • Compatible with Excel 2010 and later versions
  • Does not include any VBA code or macros

Product Database Template is a ready-to-use Excel Template and provided as-is. If you need customization on your reports or need more complex templates, please refer to our custom services.

PRODUCT VIDEO

Watch the video below to see the template in action! Presentation also includes usage notes, explanations and tips & tricks about the template.

FREQUENTLY ASKED QUESTIONS

USER REVIEWS & COMMENTS

7 reviews for Product Database Excel Template

  1. Cathy Dunn

    Hi. Dropdowns are great but I have a list which is not so convenient for this so before purchasing the full version I wanted to check if I can add my data manually without using the dropdown to the database. Thank you (appreciate the free version btw!)

    • Someka

      Hello Cathy,
      Of course, the settings part is optional. However, if you want to use filters in the dynamic list, you should fill in the settings.

  2. stanley

    Good excel application

  3. Gloria B.

    I’m not a big fan of pie style charts can I change the chart types in charts section?

    • Someka

      Hi Gloria,
      Sure after unprotecting the sheet you can change the chart type easily. Click the chart that you want to modify, select the “Chart Design” section from the ribbon and click “Change Chart Type”.

      Or simply right-click to change it!

      product-database-template-excel-someka-r1

  4. Laurence

    cant change dashboard colors in free

    • Someka

      Hello Laurance,
      To modify the colour of the charts and the remaining parts of the Product Database Template, we kindly ask you to get the full version here.

  5. MP

    great guys thx so much

  6. Wilson N.

    Thanks but for business I should add our logo but how?

    • Someka

      Hi Wilson,
      Our logo can easily be replaced after unlocking the sheet. It is explained in detail here.

      If you need support just get in touch with us at contact@someka.net and we’ll be happy to help!

  7. Molly Summers

    Can I add an extra info sheet in excel

    • Someka

      Hello Molly,
      Of course! After unlocking your sheets, you can input any instructions and/or tips on any of the sheets. Here is how to unlock.

Leave a customer review

Only verified users who have downloaded and used the template may leave a review.

RELATED TEMPLATES