Consider a user who has a data table in Google Sheets and wishes to import the table from Google Sheets to Ninja Tables. If the table contains hyperlinks, he would want the links to work in Ninja Tables as well.
But if the hyperlink is erased after the table is imported, the table does not serve its purpose. This is because the hyperlinked data cannot be saved after the table is converted to CSV.
But Ninja Tables will bring the links back just by changing the data type!
HTML Data Type for Hyperlink from Google Sheets #
This short guide will demonstrate to you how to include hyperlinked data in your table when it’s imported from Google Sheets.
- For instance, we’ve imported a Google Sheet with three columns named Title, Link Text, and Actual link. This is a dummy table containing information about different mobile phone models.
When you create a “Google Sheets data table” with this sheet, the column with links will initially remove the links and keep the texts.
- The next step is to add the link to the link text column. Simply go to table column configuration and set the data type to “HTML Field.”
- Update the column settings and check the table preview.
Now the links from Google Sheets are clickable hyperlinks.
