In this article:

How to Shorten a Link in Google Sheets (Easiest Way in 2024)

May 8, 2024

How to Shorten a Link in Google Sheets

Follow the steps below to shorten a link in Google Sheets. 

1. Install the Bitly Add-on

Open Google Sheets and go to `Extensions > Add-ons > Get add-ons`.

how to shorten a link in google sheets

Search for a URL shortener add-on. Click on an add-on and then click "Install".

how to shorten link in google sheets

Follow the prompts to install the add-on to your Google Sheets.

shorten google sheets link

2. Open the Add-on

After installation, go to `Extensions > Advanced URL Shortener > Start.

shorten link in google sheets

You should see the Bitly add-on listed. Click "Connect to Bitly" to open its menu, then select any option provided by the add-on to start it. You may need to authorize the add-on to use your Bitly account the first time.

how to shorten a link on google sheets

Follow the add-on's setup process, which may involve logging into your Bitly account and authorizing the add-on to access your account. This step is crucial for the add-on to shorten URLs using your Bitly account.

3. Enter URLs to Be Shortened

Type or paste the URLs you want to shorten into a column in your Google Sheet. Ensure each URL is in its own cell, starting from, for example, A1 downwards.

5. Use the Add-on to Shorten URLs

This add on's free version only supports one URL at a time. You can upgrade to premium if you prefer to shorten more than one URL at a time. Select the cell with the URL you wish to shorten. Then, go back to the Bitly add-on menu under `Extensions > Add-ons`, and select the option to shorten URLs.

Select "Shorten selected" to shorten the URL you selected. Then, click the "Process" button.

6. View Shortened URL

The add-on will replace the original URL with their shortened versions directly in your sheet or insert them in an adjacent column, depending on the add-on's functionality. Review the shortened URLs to ensure they've been correctly processed. 

We hope that you now have a better understanding of how to shorten a link in Google Sheets. If you enjoyed this article, you might also like our article on how to set up a Google Sheets recursive formula or our article on how to voice type in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->