Revision history [back]

To retain the hyperlink when utilizing the =QUERY function in Google Sheets, use the following method:

1. Insert a new column next to the column that contains the hyperlink.
2. In the new column, use the following formula to extract the hyperlink: =HYPERLINK(A1)
3. Replace the A1 with the cell reference of the hyperlink you want to extract.
4. Copy the formula down the entire column.
5. In the =QUERY function, refer to the new column instead of the column that contains the original hyperlink.