---
title: Hyperlinks from Google Sheets
description: "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.…"
url: "https://ninjatables.com/docs/hyperlinks-from-google-sheets/"
updated: "2025-06-02"
category: Advanced Mode (Classic Table Builder) / Customized Settings
---

# Hyperlinks from Google Sheets

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.

![Change Column Data Type for Hyperlinks](https://ninjatables.com/wp-content/uploads/2022/11/image-3.png)

When you create a "Google Sheets data table" with this sheet, the column with links will initially remove the links and keep the texts.

![Links in Google Sheets](https://ninjatables.com/wp-content/uploads/2022/11/Links-in-Google-Sheets-1024x409.png)
Removed links from Google Sheets

- 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**."

![](https://ninjatables.com/wp-content/uploads/2022/10/HTML-Field.webp)
Change data type

- Update the column settings and check the table preview.

![clickable links from Google Sheets](https://ninjatables.com/wp-content/uploads/2022/11/clickable-links-from-Google-Sheets-1024x329.png)
Clickable links from Google Sheets

Now the links from Google Sheets are clickable hyperlinks.