I work for a sporting organisation and track all sorts of monitoring variables using Excel spreadsheets. Up until now I have used macros in Excel to do this, but this requires players taking it in turns to do it on one computer and takes up a lot of time. To make it easier for the athletes I would like them to be able to access a form online and potentially fill it in on their phones. However the Google Docs version of Spreadsheets lack the functionality to analyse the data in the detail I would need to. Is it possible to link the Google Form up to an Excel document on my desktop so that when someone fills in the form the data turns up on the desktop sheet?

  • 1
    It's possible to publish a Google Sheet as a html or as csv file. Excel could connect to both formats, but that could be a matter of another site, like superuser.com. By the other hand there are APIs that could be used to get the data, but that could also be a matter of another site, perhaps stackoverflow.com
    – Rubén
    Sep 17 '15 at 21:54

As far as I am aware, this is not possible, given Excel's incompatibility with Google Apps Script.

There is an alternate and only slightly less efficient solution, though: each time you want to analyse the results of your Form, simply download the connected Google Sheet as an Excel spreadsheet, open the downloaded spreadsheet in Excel, and do your analyses as per usual. To download the Google Sheet as an Excel file, go to File -> Download as -> Excel spreadsheet (.xlsx) in Google Sheets.

  • I thought that may be the case! Cheers anyway :)
    – matthew
    Sep 17 '15 at 18:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.