skip to Main Content

Excel SKU Generator

4.78 (9 reviews)

Excel spreadsheet to create SKU numbers. Create unique codes for all your products. Keep track of your inventory. No installation needed.

Learn more about License Types

Someka refunds icon


Someka one time payment icon


Someka direct download icon



SKU is an abbreviation for Stock Keeping Unit. Also known as product codes/numbers, SKUs are unique numbers for each product type of a business. SKU Generator Excel Template helps vendors follow their stock movements, label their goods with easy-to-read SKU numbers, and certainly, identify each product type and unit in their inventory.


SKU generator excel template will help you keep up with your stock availability, and also identify the most profitable products. Create and assign SKUs for all your product categories with our SKU generator.

SKU Generator Excel Template Main Features

Designed to create SKU numbers easily. Above all, our Excel template offers you two different options: 1. Auto SKU Generator, 2. Custom SKU Generator. Further explanation for both options is below.

1. Auto SKU Generator

Auto SKU generator excel template section helps you create SKU numbers automatically according to your product and category number. Before starting, you should set up the metrics in the settings section. Prefix and separator can be added from the prefix and separator parts in the settings and also the order of SKUs can be changed with “category first” or “product first” options.

Moreover, there are 1000 rows in this section for your products.


2. Custom SKU Generator

Custom SKU generator excel template helps you create SKU numbers according to the main attributes of your products. You should define the settings for your custom SKUs before you start. There are 1000 rows in this section as well.


  • Prefix & Code: You may prefer not to use any prefixes or codes, or you can just select to use one or two of them with any separator. The drop-down menu will help you to choose the best fit for your needs.
  • Separator: This option is for you to determine the main separator between the attributes of your products.
  • Character Type: You can use lower- or upper-case letters, as well as leave them as are.
  • Length of SKU: You may prefer to use the SKUs with the same length (in terms of character numbers), or just allow different lengths. If you choose “Same for all SKUs”, the Total Length cell will display you the total length according to your settings.
  • # Of Characters: This setting will affect how many characters from each attribute will be displayed on each SKU. For example, if you choose 3 for the color attribute, then it will take “bla” from black and “whi” from white, etc.

That is to say, after filling in the settings, you should input headers and choose the number of characters.


Note: The template will warn you if you repeat your SKU numbers, so be careful to avoid confusion.

 SKU Generator Excel Template Features Summary:

  • Generate unique alphanumeric code
  • Keep track of your inventory
  • Fully customizable and ready to print
  • 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

SKU Generator 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.


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



9 reviews for Excel SKU Generator

  1. Chadwick

    I do not want lower case letters in my sku

    • Someka

      Hello Chadwick,

      You can change character type in the settings part and you can use lower or upper-case letters according to your need.

  2. Galo Ball

    I am glad to say that excel is very helpful to me in organizing work.

  3. Lew

    we liked this app and we consider buying multi user.
    Is it possible to change the license of our product? Now we have single user.

    • Someka

      Hello Lew,

      We may surely upgrade your license from single-user to multi-user. Just email us at and our team will contact you with a link to upgrade your license.

  4. Vanessa A

    everythng is okay but I could not change the logo?

    • Someka

      Hello Vanessa,

      You can remove the logo or replace it with your own logo for each sheet. For Free Versions, you are not allowed to remove the logo or alter any copyrighted material in the template.
      You can do it in the full version. Please check how to do that in this link.


      Hope this helps!

  5. Gale


  6. Hannah Shaw

    It is really useful! Thanks, Someka team

    • Someka

      Dear Hannah,

      Thank you very much for your kind words.

  7. Isabelle

    How many products can I input to this template?

    • Someka

      Dear Isabelle,

      You can create SKUs for 1000 products in Auto SKU and Custom SKU sections.

  8. Sophia B

    custom sku part is very flexible because there are lots of settings options. thank you team

  9. Alyce Milner

    Hi nice app. tiny question I could not add separator.

    • Someka

      Dear Alyce,

      In the Auto SKU Generator section, you should select “Yes” and choose your separator from the related section.
      In the Custom SKU Generator section, you can select your separator from the “Separator” dropdown.
      Please see the images below.



Leave a customer review

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