Here you can download the free Excel spreadsheet: market-concentration-template
This template also calculates the Herfindahl-Hirschman index = HHI.
Please check out the other free Excel templates on this website.
The spreadsheet should look like this…