5 reviews for Combinations Generator Toolkit – Excel Template
Combinations Generator Toolkit – Excel Template
Combinations Generator Tool kit Excel Template
Combinations Generator Toolkit is a collection of Combination Generator Excel Templates that will allow you to instantly generate combinations from single list or multiple lists.

Let us take a couple of examples to illustrate the functionality of the templates.
For example, let us take a list of 4 car manufacturers: Audi, BMW, Cadillac and Dodge. If we would like to generate combinations of them with 2 items, we would get 6 combinations, as shown below.
Audi – BMW, Audi – Cadillac, Audi – Dodge, BMW – Cadillac, BMW – Dodge, Cadillac – Dodge
The template would help generate this for your list of items.

If we want to generate combinations of 3 items at a time, we can change the R to be 3. Now, we would get 4 combinations as listed below.

If we need to pick an item from each list and we have 3 lists, the Multiple Lists version can support that.
If we have car manufacturers in list 1 (Audi, BMW, Cadillac), Type of car in the second list (Sedan, SUV) and Number of doors in the third list (2 Door, 4 Door).

The template can now generate the following 12 combinations automatically.

The single list and multiple list (with limits) is supported on Excel version 2016 and higher.
This combination generator can include up to 15 lists and allows you to include any number of items per list, per your need. To include more items per list, extend the table.

If we have 6 lists with varied items count, and need a combination for all the six lists (R=6)

The template can generate the required combinations, as shown below.

Please note that the combinations should be within the limit of the number of possible rows allowed in excel. As the number of combinations generated gets nearer to the limit value, it might take a few seconds to populate the combinations, based on your system performance.
The multiple list (without limits) is supported on Excel with a Excel 365 subscription.
For a good overview of Combinations and Permutations, please visit https://www.mathsisfun.com/combinatorics/combinations-permutations.html
All files are free. Download only the ones you need.
Some sheets are protected so their formulas aren’t changed by mistake. To unprotect a sheet, choose Review › Unprotect Sheet and type the password indzara (how to unprotect sheets).
| File Name | Download |
|---|---|
| Combinations Generator Single List No Repetitions v1.0 | Download Now |
| Combinations Generator Multiple Lists v1.0 | Download Now |
| Combinations Generator Multiple Lists Extended v1.0 | Download Now |
Combinations Generator Toolkit – Excel Template
Yes. Every INDZARA template is free to download, and there are no recurring fees.
See Can the file be shared? License Terms for how you can use and share the files.
Some sheets are protected so their formulas aren’t changed by mistake. To unprotect a sheet, choose Review › Unprotect Sheet and type the password indzara (how to unprotect sheets).
Start with the guides below. Our knowledge base has step-by-step articles for every template, and you can always ask us.
I use the Multiple List Version of the template to create unique SKUs for my client’s ecommerce stores. Being a software engineer, I appreciate the elegance of this offering.
An amazing addition to my automation workflow. Can churn out 5000 different combinations in a simple few steps, much better than doing by hand!
Excellect
Such a fabulous tool ! Really saves a lot of time !
Super work sir