2 Replies Latest reply on Nov 7, 2016 2:08 AM by beverly

    Export URL to spreadsheet

    CarlSchwarz

      I am exporting data to a spreadsheet.  One of the columns contains a google maps URL

      e.g. https://www.google.com/maps?q=24.9126932+128.5997741

      When the Spreadsheet is opened that cell just shows as text and not as a clickable URL.

       

      Is there a way to make that URL a clickable URL by default in the spreadsheet?

        • 1. Re: Export URL to spreadsheet
          PeterWindle

          Interesting... I have never tried this before, but I had a think about this... and thought that the perhaps the formatting of the columns in your spreadsheet would need to be included in the export, so I found this article about using XML for formatting and use with Excel.

           

          Formatting Excel Report In FileMaker While Export – PART 1 | Extreme FileMaker

           

          I would think (not tried) that the URL format should also be determined using this technique?

          • 2. Re: Export URL to spreadsheet
            beverly

            The best way to see what Excel wants as XML, is to create a sample spreadsheet with these kinds of 'objects'. Then export from Excel as XML and open in a text editor. The hyperlink, for example, will have different attributes than a standard text field. The XSLT should have the way to transform the 'Url-in-field' into the desired hyperlink. Caveat: urls in fields with other text will likely not be able to be transformed so easily as the field that is just an URL.

             

            Sent from miPhone