Follow the steps below to shorten a link in Google Sheets.
Open Google Sheets and go to `Extensions > Add-ons > Get add-ons`.
Search for a URL shortener add-on. Click on an add-on and then click "Install".
Follow the prompts to install the add-on to your Google Sheets.
After installation, go to `Extensions > Advanced URL Shortener > Start.
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.
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.
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.
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.
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.
