Bitly Bulk URL Shortener Tool

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

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

Get a Bitly Account

Go get a free 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 URLs

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

Your 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 39319

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.

    • 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.

  2. Karri

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

  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?

  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?

    • 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.

  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?

  6. Zarabianie na Blogu

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

  7. Rob Morrow

    Thanks for sharing mate! It really helped a lot!

  8. Maheshwar

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

  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!!!

  10. JaimeJCandau

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

  11. FreeDomain

    How about 10k urls in bulk?

  12. Arkadi

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

  13. ECRoyce

    Great little Gdocs applet. Thank you!

  14. Wreifu

    Great Doc! thanks for share!

  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.

  16. Br

    If you want an offline version, download as CSV

  17. Erika Can

    OH. MY. GOD.
    That works flawlessly!

    Thank you so much!

  18. Matt Scofield

    Super helpful thank you!!

  19. Lyndsey

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

  20. Megan

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

  21. randy siegel

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


Leave a Reply

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