Click this link for the free download of the cluster-analysis-marketing-free-template-updated-2019
NOTE: This Excel template has been designed to work with Excel 2010 and later. It had been updated in 2019.
How to download the cluster analysis template
- Click the above link to download
- Save the ZIP file – open/extract the Excel template
- Open the Excel file – please note that only Excel 2010 or later versions will be able to run the built-in cluster analysis calculation – please contact me via email if you have any problems.
- Click to enable editing.
- Click to enable macros (click the ‘enable content’ icon).
- Add in Excel Solver (if required) – please see full instructions in the spreadsheet template.
- Follow the instructions in the spreadsheet – or review the instructions first or watch a how to use video.
Premium clustering Excel template
Please note that a more advanced version of the above free spreadsheet is available on this website. This more advanced clustering template allows you to create up to 10 clusters/segments, using up to 20 attributes, and up to 1,000 responses. Click here for further details.