Data Collection Template

This Data Collection Template has been designed to support Sported member groups who are at the beginning stages of exploring data collection. It is a basic template for entering and compiling data about the people that attend your group and because it’s built in Excel, there are no expensive subscription fees or software requirements. 

We hope the template can act as an introduction to the area of data collection and analysis, allowing your group to capture and analyse your data at a basic level, enabling you to make informed decisions about your provision and activities.  It will also help you to make informed decisions around any future investments in impact measurement tools.  


You can download the Template below. Please save a copy to your desktop before adding any data. The Data Collection Template User Guide is available to download by logging into Your Sported Network.  The User Guide contains the password to unlock the template.


Click on the link to download document  Sported’s Data Collection Template



Below is a populated version of the template. This is available to browse, but not edit.

Click on the link to download document  Sported’s Data Collection Template – Populated example

IMD data

Index of Multiple Deprivation (IMD) is an official national measure of how deprived an area is, on a scale of 1 to 10. ‘1’ means it is among the most deprived areas in the country.


You can add this information to the Data Collection Template. This can help to demonstrate the type of community and beneficiaries you serve.


IMD is calculated independently for the different nations. You can check IMD areas from the following resources. Please see further information within the ‘Participants’ section of the Data Collection Template.


England Visit IMD look-up for England 

Scotland Visit IMD look-up for Scotland 

Wales Download IMD look-up for Wales

Northern Ireland Download IMD look-up for Northern Ireland

Why collect data?

Your ‘data’ is information (facts and numbers) that you hold about what you do. Collating this data is important as it enables you to:


Make informed conclusions about your work – you may have inspirational stories about the work you do but if you make big conclusions based on one person or example your conclusions could be unreliable or unrealistic. Data is important because it demonstrates that your ‘success stories’ are not just one-off situations.


Improve your service delivery – these conclusions help you to understand ‘what works’ and you can adjust your planning or strategy accordingly.


Demonstrate your reach and impact to stakeholders – showing who you are delivering to, what you are delivering, or what difference your programmes are making. These stakeholders could be prospective funders.