Use Google Docs to Create Short URLs

Published in: Google Docs

The spreadsheet component of Google Docs provides some useful functions for importing web data into your online documents. For instance, you can use the importFeeds function to manipulate RSS in Google Docs while the importHTML function helps you fetch information from a live web page into Google Docs.

This Google Spreadsheet demonstrates how one can use these import functions in Google Docs to convert web addresses into tiny URLs on the fly. You may have to create a copy of this spreadsheet into your own Google Account for entering new data or for modifying the cell formulas.

Also check this tutorial on how to setup TinyURL like redirection service for your own website in two minutes using Google Apps.

This spreadsheet, written by developers, makes a call to the API as soon as a URL is entered by the user and displays the API response in the short URL column. Internally, it uses the importData function which is normally used to display CSV data in Google Docs.

Cell A1 (input field): User enters a URL

Cell B1 (result) =importData(concatenate(”“,A1))

Also see: Build a Web Page Monitor with Google Docs

TinyURL vs. was initially the most popular URL shortening service on the web but that’s fast changing because the service didn’t really add anything new in the last so many years. On the other hand, provides web statistics (so you can track clicks), has an API and users can create their own account on (see example) to track their complete history of shortened links.

market share of url shorteners

Maybe that explains why Twitter switched away from TinyURL and as a result, recently managed to eclipse TinyURL and is now the most popular URL shortening service at least among the Twitter glitterati.

Published in: Google Docs

Looking for something? Find here!

Meet the Author

Web Geek, Google Developer Expert
Amit Agarwal

Amit Agarwal is a Google Developer Expert in Google Workspace and Google Apps Script. He holds an engineering degree in Computer Science (I.I.T.) and is the first professional blogger in India. He is the developer of Mail Merge for Gmail and Document Studio. Read more on Lifehacker and YourStory

Get in touch