Google-sheets – How to make a hyperlink from Google Spreadsheet cell to an Excel file

google sheetsmicrosoft excel

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.

Best Answer

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).

Related Solutions

Google Sheets – How to Add a Hyperlink to a Cell

It is the HYPERLINK function in the format of =HYPERLINK(URL; TEXT TO DISPLAY)

e.g.

=HYPERLINK("www.google.co.uk"; "Google")

Do not forget there is semicolon used between the actual link from the text.

Google Sheets – Generate Hyperlinks from Cell Contents

Assuming your values are in column A, you can do this in column B:

=HYPERLINK(CONCATENATE("http://mywebsite.com?id=",A1);"link text")

Then you can auto-fill down the rest of the column.

If you want the text of the link to be the same as the id you're linking, that's as simple as

=HYPERLINK(CONCATENATE("http://mywebsite.com?id=",A1);A1)

Best Answer

Related Solutions

Google Sheets – How to Add a Hyperlink to a Cell

Google Sheets – Generate Hyperlinks from Cell Contents

Related Topic