Required sizes for SharePoint sites where located in excel

Hi All

 

Could you please help me in getting PS script for the following query

 

Source file is having list of site urls for which site size's is needed. These sites can be listed in the file at the sub site level as well.

 

Thanks in advance