Easy Data Transform outputs as text, number or date. However you can either:
- Output HYPERLINK() functions to a .csv file and open this .csv file in Excel.
For example use the Substitute transform to turn:
See this .transform file for an example:
urls.transform (1.6 KB)
This will then display as a clickable “Google” link in Excel.
(There doesn’t seem to be a way to do this for writing to .xlsx files)
- Output to a .xlsx file and manually modify the appropriate column type to hyperlink format:
(you will need to do 2 again if you output the .xlsx file again)