( by Chris Gob Shite )
I have a google form which is capturing data that is saved in a Google Sheet
I want to merge that data into an official form in MS Word
MS Word will only merge with an Excel sheet and not a Google Sheet
Currently just copy/pasting everytime there is a new entry
Any Sheets gurus know how to Create a dynamic link from an Excel Sheet to a data in a Google Sheet?
Following are steps that will allow you to get the data from Google Sheets to MS Excel:
Click "Properties" in Data tab, and then Click on the check box "Refresh every" and set the time. Also click "Refresh data when opening the file", if you need it.
You are done...!!
Enjoy auto Importing of data from Google Sheets to Microsoft Excel.
When you close MS (after saving it) and open it again, you might notice "Security Warning"
Click on "Options", and then you can "Enable this content" and click "OK"..
But if you don't want to do it every time you open your Excel then you can click on "Open the Trust Centre".
Click on "External Content" and then choose "Enable all Data Connections" and "Enable automatic update for all Workbook Links".
Finally you are done.