I have been collecting data for literature review and was wondering if there is a way to retrieve all results obtained from google scholar in the form of an excel sheet or end note copy?
You can try data repositories, such as Dryad, for the source data. Otherwise you can directly ask the authors for it, but invariably this is unsuccessful :)