topic Re: Hyperlinking to excel file on GIS Online in ArcGIS Online Questions

Hyperlinking to excel file on GIS Online

NicholasTorrance — Mon, 17 Apr 2017 23:47:01 GMT

Is there a way to create a hyperlink from GIS Online to an excel file. I am trying to create a link from an interactive map to excel files I have associated with each point on my map.

Re: Hyperlinking to excel file on GIS Online

Anonymous User — Tue, 18 Apr 2017 17:01:56 GMT

Are the Excel files on your computer or are they stored somewhere online (i.e google drive)?

Re: Hyperlinking to excel file on GIS Online

KellyGerrow — Fri, 21 Apr 2017 00:17:48 GMT

HI Nicholas,

There are a few different ways to accomplish this, depending on where your excel file is located and how it needs to be referenced by your data. If you have the same excel document for all, then you can add the link during the pop up configuration process. If you have a different excel document for each feature, you are going to want to add a string field to your data set and add the url to your excel document as a field. If you include the url field in a pop up it will be automatically hyperlinked.

If the link is accessible on the internet, then adding the url using the above mentioned workflow is straight forward. If you have a document locally, then you will need to add your file to a local web server as described in this post https://community.esri.com/message/489020?sr=search&searchId=346230c2-a246-4c42-9415-6dfa4bd58175&searchIndex=0‌. Remember that if your file is local only users on your network who have access to the document will be able to access it.

-Kelly

Re: Hyperlinking to excel file on GIS Online

JenniferCarter1 — Tue, 19 Jun 2018 19:46:37 GMT

Kelly,

I have an Excel spread sheet that has embedded URL's field called cameras, located here. https://phenocam.sr.unh.edu/webcam/network/table/PHENOCAM

When I convert to a CSV file it losses the hyperlink. Also when I upload the Excel in Pro the hyperlinks are not embedded any longer. Any solutions?

Thanks,

Re: Hyperlinking to excel file on GIS Online

KellyGerrow — Fri, 22 Jun 2018 21:29:27 GMT

Hi Jennifer,

This appears to be an html table and not an excel table. Is there a download option? How are you importing the specific data? If this could be downloaded as Excel, the hyperlinks should remain. What do the html links look like in the csv file? Are you able to upload the specific csv or excel file?

-Kelly

Re: Hyperlinking to excel file on GIS Online

JenniferCarter1 — Tue, 26 Jun 2018 15:46:06 GMT

I downloaded it and it is a PDF which I saved as an Excel sheet. When I save it as a CVS file the hyperlinks are lost.