Bitly Bulk URL Shortener Tool

Okay so you have 50 URLs and you want to convert them all into Bit.ly shortened URLs. But you don’t want to manually copy 50 URLs into bit.ly, and then manually paste 50 URLs out of Bitly.

Here is a tool you can use to mass shorten up to 50 bit.ly URLs. This simple tool uses Google Docs and the bit.ly API to automate the process. Here is how you do it.

Get a Bitly Account

Go get a free bitly.com account and log in to your account. Go to your account settings page. In settings, under advanced, you’ll see “OAuth Applications”, click the link and create a Generic Access Token (have this page open as you’ll need the keys in the the next steps).

bitly oauth registration

On this page you need to confirm your Bitly password and go ahead and click “generate token”.

Bitly Generic Access Token

Get the Google Docs spreadsheet

Sign in to your Google Drive account and click this link to download the Google Docs spreadsheet

A copy of the spreadsheet will open. Now go to “File” -> “Make a copy” (Important: as this creates a copy which you can edit)

Google spreadsheets

Start Creating Bulk Bit.ly URLs

Place the access token you generated in the earlier step into cell A3. Paste your URLs into cell A6

Your bit.ly shortened URLs should now appear in the Short URL column (column B6).

bitly bulk shorten urls

Et voila, it’s as simple as that

with 34 comments 2 27353

34 comments on “Bitly Bulk URL Shortener Tool”

  1. carole scott

    This works only if I keep the document on google drive. If I download it, the formulas all work initially but then if I close and then reopen my spreadsheet, it gets screwed up. So strange.

    Reply
    • Matt @ HostingKingdom

      That’s right Carole, won’t work ‘offline’ as the ‘formulas need to talk with’ the Bitly API. Haven’t tried it but the Google Drive Desktop app might work, let’s you work with docs and spreadsheets offline and it automagically saves and syncs.

      Reply
  2. Karri

    OMG. I have needed this since forever. Thank you SO very much for creating it!

    Reply
  3. Alex

    Same here! Thank you very much for this useful hint!
    After I shortened 250 links I got a “Rate Limit Exceeded”- error message. I expected this error much earlier. Does anyone know how long I have to wait before I can continue?

    Reply
  4. Duncan

    I’ve been using this for a couple of weeks and love it, but recently I’m seeing a message that I’m about to reach the ImportData limit of 50 (?)

    I’ve managed to find so far, that the new version of Sheets doesn’t have this limit, but when I’ve tried to copy the function in to a new version it tells me that urlencode is an ‘unknown function’

    Any ideas on creating this same tool in the new Sheets?

    Reply
    • Matt @ HostingKingdom

      Hi Duncan, glad you like it. I haven’t experienced this, not sure if this will work but instead of copying the formulas into a new spreadsheet, see if making a copy of the spreadsheet works (top menu > file > make a copy). Let me know how you go.

      Reply
  5. Ellory Wells

    Awesome tool! Thank you!

    Do you know if there is a way to Title the links within a given parameter? For example, I’d like to shorten links with a title in order – Podcast 1, Podcast 2, Podcast 3, etc. or another batch, Blog 1, Blog 2, etc.

    Is this possible?

    Reply
  6. Zarabianie na Blogu

    really good guide. I never thought that bitly can be used to mass-shortening links!

    Reply
  7. Rob Morrow

    Thanks for sharing mate! It really helped a lot!

    Reply
  8. Maheshwar

    Hey, thanks for this simple and useful tool and a detailed write-up ! Loved it !

    Reply
  9. Cathrine Pitsi

    You have no ideaaaaaa what this done for me, everyday I have been converting 38 urls’ one after the other…Best thing that’s happened this week lol. Thanks Guys, ya’ll ROCK!!!

    Reply
  10. JaimeJCandau

    Ohhhh….. I LOVE THIS. Huge thanks Matt!!!!

    Reply
  11. FreeDomain

    How about 10k urls in bulk?

    Reply
  12. Arkadi

    Excellent. This does work! (some do not)
    Thank You!

    Reply
  13. ECRoyce

    Great little Gdocs applet. Thank you!

    Reply
  14. Wreifu

    Great Doc! thanks for share!

    Reply
  15. Ralph Tyrell

    Thank you Matt for this post. You just saved me a whole lot of time! To be honest with you my eye first glazed over when I glanced at the API steps, but it was very well explained an incredibly simple.

    Reply
  16. Br

    If you want an offline version, download as CSV

    Reply
  17. Erika Can

    OH. MY. GOD.
    That works flawlessly!

    Thank you so much!

    Reply
  18. Matt Scofield

    Super helpful thank you!!

    Reply
  19. Lyndsey

    Is anyone finding that bit links are not being created well and constantly loading or coming pu with N/a?

    Reply
  20. Megan

    This is amazing. It just saved me soooo much time. Thanks!

    Reply
  21. randy siegel

    can this be done for 2000 links by creating 40 different files?

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *