0

How can I make a hyperlink from Google Spreadsheet cell to an Excel file? For example the hyperlink is in Google Spreadsheet and opens the Excel file. The Excel file is on the hard disk not on Google Drive.

  • by standard means, you can't but maybe with some script, it would be possible... – user0 Sep 11 '18 at 20:15
0

It looks to me that this isn't possible to do directly on a Google Sheets cell I tried to use the the file:// URL protocol but it isn't automatically converted to a link and the Ctrl+k and HYPERLINK built-in function don't work.

I tried on Windows 10 64bit, Chrome 69 and Internet Explorer 11.

One alternative could be to use Google Apps Script to create a custom dialog or sidebar. For details please checkout https://developers.google.com/apps-script/guides/dialogs

NOTE: I think that only Internet Explorer will be able to open an Excel file directly on Excel from a file:// link.


From the answer to How to specify a local file within html using the file: scheme?

URL. So you would need file:///home/User/2ndFile.html (on most Unixes), file:///Users/User/2ndFile.html (on Mac OS X), or file:///C:/Users/User/2ndFile.html (on Windows).

  • is it passible that i opens the file directly white a link? Now must i download the file and the new save location is the map downloads. – Dijkgraaf Sep 12 '18 at 17:58
  • Apparently it's not possible directly on a Google Sheets cell. – Rubén Sep 13 '18 at 16:29

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.