Combinations Generator Excel Template 2023 – Free

A few months ago, I published a video (on YouTube) on how to create combinations of values in 2 lists. There have been requests to expand that to more than just 2 lists. So, here we go. I updated the formulas to accommodate 6 lists and made it into an easy-to-use free template.

Combinations Generator Excel Template
Combinations Generator Excel Template

Free Download

How to create combinations in Excel?

This Excel Combinations Generator is one of the simplest templates published on

Just enter your values in each list (max 6) and see the combinations automatically calculated and displayed.

Combination Excel Generator Template

You can also change the separator (character that separates the values in the concatenated string of values)

When entering data, ensure the following are avoided

Video Demo


For more functionality, please try our Combinations Generator toolkit

Exit mobile version