University data on societies to be captured on a spreadsheet

We are looking to capture the information of every single student's university society into one sheet. For 10 UK universities, we want to capture all of their student's societies and capture the following information (if available):

- University Name
- Name of Society
- Presidents name of the society
- URL of the society (if exists)
- Email address of President
- Facebook link
- Number of facebook followers
- The type of society e.g. International, sport etc
- Other tags for the society e.g. rugby, football

Each universities student union page has a list of all of their societies like the below example

http://studentsunionucl.org/clubs-societies/directory

then using an example of one of the societies (just picking the first one) the following would be the information:

- University Name: UCL
- Name of Society: 180 Degrees Consulting Society
- Presidents name of the society: Wiebe Willemsen
- URL of the society (if exists): https://180dc.org/branch/ucl/
- Email address of President: 180dc.ucl@gmail.com
- Facebook link: https://www.facebook.com/180dcucl
- Number of facebook followers: 1,450
- The type of society e.g. International, sport etc: Business
- Other tags for the society e.g. rugby, football: Consulting

We would need that for 10 universities and we would provide and there are generally about 80-100 societies per uni :

- List of Universities
- How to find the list of societies
- Example of one filled out
- Spreadsheet template prepared