Wednesday, December 3, 2008

Reduce those long URLs in batches

Kortina from bit.ly posted this spreadsheet which is actually a tool tied back to his URL shortening service. This is a good use of the ImportData() function within Google spreadsheets... it allows entry of lots of original (long) URLs, then creates a call to the bit.ly service (which, itself is a simple URL), then uses the importdata() function to get back the answer (the shortened URL)... Try this to learn a few new tricks.

Site:bit.ly blog
Page/Post:bit.ly meets Google spreadsheets
Spreadsheet:bit.ly shortener spreadsheet
Get Your Own Copy